1. Manual Calculation Keyboard Shortcut In Mac Excel Spreadsheet
2. Manual Calculation Keyboard Shortcut In Mac Excel Shortcut
3. Manual Calculation Keyboard Shortcut In Mac Excel Tutorial
4. Manual Calculation Keyboard Shortcut In Mac Excel Shortcuts

Moreover, Excel is a spreadsheet developed by Microsoft for Windows, macOS, iOS, and Android devices. However, the main features of Excel are Calculation, Pivot table, Graphic tool and etc Note: These Excel shortcuts are for both Windows and Mac. Excel shortcuts work on MS. Excel 2007, MS Excel 2010, and MS.

• Click on another tab – Excel will stop the ongoing calculation for you if you click on any other tab. Pro tip – If have got really BIG Excel file then try doing your work by switching from automatic calculation to manual calculation. You can do that by clicking Menu Formulas Calculation Options Manual.
• Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time. Learn editing, formatting, navigation, ribbon, paste special, data manipulation, formula and cell editing, and other shortucts.
• 'IF' have a Laptop or an extended Keyboard for a desktop Machine look for a key marked fn. You must press this key down before it will actually do the Word Function. F9 without the key fn key pressed, Does Apple system Functions.

Work with excel as efficient as you can using keyboard shortcuts instead of clicking the mouse. If you take one hand from the keyboard to click the mouse you loose precious time and energy. All you need to know is key shortcuts that do certain action you used to do with the mouse.

Excel useful shortcuts tutorial

I will list bellow the most used shortcuts I know and I work with, so my life is much easier:

Ctrl + “s” saves the current workbook

Ctrl + “c” copy the selected range or current cell

Ctrl + “x” cuts the selected range or current cell. The cut selection disappear only after paste command.

Ctrl + “v” pastes the content copied or cut earlier

Ctrl + “z” undo the last command

Ctrl + “y” reundo the last command. Like if you hit undo and changed your mind, you can go back to the last command

Ctrl + “p” open the print settings window

Ctrl + “f” find values inside the current worksheet. It also has an option to find across the entire workbook

Ctrl + “h” replace certain characters or sub strings with other values

Alt + “=” inserts the following formula: =SUM(above column range). It includes in the SUM all the cells above the current cell if they all have the same content (formulas or constants). It stops when an empty cell is encountered.

Ctrl + “a” selects a range with similar content (limited by borders of empty columns or raws). If the current cell is empty, it selects all the worksheet

Ctrl + “Enter” inserts value in all the cells in the selected range. First you need to select a range and after that to input the value you want to insert in all the cells and hit Ctrl + Enter.

Ctrl + Shift + “%” formats the selected cells as percent

Ctrl + “b” formats cell font as bold

Ctrl + Shift + “L” enables filters in the top row of the current table or range

F9 runs the calculation if the Calculation Options is set on Manual

Ctrl + Tab navigate between opened excel workbooks

Alt + “;” selects only the visible cells so if you copy the selected range, it doesn’t include the hidden rows or columns. You will have hidden cells when you use subtotals or run filters.

There is an easier way of using shortcuts

There are many shortcuts available in excel and one can’t remember all by heart. The thing I do is use a custom ribbon Quick Access Toolbar, in which I insert all the functions I need. After this, running them is very easy, as they take automatically a shortcut number, starting with 1, as you can see in the picture bellow. So I can run any command I need just by pressing Alt + the key number (position) of that command.

Excel shortcuts makes our life easier and all of us should know at least the first 3 shortcuts of the most used commands.

Microsoft Excel is huge in terms of its underlying features and functions. So are the keyboard shortcuts in it. The list can go on and on. What we will do is limit our scope and concentrate only on Function Keys today. We will try and learn the actions associated with F1 through F12, standalone and in combination with keys like Alt, Ctrl and Shift.

We all know the basic moves like how you can move around the sheet and select cells using the arrow keys or press Ctrl+A to select the entire worksheet but there are more complicated shortcut keys that you should know.

Manual Calculation Keyboard Shortcut In Mac Excel Spreadsheet

Must Read: If you wish to explore basic and general uses of function keys read out post on the best and default uses of function keys.

F1

F2

F3

F4

F5

F6

F7

F8

F9

F10

F11

F12

Cool Tip

Manual Calculation Keyboard Shortcut In Mac Excel Shortcut

: Did you know that you can just press Esc

Manual Calculation Keyboard Shortcut In Mac Excel Tutorial

to expand or collapse the formula bar and Delete to remove cell contents? Well, now you know.

Conclusion

So, did you find the list interesting? If you spend most of your day on Excel, I am betting you must have found it helpful. You may not be able to remember and master all of them but I am sure you will recollect the ones you feel will help you lower your efforts.

Note: These shortcuts have been tried and tested with Microsoft Excel 2013. However, most of them should be downward compatible.

Manual Calculation Keyboard Shortcut In Mac Excel Shortcuts

Image Credit: N Hope

See Next: 6 Cool Cell Selection Tips for Microsoft Excel Users
The above article may contain affiliate links which help support Guiding Tech. However, it does not affect our editorial integrity. The content remains unbiased and authentic.

Read Next

10 Essential Microsoft Excel Functions for Data Analysis

Working with data in