Excel shortcuts

15 Keyboard Shortcuts for Editing Cells in Excel

If you work with data in Microsoft Excel, you know how important it is to be able to edit cells quickly and efficiently. Luckily, there are a number of keyboard shortcuts that can help you with this task. In this article, we'll share 15 of the best keyboard shortcuts for editing cells in Excel.

1. To select a cell, simply press the letter of the column followed by the row number. For example, to select cell B5, press "5B".

2. To select a range of cells, press the first cell in the range, then hold down the "Shift" key and press the last cell in the range. For example, to select cells B5 through B7, press "5B" and then "7B" while holding down the "Shift" key.

3. To select an entire column, press the letter of the column followed by "Ctrl+Spacebar". For example, to select column B, press "B" and then "Ctrl+Spacebar".

4. To select an entire row, press the row number followed by "Shift+Spacebar". For example, to select row 5, press "5" and then "Shift+Spacebar".

5. To insert a new column, press "Ctrl+Shift+ plus sign (+)".

6. To insert a new row, press "Ctrl+Shift+ minus sign (-)".

7. To delete a column, press "Ctrl+Shift+ minus sign (-)" while the column is selected.

8. To delete a row, press "Ctrl+Shift+ minus sign (-)" while the row is selected.

9. To edit the contents of a cell, simply press "F2" while the cell is selected.

10. To enter a new line within a cell, press "Alt+Enter".

11. To apply the general number format to a cell, press "Ctrl+Shift+~".

12. To apply the currency format to a cell, press "Ctrl+Shift+$".

13. To apply the percentage format to a cell, press "Ctrl+Shift+%".

14. To apply the exponential format to a cell, press "Ctrl+Shift+^".

15. To apply the date format to a cell, press "Ctrl+Shift+#".

These are just a few of the many keyboard shortcuts that can save you time when editing cells in Excel. For a complete list of shortcuts, consult the Excel help documentation or ask your IT department for assistance.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.