MacBook Excel shortcut keys Part 2

 







MacBook Excel Shortcut Keys



Excel is a powerful tool for data analysis and visualization, and MacBook users can take advantage of a variety of keyboard shortcuts to increase their productivity and efficiency. In this blog post, we'll explore some of the most useful shortcut keys for Excel on a MacBook.


Command + N: This shortcut creates a new workbook in Excel.


Command + O: This shortcut opens an existing workbook.


Command + S: This shortcut saves the active workbook.


Command + W: This shortcut closes the active workbook.


Command + Z: This shortcut undoes the last action.


Command + Y: This shortcut redoes the last action.


Command + X: This shortcut cuts the selected cells or text.


Command + C: This shortcut copies the selected cells or text.


Command + V: This shortcut pastes the copied or cut cells or text.


Command + F: This shortcut opens the Find and Replace dialog box.


Command + H: This shortcut opens the Find and Replace dialog box, with the Replace tab selected.


Command + G: This shortcut opens the Go To dialog box.


Command + T: This shortcut inserts a new table.


Command + B: This shortcut applies or removes bold formatting.


Command + I: This shortcut applies or removes italic formatting.


Command + U: This shortcut applies or removes underline formatting.


Command + 1: This shortcut opens the Format Cells dialog box, with the Number tab selected.


Command + 2: This shortcut opens the Format Cells dialog box, with the Font tab selected.


Command + 3: This shortcut opens the Format Cells dialog box, with the Border tab selected.


Command + 4: This shortcut opens the Format Cells dialog box, with the Fill tab selected.


Command + 5: This shortcut opens the Format Cells dialog box, with the Protection tab selected.


Command + ; (semicolon): This shortcut enters the current date.


Command + Shift + : (colon): This shortcut enters the current time.


Command + [ (left bracket): This shortcut selects all cells directly referenced by formulas in the active cell.


Command + ] (right bracket): This shortcut selects all cells that reference the active cell.


Command + Shift + ~ (tilde): This shortcut applies the General number format.


Command + Shift + $: This shortcut applies the Currency number format.


Command + Shift + %: This shortcut applies the Percentage number format.


Command + Shift + ^ (caret): This shortcut applies the Exponential number format.


Command + Shift + #: This shortcut applies the Date number format.


These shortcut keys can help you perform tasks quickly and easily in Excel, whether you're entering data, formatting cells, or performing calculations. By using these shortcuts, you can save time and boost your productivity, making your work with Excel on a MacBook more efficient and enjoyable.





Comments