Mac microsoft excel keyboard shortcuts cheat sheet

broken image

Press Command + 1 to open the dialog box. Say you want to change Excel’s date format or currency format, you do so in the Format Cells dialog box. In the Format Cells dialog box, you get access to extensive formatting options for numbers, alignment, fonts, etc. You can also use these shortcuts to undo or remove the respective formatting you applied to a cell.

broken image

Command + I and Command + U will apply the “italic” and “underline” formatting to the selected column, rows, or cells. Select the cell(s) you want to modify and press Command + B to apply the bold formatting. These are commonly used text formatting attributes in Excel and other Microsoft tools. Select the cells, rows, or columns whose font sizes you want to reduce and press Shift + Command + < (the Left angle bracket key). This is equally as easy as increasing font sizes. Simply select the cell, row, or column and press Shift + Command + >. You can also increase the font size of a specific cell, row, or column.

broken image