Non-adjacent cells can be easily selected by using Ctrl Click in Windows and Command Click in Mac.

Menu Magoosh Excel Blog Everything you need to know about Excel Home Main menu All Posts Excel Formatting Excel Charts Excel VBA Basic Excel Functions and Formulas Advanced Excel Functions and Formulas Excel Classes Return to Content 16 Excel Shortcuts to Make Your Work Easier By Harshita Srivastava on December 11, 2017 in Basic Excel Functions and Formulas 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.

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 dont 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.

Excel Mac Hot Key For Inserting A Row