Page 1 of 2 12 LastLast
Results 1 to 15 of 20
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Looking 4 Interesting Excel Trivia (2007)

    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
    Regards,
    Rudi

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    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.
    Attached Images Attached Images
    Regards
    John



  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    John Walkenback has some interesting info:

    http://spreadsheetpage.com/index.php/oddities

    And I attached a nice chart...
    Attached Images Attached Images
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    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!!)
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Looking 4 Interesting Excel Trivia (2007)

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

    TX for the link Jan Karel!
    Regards,
    Rudi

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Looking 4 Interesting Excel Trivia (2007)

    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. <img src=/S/drop.gif border=0 alt=drop width=23 height=23> I'll let you try to figure out why. <span style="background-color: #FFFF00; color: #FFFF00; font-weight: bold">Q stands for quarter, there are only four, so the series wraps around</span hide>

    Note, if you don't have fill handles, you get then with Office button, Excel Options, Advanced tab, Editing options.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    That's not unique to 2007 though! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    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...
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    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.

  9. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,819
    Thanks
    133
    Thanked 480 Times in 457 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    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

  10. #10
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Looking 4 Interesting Excel Trivia (2007)

    <img src=/S/rofl.gif border=0 alt=rofl width=15 height=15>

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

    TX all!

    Cheers and appreciate the info <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Regards,
    Rudi

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    Do you place radio buttons in column BBC?

  12. #12
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    and sit and watch column TV for hours...
    Regards,
    Rory

    Microsoft MVP - Excel

  13. #13
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Looking 4 Interesting Excel Trivia (2007)

    I've noticed that when you autofill through the ABS column...the fill suddenly brakes...er...stops!??
    Regards,
    Rudi

  14. #14
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

    <img src=/S/grin.gif border=0 alt=grin width=15 height=15>It sticks in the MUD column too...
    Regards,
    Rory

    Microsoft MVP - Excel

  15. #15
    Silver Lounger
    Join Date
    Oct 2002
    Posts
    1,993
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Looking 4 Interesting Excel Trivia (2007)

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

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •