Top 15 Excel shortcuts

As I’ve described elsewhere, I use Excel a fair amount. To this end, keyboard shortcuts are very useful. Here are some I find to be very useful:

  • Alt and =
    • Sum up a column
  • Ctrl and +
    • Insert a cell
  • Select a row/column and enter Ctrl and +
    • Insert a row/column above
  • Ctrl and -
    • Remove a cell
  • Select a row/colum and enter Ctrl and -
    • Remove a row/column
  • Select a cell and enter Ctrl and Space
    • Select column
  • Select a cell and enter Shift and Space
    • Select row
  • Alt and Enter
    • Line break in a cell
  • Ctrl and Page Up/Down
    • Move right and left between worksheets in a workbook
  • Shift and F2
    • Insert a note
  • Alt and down arrow
    • Shows previously entered values as a dropdown list
  • Ctrl and `
    • Toggles between showing results and showing formulas
  • Ctrl and T
    • Converts selected data into an Excel Table
  • Alt and F1
    • Automatically creates a bar chart from the selected data
  • Select an array of cells and hit Ctrl and Enter
    • Copies and pastes the data in the active cell to the other cells

Posted

in

, ,

by

Comments

By posting a comment, you consent to our collecting the information you enter. See privacy policy for more information.

This site uses Akismet to reduce spam. Learn how your comment data is processed.