info@ceoworld.biz
Monday, February 17, 2020

C-Suite Advisory

Incredibly Useful MS Excel Keyboard Shortcuts You Should Know

Computers have minimized human efforts to a great extent, the greater help is provided by introducing shortcut keys in MS Office. Instead of scrolling mouse, just use those shortcut keys for the quick completion of your job. There are hundreds of shortcut keys but here is a small list of vital shortcut keys that will help you a big way.

  1. F1- Open Help
    If you want any kind of help regarding, say formatting, importing and exporting of data, security, and privacy of data, formulas or anything, use the F1 key.
  2. F4- Repeat last action
    Whatever command you have given lately, this function key repeats it on the selected cell.
  3. Ctrl + F – Display find and replace with Find tab selected
    This lets you find any particular element in the whole sheet. Just keep pressing the ‘Find Next’ button unless your search is over.
  4. Ctrl + H – Display find and replace with Replace tab selected
    This lets you replace the selected element with the one you type in the dialog box.
  5. Ctrl + D – Fills the selected cell
    It helps you fill the active cell with the element of the above cell. Press Ctrl + Shift + Down to select multiple cells. Then press Ctrl + D to fill the cells with the original cell.
  6. Ctrl + W – Closes the current workbook
  7. F11 – Insert chart
    It will open a new plain sheet and give you the options for inserting a chart.
  8. Ctrl + Shift + L – Toggle Autofilter
    This enables you to filter any list by the contents of a particular column.
  9. Alt + ↓- Activate filter
    It enables you to filter down your selected data in the ascending or descending order. You can also sort your data based on color. This gives your data clarity to the reader’s mind.
  10. Shift + Space – Select table row
    This enables you to select the entire row (of the active cell) of your table.
  11. Ctrl + Space – Select table column
    This enables you to select the entire column of your table.
  12. Ctrl + A – Select table
    If the active cell is in a table, this shortcut key will select the entire table.
  13. Alt + C – Clear slicer filter
    Slicers provide buttons that you can click to filter table data or even PivotTable data. Additionally, it also indicates the existing filtering state that helps us understand what exactly is shown in a filtered PivotTable. So Alt+C will help you clear the existing filter.
  14. Ctrl + Shift + PgUp/PgDn – Select adjacent worksheets
    It will help you switch between the worksheets. The Page Up key will take you to the previous sheet, while Page down will take you to the later ones.
  15. Shift + Backspace – Select the active cell
    When multiple cells are already selected, it helps you select the active cell.
  16. Shift + Home – Select to the beginning of cell
    It will select the entire row from the active cell to its leftmost one.
  17. Shift + End – Select to end of the cell
    It will select the entire row from the active cell to its rightmost one.
  18. Alt + H + B – Open list of border styles from Ribbon
    It will show you the whole list of border styles which will be applied to the selected cells.
  19. Ctrl + Shift + – : Remove borders
    This will undo the above action.
  20. Ctrl + 0 – Hide columns
    It will hide the entire column of the selected cell. If you want to unhide the same, press Ctrl + Shift +).
  21. Ctrl + 9 – Hide rows
    Likewise, it will hide the entire row of the selected cell. To unhide, press Ctrl + Shift + (.
  22. Alt + N + V – Create pivot table
    This will give you an option to reorganize and summarize the selected rows and columns of data to obtain a desired report.
  23. Alt + A – Get external data
    This opens the data field for you. You can insert data from various sources like, from the web, external links, etc.


Ryan Miller
Senior associate editor at ​the CEOWORLD magazine. Raised in Boston with a Brooklyn accent.
Share via
Copy link