• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can't Make Column 300 Pixels Wide [SOLVED]

skidragon02

New Member
Step 5 from the following page instructs me to make the column exactly 300 pixels wide. Unfortunately, there appears to be a width limit of 255 pixels. Am I doing something wrong?


P.S. - I am using Excel 2010.


http://chandoo.org/wp/2013/04/01/unlock-angy-formulas-excel-game/
 
You are mixing up pixels and characters. When setting column width, XL uses character width, which has a limit of 255. When you manually adjust the column width with mouse, you should see a little pop-up tip showing the column width in characters and in pixels.


For me, with Font settings: Calibri, 11 pt, a character width of 42.14 characters = 300 pixels.


On a side note, do make note of the date that post was written... <grin>
 
lol.. Skidragon..


dont make any changes.. In plain sheet.. press F2..

and paste below formula..

[pre]
Code:
=SUBSTITUTE(ADDRESS(BIN2DEC(1&REPT("0",5)),6*7,4)
& CHAR(82)&MID("SMILE",3,2)
& ADDRESS(2^5,57*3,4)
& MID("COOL",3,456789),"32","")
[/pre]

It will open the game in 2010.. all other setting are already pre-setted in lattest patch of 2010 , released in this April..
 
@SirJB7

Hi, myself!

You missed this, man. Or was it Chandoo who kept on sending newsletters when you were convalescent... you should talk seriously to that guy, that's not fair...

Now go back and read all from February to April. Right now!

Regards!
 
Back
Top