No prizes, just for fun
Who can be the first to tell me how I did this?
Untitled1.jpg
No prizes, just for fun
Who can be the first to tell me how I did this?
Untitled1.jpg
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.
Ahhhhh, xlnitwit, you truly are an Excel god.
Either that or you need to get out more …
DominicB
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.
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
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!
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
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!
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
@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
Alan, if you ponder excel while imbibing in G & T, maybe you need more G and less T?
Ford
I'm on it. Lots of G very little T. I have forgotten all I knew about Excel. Off to the movies.
Going to see anything good?
Book Club. She who must be obeyed has decided.
Ah, SWMBO! LOL!!!
We are waiting for and very much looking forward to getting Darkest Hour on DVD and watching it next weekend.
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.
Yes, good old Rumpole!!!
I wanna see Bill and Ben bwaaaaaa (ok ok so thats showing my age LOL)
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
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
Got it, thanks shg.
Thanks shg. That was going to rot my mind all weekend.
Dave
That's beyond devious ...
Now, who can I try it on ... ???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks