Related Posts
More Posts
How does everyone spin what happened today?

MAGA!!!
America first!!!
Winning!!!

Additional Posts in Excel Genius
Anyone know what these badges are?

why is index match superior to vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.




Formatting multiple tabs simultaneously. I wanted to standardize the formatting in 10 tabs (e.g. first row of all tabs is colored in blue, cell a2 of each tab has the word “Title”)
I went to each tab and replicated the changes.
Shortcut: Press Ctrl and select each tab. The changes you make on any tab will be reflected on all selected tabs. ALL AT THE SAME TIME. Wasted 3 hours on what should have been 30 mins max
The flip side of it is that, if you select multiple tabs by mistake, you will screw up formulas and formatting; and chances are you won’t even realize until much later. I would love to say this was my worst horror story, but ...
(It also works with keyboard shortcuts: Shift + Ctrl + Page Up/Down)
When I was an intern I didn’t know how to do index match or structured references so I manually copy pasted one row of data after another from one sheet to the the next
I did that for 20,000 rows of data
Long ago I worked for a gas utility call center. Supervisor accidentally deleted some important reference cells, formulas, etc. trying to migrate a spreadsheet and saved. Was awkward spending a few hours doing someone else’s job who got twice my pay because they didn’t know how to do their job, while they got to take an extended break from work.
Back when I was a starry-eyed intern, I tried cleaning an OCR output with formulas (of the type ifs(isnumber(find(“keyword1”,B4)),”label1”,...), so the very calculation-intensive ones 😬). It was a 50k-line file. After literally hours of work and several crashes, I was shown the way and wanted to cry.