Scribd
Upload
8 views1 page

Excel Shortcuts for Mac Users

The document provides a comprehensive list of keyboard shortcuts for laptop users, particularly focusing on functionalities in spreadsheet applications. Key shortcuts include using F5 and F9 for formulas, various CTRL combinations for navigation and formatting, and ALT commands for accessing menus. These shortcuts enhance efficiency in managing data and performing tasks within the software.

Uploaded by

limitlessmachoman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views1 page

Excel Shortcuts for Mac Users

The document provides a comprehensive list of keyboard shortcuts for laptop users, particularly focusing on functionalities in spreadsheet applications. Key shortcuts include using F5 and F9 for formulas, various CTRL combinations for navigation and formatting, and ALT commands for accessing menus. These shortcuts enhance efficiency in managing data and performing tasks within the software.

Uploaded by

limitlessmachoman
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

For our laptop, always use Function key with F5, F9 etc.

1. To show the values formula is using: Click on formula parameter & then click
F9.
2. To change windows: Alt + Tab
3. To switch tabs worksheets: CTRL+PAGE UP/DOWN
4. Same value in every cell: Select all the cells, put the value & CTRL + ENTER
5. If a cell referencing to another cell: CTRL+ [. To go back, F5+ENTER
6. To fill a series: ALT + H + F + I + S
7. CTRL + V, CTRL again, then V: To paste values only (not formulae):
8. CTRL + V, CTRL again, then E: To paste values & formatting
9. CTRL + Alt + V: Paste Special table
[Link] + B: Bold
[Link] + Arrow: Goes to last cell
[Link] + SHIFT + Arrow: Same as above, also highlights the full row/column
[Link] click Format Painter to lock it
[Link]: To see shortcuts
[Link] + H + I (insert) / D (delete) + C/R: Enter column/row
[Link] + D/U/L/R: copy a cell & do this to apply same formatting/formula to
cells downwards/ upwards/ left/ right
[Link] + H/M/W: Go to Home/ Formula/ View tab
18.F2: Edit a cell
[Link] + H + H: Fill colors
[Link] + H + B (border) + A (all borders) / N (no borders)
[Link] + K: Add link
[Link] + F: Find & Replace
[Link] + Shift + $/%: Make currency / Per cent format
[Link] of if(1,0), use - -()
[Link] to More Borders for more tweaks
[Link] + W+ F + F: Freeze pane

You might also like