Mac excel shortcuts to make the iWork Numbers spreadsheet, you can always betray the Mac excel shortcuts and use the Microsoft program. Excel is arguably the cornerstone of the Microsoft Office suite for Mac excels shortcuts from a business point of view. And this is more than enough reason to be interested in the possibility of using this program more efficiently using excel mac shortcuts.
If you want to know the main Mac excel shortcuts needed while working on Excel spreadsheets for Mac, this guide has everything you need for the average user of this complex program.
The following shortcuts are usually the same in most Mac excel shortcuts programs and in all office suites in general, although there is always some exception that confirms the rule. For users accustomed minimally to excel mac shortcuts work and keyboard shortcuts will not be any novelty. Of course, if they are known, it will be because they are useful and necessary.
Useful Mac excel shortcuts keyboard
|Cmd + N||Open a new spreadsheet|
|Cmd + O||Open an existing document|
|Cmd + W||Close the active window without leaving the program|
|Cmd + S||Save the spreadsheet|
|Cmd + X||Cut selection to clipboard|
|Cmd + C||Copy selection to clipboard|
|Cmd + V||Paste the contents of the clipboard|
|Cmd + P||Print the current spreadsheet|
|Cmd + F||Find text in the active worksheet|
|Cmd + Z||Undo the last action|
|Cmd + Y||Redo the last action|
|Cmd + I||Italicize selected text|
|Cmd + B||Bold selected text|
|Cmd + U||Underline selected text|
Enter data into a sheet
The introduction of data in excel mac shortcuts to more or less large scale can become a hell. Cell after cell and leaf after leaf, formulas, numbers and variables can be infinite. If you want to move between cells mac shortcut keys to fill them with more ease and ease, forget the mouse and use the following mac shortcut keys.
|Ctrl + Option + Backspace||Start a new line in the same cell|
|Ctrl + Backspace||Fill in the selected cell range with the text entered|
|Shift + Shift||Finish entry into a cell and return to selection|
|Tab||Finish entry into a cell and scroll left in the selection|
|Shift + Tab||End the entry in a cell and scroll right in the selection|
|To sup||Delete character to the left of the insertion point or remove selection|
|Direction arrow||Move one character up, down, left or right|
|Shift + F2||Modify a cell comment|
Using the cells and the formula entry line
Finally, this table compiles more specific mac shortcut keys of the program itself. The Formula Builder , AutoSum , the AutoComplete option, the introduction of an array formula mac excel … The use of all these functions can also be accelerated by excel mac shortcuts.
|Ctrl + Shift + Backspace||Enter a matrix formula|
|Recoil||End entry into a cell|
|Escape||Undo the entry in the cell or formulation bar|
|Ctrl + A||Display the Formula Builder by entering a valid function in a formula|
|Cmd + K||Insert a hyperlink|
|Ctrl + U||Edit the active cell and place the insertion point at the end of the line|
|Shift + F3||Open the Formula Builder|
|Cmd + =||Calculate all sheets in all open workbooks|
|Cmd + Shift + =||Calculate the entire active sheet|
|=||Starting a formula|
|Cmd + Shift + T||Insert the formula Autoutosuma|
|Cntrl +;||Include date|
|Cmd +;||Include the time|
|Ctrl + Shift + “||Copy the value of the cell above the active cell or in the formula bar|
|Ctrl + `||Show alternating cell values and formulas on the sheet|
|Ctrl + ‘||Copy a formula from the cell above the active cell or in the formula bar|
|Ctrl + Option + ↓||Show list Autocomplete|
|Ctrl + L||Assign name|
Here’s our compilation of the main keyboard shortcuts of mac excel. The program itself includes many more, but after mastering this already extensive list, you can study other shortcuts of mac excel. These are more dedicated to a user of professional scope and very advanced in the use of data bases and macros.