+ Reply to Thread
Results 1 to 25 of 25

Friday Teaser

  1. #1
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Friday Teaser

    No prizes, just for fun

    Who can be the first to tell me how I did this?

    Untitled1.jpg

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Friday Teaser

    To avoid spoilers, highlight the next line to read it.
    Set the font size for those rows to something really large and then resized the rows?
    Last edited by xlnitwit; 06-01-2018 at 08:02 AM.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Friday Teaser

    Ahhhhh, xlnitwit, you truly are an Excel god.
    Either that or you need to get out more …

    DominicB

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Friday Teaser

    I know it's just for fun, but I am left wondering what possessed you in the first place ...

    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Friday Teaser

    Quote Originally Posted by dominicb View Post
    you truly are an Excel god.
    Either that or you need to get out more …
    I'm not sure the former can ever be true without the latter as well.

  6. #6
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Friday Teaser

    Ali, are you sitting comfortably …

    Back in the heady summer of August 2006, Excel 2003 was the most recent version, Tony Blair was still 12 months from stepping down, and Steve McLaren had just taken over as England boss after Sven's boys crashed out of the World Cup against Portugal, on penalties.

    Back in those days, I had more time on my hands and used to post at MrExcel as well as here. Back then, their message board was approaching 1 million posts, and there was a general clamour among some of its members to be the millionth poster. I, with my usual style of "dip in, answer a question or two and dip out again" inadvertently made the one millionth post, completely unware that this was going on - indeed, I only found out some days later.

    Mr Excel himself, Bill Jelen offered me a book (a real, live, papery book) as a prize, and I chose Bob Umlas' "This Isn't Excel, It's Magic" and this "trick" was detailed in it. The curious child in me made me try it out at the time, and I thought, "Wow! How cool is that?" Then promptly forgot all about it.

    Then strangely enough, a post I was reading this morning brought it all back to me. I thought "This used to work on Excel 2003, let's see if it works on the newest, shiniest incarnation of Excel?" And you know what? It still does. It seemed a waste to just close it, without doing something more constructive with it, so I put it up on here. And I often wonder, if I hadn't read it in that book, and someone presented me with that image if I would figure it out without chucking in the towel. I'm not very patient with things like that ...

    And that, Alison, is what possessed me.

    And, xlnitwit, if you're still reading and haven't fallen asleep yet, I probably need to get out more, too!

    DominicB

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Friday Teaser

    I was sitting comfortably, yes, and I still am. Should be gardening again, but my daughter told me that I had to have just one afternoon of my half-term holiday just chillin', so here I am.

    Thanks for the detailed backstory - makes perfect sense now.

    NB Please don't call me Alison!

  8. #8
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Friday Teaser

    Ali

    OK. Point taken, but Alison is a perfectly respectable name, but Ali it is.

    Now get gardening, otherwise you'll fall out with your daughter and it's going to start raining soon, and that's it. Summer's over for another year …

    DominicB

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Friday Teaser

    Alison is my name, however, only my mother uses the full version, usually when she's cross with me.

    Rain has been forecast for the past two days down here - it is still to materialise. As for falling out with my daughter: very unlikely to happen today, as she was spoilt rotten durung a retail therapy session this morning. I have done six days in the garden out of the last seven - it can wait until tomorrow!

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Friday Teaser

    That is my new philosophy now, Ali - it can wait until tomorrow/later!!

    I have always been 1 of those men that HAVE to get it done now - it has to be done fast, it has to be done right, and it HAS to be done today!!. Always wanted to finish before anyone else, always wanted to do better then others, and always wanted to be different from others.

    Now, after what I went through, I consider myself on my "bonus" round so as far as that stuff goes...meh
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  11. #11
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Friday Teaser

    @dominicb

    Very Cool. But, cannot figure out how I would ever use that!! Its G & T time, so I'll ponder as I drink.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Friday Teaser

    Alan, if you ponder excel while imbibing in G & T, maybe you need more G and less T?

  13. #13
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Friday Teaser

    Ford

    I'm on it. Lots of G very little T. I have forgotten all I knew about Excel. Off to the movies.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Friday Teaser

    Going to see anything good?

  15. #15
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Friday Teaser

    Book Club. She who must be obeyed has decided.

  16. #16
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Friday Teaser

    Ah, SWMBO! LOL!!!

    We are waiting for and very much looking forward to getting Darkest Hour on DVD and watching it next weekend.

  17. #17
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Friday Teaser

    A Rumpole Fan from long ago!!

    Have not seen Darkest Hour yet. In Steamboat, a very small ski resort town in Northwest Colorado, movies come through for about 3-4 days and are long gone if you miss the window which we often do as there is so much more to do there. Read Ski, Hike, Snowshoe, Bike. Red Box, Netflix and Amazon Prime are our friends there.

  18. #18
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Friday Teaser

    Yes, good old Rumpole!!!

  19. #19
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Friday Teaser

    I wanna see Bill and Ben bwaaaaaa (ok ok so thats showing my age LOL)

  20. #20
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Friday Teaser

    Ok, so I'll be the first one to say, I have no clue how you did this. Does that mean I need to buy Bob's book?
    HTH
    Regards, Jeff

  21. #21
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Friday Teaser

    Format style Normal to be bottom-aligned, select any row, make the font large (60 pt), and then resize the row height.
    Entia non sunt multiplicanda sine necessitate

  22. #22
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Friday Teaser

    Got it, thanks shg.

  23. #23
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Friday Teaser

    Thanks shg. That was going to rot my mind all weekend.
    Dave

  24. #24
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Friday Teaser

    Quote Originally Posted by alansidman View Post
    Very Cool. But, cannot figure out how I would ever use that!! Its G & T time, so I'll ponder as I drink.
    April Fools' Day?

    Or for the hell of it, do it to a colleagues workbook.
    Give him / her a couple of days headscratching wondering what's gone on, then just as mysteriously, fix it again, and keep quiet. Devious, I know...

  25. #25
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,368

    Re: Friday Teaser

    That's beyond devious ...

    Now, who can I try it on ... ???

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 9
    Last Post: 12-19-2012, 01:06 AM
  2. Brain Teaser for a Friday Afternoon
    By Kyle123 in forum The Water Cooler
    Replies: 23
    Last Post: 11-17-2012, 06:55 AM
  3. Weekend Brain Teaser
    By Kyle123 in forum The Water Cooler
    Replies: 7
    Last Post: 09-10-2012, 12:59 PM
  4. How to count all dates in column A using last friday and and next friday friday
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-16-2011, 04:33 PM
  5. [SOLVED] Is this Possible? A bit of a brain teaser if you ask me.
    By Levi in forum Excel General
    Replies: 11
    Last Post: 05-02-2006, 05:40 PM
  6. Replies: 1
    Last Post: 04-10-2006, 02:50 PM
  7. stock level teaser
    By neilwebb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2005, 02:05 PM
  8. Here's a Brain Teaser Question for Help
    By bigwilly11189 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-30-2005, 06:00 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1