You may already be using some of the many convenient keyboard shortcuts available in Excel. But with so many on offer, just how many do you actually know about?
Many users love Microsoft’s keyboard shortcuts. These controls let us perform commands quickly, without the need to reach for our mouse, saving a bit of time and effort.
You may have come across the many on offer from Microsoft Excel, but just how many do you tend to use on a regular basis? We’ve compiled a list below of some of the main ones that you may wish to start putting into practice.
Shortcut | Function |
Ctrl + Z | Undo |
Ctrl + F | Find |
Ctrl + H | Find & replace |
Ctrl + S | Save |
Ctrl + Arrow | Move to edge of region |
Ctrl + A | Select all cells |
Ctrl + Shift + End | Select from current cell to last cell in used range |
Ctrl + Shift + Home | Select from current cell to A1 |
Ctrl +Page Down | Move to next sheet |
Ctrl + Page Up | Move to previous sheet |
Ctrl + N | Open new workbook |
Shift + F11 | Insert new worksheet |
Ctrl + Spacebar | Select columns |
Shift + Spacebar | Select rows |