When you work with Excel, you must avoid using the mouse as much as you can. Using the keyboard only will help enhance your speed a lot, and you will start saving a ton of time!
I understand that remembering Excel shortcuts is a pain, so I have listed below 10 shortcuts which can be remembered easily. I assure you, these are the ones that you will definitely want to use everyday!
Start using these 10 Excel shortcuts first and then once you have been using these on a daily basis, learn more.
I have used a sample data as below to demonstrate all the shortcuts
- Select Entire Column
Ctrl + Spacebar
Keep your cursor anywhere in the column that you want to select, and press Ctrl + Spacebar
- Insert Column / Row
Ctrl + +
Select the column (with above shortcut) before which you want to insert a new column and press Ctrl + +
- Save As
- Select column with data
Ctrl + Shift + Down
Keep your cursor at the beginning of your column, and press Ctrl + Shift + Down. It will select the data to a point where the next cell is blank. So if there is a blank cell in between the data, it will select upto a point just before that.
- Undo & Redo
Ctrl + Z / Y
Undo if ofcourse to undo something you did by mistake.
Redo and to redo something you just Undo’d!
- Auto Filter On/off
Ctrl + Shift + L
- Sort in Ascending Order
Alt – A – S – A (Excel 2013 and higher)
Alt – A – A (Excel 2007 & 2010)
Keep your cursor anywhere in the column by which you want to sort the data, and hit the shortcut key.
- Apply All Borders
Alt – H – B – A
Select the required data that you want to apply borders to, and press Alt – H – B – A
- Auto-fit Column Width
Alt – O – C – A
Select the column and then press Alt – O – C – A.
- Center Align
Alt – H – A – C
Select the cell(s) that you want to center align and press Alt – H – A – C
AND A BONUS ONE!!!
- Go to Previous Sheet / Next Sheet
Ctrl + Page Up / Page Down