We already talked about the hot keys that you must know about if you’re a blogger. Now, let’s turn to the ones that I find myself using constantly in Excel. Of note, there are many, many, many hot keys in Excel, even before you start creating your own, or writing macros that execute on hot keys.
My spouse likes to set one up in Excel that applies a specific style of custom formatting, for example. It’s very handy when you’re constantly working with the same type of data, but in a million different spreadsheets. Click, click, done.
This list here is just the ones that I myself use regularly. I’m also trying to learn some more, as they are so, so efficient. Lately I’ve been learning how to add rows to tables in PowerPoint, Outlook and Word using hot keys. It’s pretty handy for my day-job.
Ctrl + D
This fills a cell with whatever is in the cell above it. Let’s say that the line above says $0.25 and you want this one to say the same thing, then press Ctrl + D. I find it most useful when you are thinking about each line, not necessarily filling a big section with the same value, because there is another way to do which is much faster.
Ctrl + ‘
This fills a cell with whatever is in the VISIBLE cell above it. It works just the same as Ctrl + D, but works in filtered lists. Usually, I am filtering in order to have similar things showing, so this one comes in handy.
Ctrl + R
Just like the last two, this fills a cell with whatever is in the cell to the left. Want to extend your formatting one space over for a new header column? Ctrl + R is your buddy.
Ctrl + Arrow
Use this to jump to the last populated cell in a section. If you want to find out how long a data set is that just dumped from a server, go to a column that has a value in every cell and pop down to the bottom quickly with Ctrl + Down. This jumps to the last cell in a populated area, so if you have stuff in cells A1 through C1, nothing in D1 and stuff in E1 through H1, you’ll end up in C1, not H1 if you press Ctrl + Right.
Ctrl + Shift + Arrow
This jumps around the same way as Ctrl + Arrow, but selects all of the cells. If you want a sum, count and average for a column, row, or grouping, select the whole thing using Ctrl + Shift + Arrow and then look at the bottom right corner of your screen. Fast, fast, fast. And handy.
If you punch F2 while you are in a cell, it will edit the formula in the cell. So? Hitting F2 brings up all of the coloured outlines, so you can see what is what.
This one opens a cell comment to edit, if one is there already, or it adds one and lets you start typing right away.
I am sure that I use more than these on a regular basis, but these ones are my favourite Excel hot keys, for sure. Combine them with some must-know hot keys for bloggers and you are off to the races with a more efficient work day (or work evening!).