Five years into my accounting job before I figured out Excel shortcuts were a thing

I used to manually click every single cell and drag formulas down for hours. My coworker in Denver finally asked why I was taking so long with monthly reports. She showed me Ctrl+Shift+Arrow and Alt+= and I felt like an idiot. Anyone else have a moment where you realized you were making your job way harder than it needed to be?

2 comments

2 Comments

tyler_hall928d ago

Dude I spent TWO YEARS right clicking to copy and paste formulas before someone told me about double clicking the fill handle.

-1

thomas_brown27d ago

Actually the double click trick only works if there’s data in the column next to it all the way down. I spent a good hour thinking my Excel was broken until I realized the adjacent column had blanks. Also, you can just hit Ctrl+D to fill down from the cell above, which is faster if you’re already on the keyboard. The fill handle is great but it’s not magic, it needs a solid column of data to stop at.