Useful Mac excel shortcuts keyboard

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. You can also visit ms Excel shortcut keys for PC

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

Shortcut Function
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 the clipboard
Cmd + C Copy selection to the 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.

Shortcut Function
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 the 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.

Shortcut Function
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 Mac excel shortcuts. 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 databases and macros.

Leave a Reply

Your email address will not be published. Required fields are marked *