Tag Archives: Shortcut

F4: repeat last action

For many things, F4 repeats the last thing you did, whether it's put a border on a cell, change its colour, insert a row, right-align etc. It's a bit hit and miss—it doesn't, for example, repeat data entry. But it's … Continue reading

Navigation: Zipping around the worksheet

When I take over someone's machine to help them out with Excel, whether remotely or in person, the first thing that wows them is the speed at which my cursor moves around the screen to accomplish the task at hand. … Continue reading

Charting shortcut

If you select a range of data and hit F11, Excel will create a default chart on a new sheet based on that data. It's often useful as a throw-away action just to visualise how your data trends. Or you … Continue reading