Jo, my lovely wife quit her job as my partner in crime at Chandoo.org recently and took up a lucrative position at NZ govt. agency. The other day I asked her “how was your day?” when she got home. She smiled and said, “I learned my first Excel shortcut!”.
Guess what it is?
F4.
That is right. The mighty F4 key. You can use it to repeat any action.
Jo was using it to insert rows in her workbook. After inserting first row (using CTRL+ of course), she would press F4 to add more rows as needed.
So next time you find yourself doing the same thing several times, use F4 and save yourself a few keystrokes or mouse moves.
Your mission: What is your partner’s shortcut of the moment?
Take a short break from work. Call / message / ask your partner (or friend, mate, parent or kid) what their shortcut of the moment is? Post it here in the comments section.
What… they don’t use Excel much? May be they should.
More reading: Complete list of Excel shortcuts
19 Responses
CTRL + semi colon to insert the current date.
I use this every day multiple times a day
CTRL+Y which is re-do
Grouping data followed by F4
It saves lots of time ?
F4 in a formula to change that part to relative or absolute
My wife is moving job soon, from a nursing position to a nurse management role. In her previous post she never had to use Excel, so the thing I’m most excited about in her new job is that I’ll be able to help her learn to use Excel!
When I want to copy format of a cell and apply it to more than 1 cell I just double click the format painter icon and click on all cells that I want to format. This saves time rather than clicking on the icon several times. Not sure if this is a shortcut but thought I will share it.
CTRL+SHIFT+L = filter
Select the cells + ALT+;= only visibles
F4, not just for toggling between relative and absolute references!
ctrl+shift+t = reopens last closed tab(s) in Chrome/Firefox
cmd+shift+t on Mac
Strikethrough CTRL5
She’d represent. She’s got a familial reputation to protect.
f4 is used to freeze formula or f4 is used to repeat
Ctrl+End : Select till the entire data till Blank.
Shift CTRL End
Select all the filled cells on the sheet
I think that a hearty congratulations to Jo is in order! Well done. Sohail
ALT + E, the S then F
Copy a formula across all selected cells
Alt+ here :), been a year since we are relying more on excel for reporting of marketing campaigns.
my favourite ones are
1. F2+CONTROL + ENTER to copy the formula without formatting.
2. Control+G to innovate many functions of which rows with blanks cells can be removed without disturbing the data.
Vignesh V
CTRL+G I didn’t know. I use F5.