16 Excel Shortcuts to Make Your Work Easier

Photo credit: PixieMe / Shutterstock.com

Excel is one of the most used softwares for storing and manipulating tabular data. If you have arrived at this blog, I assume that you are an avid user of this software and are desperately in need of some Excel shortcuts to make your work easier. Read on!

Excel Shortcuts: Next workbook or Previous workbook

To open the next workbook, the shortcut is Ctrl + Tab for both Windows and Mac. To open the previous workbook, you should press Ctrl + Shift + Tab.

Excel Shortcuts: Next worksheet or Previous worksheet

Many times we need to switch between various worksheets in the same workbook. The shortcut for doing this task comes in handy and makes work much simpler!

Shortcut to move to the next sheet to the right:
For Windows: Ctrl + PgDn
For Mac: Fn + Ctrl + Down arrow

Shortcut to move to the next sheet to the left:
For Windows: Ctrl + PgUp
For Mac: Fn + Ctrl + Up arrow

Excel Shortcuts: Select All

The shortcut for the “select all” functionality is Ctrl + A. However this shortcut behaves differently in different contexts in Excel.

In the event that the cursor is in a void cell, Ctrl + A chooses the whole worksheet. In any case, if the cursor is in a gathering of bordering cells, Ctrl + A will choose the whole gathering of cells.

This behaviour of Ctrl + A is different when the cursor is in a table. When you use Ctrl + A for the first time, only the table data is selected. If you use Ctrl + A again, then the table header is also selected along with the table data. On using Ctrl + A continuously for the third time, the entire excel worksheet will be selected.

Excel Shortcuts: Go to the first cell in current worksheet

Exploring bigger worksheets can get truly monotonous. Indeed, you can utilize the scroll bars to look over the worksheet, yet using the scroll bars requires lots of patience. If you want to reach the very first cell, that is the A1 cell of the current worksheet, use the following shortcut:

For Windows: Ctrl + Home
For Mac: Fn + Ctrl + Left arrow

Using this shortcut will bring you to the A1 cell right away, irrespective of your current position in the worksheet!

Excel Shortcuts: Go to the last cell in current worksheet

The first question that might arise in your mind is — what is the last cell in a worksheet?
The last cell in a worksheet is at the crossing point of the last column that contains information and the last row that contains information. Many times it may happen that the last cell of the worksheet does not really have any data in it.

Shortcut to go to the last cell of the worksheet:
For Windows: Ctrl + End
For Mac: Fn + Ctrl + Right arrow

One of the uses of this shortcut is to quickly verify if there exists any data in the sheet that you do not know about. It may happen that there is some stray data in a very far away cell in the worksheet. This shortcut comes to rescue and helps you check that. After all, if you want to print your data in the worksheet, you would not want to print 20 blank pages just to find some stray data in some far away cell!

Excel Shortcuts: Selecting a row or a column in the current worksheet

Selecting a row or a column is one of the most common tasks in Excel. Fortunately, there are shortcuts for that too!

Excel shortcut to select a row: Shift + Space
Excel shortcut to select a column: Ctrl + Space

Once you select the desired row or column, you can broaden your selection by holding the shift key along with the appropriate arrow key.

Excel Shortcuts: Expanding or collapsing ribbon

You can collapse the ribbon when you don’t need it and bring it back as and when desired by using the following shortcuts.

Shortcut for Windows: Ctrl + F1
Shortcut for Mac: Command + Option + R

Excel Shortcuts: Adding non-adjacent cells in a selection

Many of the frequent tasks that we do on Excel involve selecting non-adjacent cells. You might want to enter the same data in the selected non-adjacent cells, delete their data, etc. Non-adjacent cells can be easily selected by using Ctrl + Click in Windows and Command + Click in Mac. You need to select the first cell and then hold the Ctrl or Command key while you click on other cells that you want to include in our selection.

Excel Shortcuts: Selecting till the edge of the data

Exploring big tables (say, containing 15,000 rows) at high speed is fun, but you will need to select large groups of cells for doing this. Since you will attempt to do this manually, you will surely take a long time. Really, a very long time.

To avoid scrolling and yet selecting till the edge of the data, you can use the following shortcuts:

Shortcut for Right selection: Shift + Ctrl + Right arrow
Shortcut for Left selection: Shift + Ctrl + Left arrow
Shortcut for Upward selection: Shift + Ctrl + Up arrow
Shortcut for Downward selection: Shift + Ctrl + Down arrow

Even though the cursor moves quickly, don’t worry, the selection will be accurate.

Excel Shortcuts: Finding next match

Finding a piece of text is one of the most common activities done on any software that deals with data. To use the Find feature of Excel, you can use the following shortcuts:

For Windows: Ctrl + F
For Mac: Command + F

Once you have found at least one match, you can keep searching for subsequent matches by using Shift + F4 on Windows and Command + G on Mac.

Excel Shortcuts: Showing the active cell on current worksheet

It happens many times that our cursor gets lost and is nowhere in sight. In such a situation, to bring the cursor back in view, you can use Ctrl + Backspace on Windows and Command + Delete on Mac. You will find the cursor nicely centered in the worksheet.

Excel Shortcuts: Adding a new line inside the current cell

The following shortcuts will help you enter new lines inside the current cell:

For Windows: Alt + Enter
For Mac: Control + Option + Return

Excel Shortcuts: Inserting current date or current time

Shortcuts for entering current date or current time can come handy frequently. Following shortcuts will help you do these tasks conveniently.

Shortcut to enter current date: Control + ;
Shortcut to enter current time: Control + Shift + :

Excel Shortcuts: Bold, Italic, Underline

Formatting text to make it look bold, italic, or underlined is one of the most frequently done tasks in Excel. After all, the important text should stand out from the normal text to highlight its importance!

Shortcut for “Bold” in Windows: Ctrl + B
Shortcut for “Bold” in Mac: Command + B

Shortcut for “Italic” in Windows: Ctrl + I
Shortcut for “Italic” in Mac: Command + I

Shortcut for “Underline” in Windows: Ctrl + U
Shortcut for “Underline” in Mac: Command + U

Excel Shortcuts: Insert rows or columns in a table

For inserting a row or a column using an excel shortcut, you first need to select an entire row or column. Using the shortcut Ctrl + Shift + + in Windows (and Control + I in Mac) will add a new row adjacent to the selected row, or add a new column to the right of the selected column.

You can also insert multiple rows or columns using the same shortcut. For doing that, you need to select the number of rows or columns equal to the number of new rows or new columns you want to insert.

Excel Shortcuts: Delete rows or columns in a table

To delete a single row or column, select it and use the shortcut Control + – (works for both Windows and Mac). You can also delete multiple rows or columns using the same shortcut after selecting them all.

The above mentioned shortcuts will come very handy when you work with Excel. I hope you found them useful and will be using them often. Enjoy easy-working with Excel!

Comments are closed.

Magoosh blog comment policy: To create the best experience for our readers, we will only approve comments that are relevant to the article, general enough to be helpful to other students, concise, and well-written! 😄 Due to the high volume of comments across all of our blogs, we cannot promise that all comments will receive responses from our instructors.

We highly encourage students to help each other out and respond to other students' comments if you can!

If you are a Premium Magoosh student and would like more personalized service from our instructors, you can use the Help tab on the Magoosh dashboard. Thanks!