Excel shortcuts

25 Time-Saving Excel Shortcuts Using the Keyboard

If you work with Excel on a daily basis, you know that even the simplest of tasks can take up a lot of time. From creating formulas to formatting cells, there are a lot of steps involved in even the most basic spreadsheet. But what if there were a way to streamline your work and get things done faster?

There is! By using keyboard shortcuts, you can speed up your work in Excel and get things done in a fraction of the time. In this article, we'll show you 25 of the best Excel shortcuts using the keyboard that will help you work faster and more efficiently.

1. Select a Cell

The first step in many Excel tasks is selecting a cell. You can do this quickly by using the arrow keys on your keyboard. Simply press the arrow key in the direction you want to move and the cell will be selected.

2. Select a Range of Cells

If you want to select a range of cells, you can do so by holding down the Shift key while using the arrow keys. For example, if you want to select cells A1 through A5, you would first select cell A1 and then hold down Shift while pressing the down arrow key four times.

3. Select an Entire Column or Row

To select an entire column or row, you can click on the column or row header. Or, you can use a keyboard shortcut. To select an entire column, simply press Ctrl + Spacebar. To select an entire row, press Shift + Spacebar.

4. Insert a New Column or Row

If you need to insert a new column or row, you can do so by right-clicking on the column or row header and selecting "Insert." Or, you can use a keyboard shortcut. To insert a new column, press Ctrl + Shift + plus sign. To insert a new row, press Shift + Spacebar.

5. Delete a Column or Row

If you want to delete a column or row, you can right-click on the column or row header and select "Delete." Or, you can use a keyboard shortcut. To delete a column, press Ctrl + Shift + minus sign. To delete a row, press Shift + Spacebar.

6. Hide a Column or Row

If you need to hide a column or row, you can right-click on the column or row header and select "Hide." Or, you can use a keyboard shortcut. To hide a column, press Ctrl + Shift + zero. To hide a row, press Shift + Spacebar.

7. Unhide a Column or Row

If you want to unhide a column or row, you can right-click on any column or row header and select "Unhide." Or, you can use a keyboard shortcut. To unhide a column, press Ctrl + Shift + zero. To unhide a row, press Shift + Spacebar.

8. Resize a Column or Row

If you need to resize a column or row, you can do so by hovering your mouse over the column or row header until you see a double-sided arrow. Then, click and drag the header to the desired size. Or, you can use a keyboard shortcut. To resize a column, press Ctrl + Shift + plus sign. To resize a row, press Shift + Spacebar.

9. Move a Column or Row

If you want to move a column or row, you can click and drag the column or row header to the desired location. Or, you can use a keyboard shortcut. To move a column, press Ctrl + Shift + plus sign. To move a row, press Shift + Spacebar.

10. Sort Data in a Column or Row

If you need to sort data in a column or row, you can click on the column or row header and then select "Sort." Or, you can use a keyboard shortcut. To sort data in a column, press Ctrl + Shift + plus sign. To sort data in a row, press Shift + Spacebar.

11. Filter Data in a Column or Row

If you want to filter data in a column or row, you can click on the column or row header and then select "Filter." Or, you can use a keyboard shortcut. To filter data in a column, press Ctrl + Shift + plus sign. To filter data in a row, press Shift + Spacebar.

12. Find Data in a Column or Row

If you need to find data in a column or row, you can click on the column or row header and then select "Find." Or, you can use a keyboard shortcut. To find data in a column, press Ctrl + Shift + plus sign. To find data in a row, press Shift + Spacebar.

13. Go to a Specific Cell

If you need to go to a specific cell, you can click on the cell or use a keyboard shortcut. To go to a specific cell, press Ctrl + G. Then, type in the cell address and press Enter.

14. Enter Data in a Cell

If you want to enter data in a cell, you can click on the cell and then start typing. Or, you can use a keyboard shortcut. To enter data in a cell, press Ctrl + Enter. Then, type in the data and press Enter.

15. Insert a New Worksheet

If you need to insert a new worksheet, you can click on the "Insert" tab and then select "Worksheet." Or, you can use a keyboard shortcut. To insert a new worksheet, press Ctrl + Shift + N.

16. Delete a Worksheet

If you want to delete a worksheet, you can right-click on the worksheet tab and select "Delete." Or, you can use a keyboard shortcut. To delete a worksheet, press Ctrl + Shift + W.

17. Rename a Worksheet

If you need to rename a worksheet, you can double-click on the worksheet tab and then type in the new name. Or, you can use a keyboard shortcut. To rename a worksheet, press Ctrl + Shift + F2.

18. Move a Worksheet

If you want to move a worksheet, you can click and drag the worksheet tab to the desired location. Or, you can use a keyboard shortcut. To move a worksheet, press Ctrl + Shift + P.

19. Copy a Worksheet

If you need to copy a worksheet, you can right-click on the worksheet tab and select "Copy." Or, you can use a keyboard shortcut. To copy a worksheet, press Ctrl + Shift + C.

20. Paste a Worksheet

If you want to paste a worksheet, you can right-click on the worksheet tab and select "Paste." Or, you can use a keyboard shortcut. To paste a worksheet, press Ctrl + Shift + V.

21. Format a Cell

If you want to format a cell, you can click on the cell and then select the "Format" tab. Or, you can use a keyboard shortcut. To format a cell, press Ctrl + 1.

22. Bold Text

If you want to bold text, you can click on the cell and then select the "Bold" button. Or, you can use a keyboard shortcut. To bold text, press Ctrl + B.

23. Italicize Text

If you need to italicize text, you can click on the cell and then select the "Italic" button. Or, you can use a keyboard shortcut. To italicize text, press Ctrl + I.

24. Underline Text

If you want to underline text, you can click on the cell and then select the "Underline" button. Or, you can use a keyboard shortcut. To underline text, press Ctrl + U.

25. Wrap Text

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.