Looking 4 Interesting Excel Trivia (2007)

Topic

New Reply

Hi,

I am creating a presentation that will demo the new Excel 2007 features and capabilities. I am after some additional trivia that I can include in the presentation. I have searched the net and most detail tends to be more technical and problem solving. Does anyone have a website pointer to real trivia (interesting titbits) about the program. For example…things like the amount of A4 paper that will be used if every cell contained a value and you printed the entire sheet. How many pages will print; how high will the stack of papers be if piled onto each other? etc… Anything that is usless info…but really interesting…to jazz up the presentation even more.

Many TX

Reply | Quote

Replies

This is not really an answer to your question, but you don’t need to put something in every cell to generate vast amounts of paper.
Just putting a single character into cell IV65536 puts the page count up to 38,019.

Reply | Quote

John Walkenback has some interesting info:

http://spreadsheetpage.com/index.php/oddities%5B/url%5D

And I attached a nice chart…

Reply | Quote

In Excel 2007 – the bottom right cell reference is XFD1048576 – equates to 17,179,869,184 cells per sheet
(about 2.5 times the number of people on the earth) (6,767,908,320 being approximately the number of people on the earth)

Printing the whole sheet at 100% would use 38,190,012 pages (not sure how many toner cartridges that would be!!)

Reply | Quote

Hi Guys… thanks to all the replies…this is great info.

TX for the link Jan Karel!

Reply | Quote

If you are looking for weirdness, enter P1, Q1 & R1 in the first row and P2, Q2, & R2 in the second row. Then seletct these 6 cells, grab the fill handle, and drag it down to extend the series to row 5. Notice that column 1 & 3 look great: P1 thru P5 and R1 thru R5. BUT, column two has Q1, Q2, Q3, Q4, and then Q1 again. I’ll let you try to figure out why. Q stands for quarter, there are only four, so the series wraps around

Note, if you don’t have fill handles, you get then with Office button, Excel Options, Advanced tab, Editing options.

Reply | Quote

That’s not unique to 2007 though!
One thing to be wary of in 2007 is using three letter range prefixes for range names – TAX2009, for example, is a valid cell reference in 2007!
Oh, and check out the offline help for named ranges…

Reply | Quote

Pre-2007, I used to tell people that you’d need an IV if you filled data to the last column (which is IV).
Now, in 2007, to remember the last column (XFD), I use the phrase “Excel Finally Did It”.

Not trivia but a memory jogger.

Reply | Quote

In Excel2007, for complex spreadsheets I like to put my results in column AHA.
(the enlightenment range)

I try to avoid contentious cells like
AK47
and for explosive results I often start out with
C4

zeddy

Reply | Quote

Geez…there is some interesting reading in this thread now.!!!

TX all!

Cheers and appreciate the info

Reply | Quote

Do you place radio buttons in column BBC?

Reply | Quote

and sit and watch column TV for hours…

Reply | Quote

I’ve noticed that when you autofill through the ABS column…the fill suddenly brakes…er…stops!??

Reply | Quote

It sticks in the MUD column too…

Reply | Quote

When I’m stuck I always go to the GPS and navigate from there, works all the time.

Reply | Quote

The PIE column is a favourite with Americans.

zeddy

Reply | Quote

That’s completely irrational – or maybe I mean the PI column!

StuartR

Reply | Quote

I thought the PI column was for gumshoes especially those with mustaches and driving a ferrari in Hawaii…

Steve

Reply | Quote

In the UK we use the CID column for that, but I guess you might use the FBI column in the USA

StuartR

Reply | Quote

Gosh…this trivia path we are on could go on forever…Maybe we should run the find command and get to the END column since the QUIT column will only be available in the 2010 version.

Reply | Quote