Mac keyboard shortcuts excel windows#

Below is the list of all the major shortcut keys in Microsoft Excel.Д¬trl + A в€’ Selects all contents of the worksheet.Д¬trl + I в€’ Italicizes the highlighted selection.Д¬trl + U в€’ Underlines the highlighted selection.Д¬trl + 1 в€’ Changes the format of selected cells.Д¬trl + 5 в€’ Strikethrough the highlighted selection.Д¬trl + P в€’ Brings up the print dialog box to begin printing.Д¬trl + F9 в€’ Minimizes the current window.Д¬trl + F10 в€’ Maximize currently selected window.Д¬trl + F6 в€’ Switches between open workbooks or windows.Д¬trl + Page up в€’ Moves between Excel work sheets in the same Excel document.Д¬trl + Page down в€’ Moves between Excel work sheets in the same Excel document.Д¬trl + Tab в€’ Moves between Two or more open Excel files.ДЄlt + = в€’ Creates a formula to sum all of the above cellsД¬trl + ' в€’ Inserts the value of the above cell into cell currently selected.Д¬trl + Shift + ! в€’ Formats the number in comma format.Д¬trl + Shift + $ в€’ Formats the number in currency format.Д¬trl + Shift + # в€’ Formats the number in date format.Д¬trl + Shift + % в€’ Formats the number in percentage format.Д¬trl + Shift + ^ в€’ Formats the number in scientific format.Д¬trl + Shift + в€’ Formats the number in time format.Д¬trl + Arrow key в€’ Moves to the next section of text.Д¬trl + Space в€’ Selects the entire column.Д¬trl + - в€’ Deletes the selected column or row.Д¬trl + Shift + = в€’ Inserts a new column or row.Д¬trl + ~ в€’ Switches between showing Excel formulas or their values in cells.ДЇ3 в€’ After a name has been created F3 will paste names.ДЇ4 в€’ Repeat last action.

Mac keyboard shortcuts excel windows#

If you are familiar with windows operating system, you should be aware of most of them.

MS Excel offers many keyboard short-cuts.