Menu
Start studying Excel Shortcuts for Mac. Learn vocabulary, terms, and more with flashcards, games, and other study tools. Log in Sign up. Log in Sign up. Bottom border. Command option bottom. Go to end of contiguous range. Command arrows. Move one screen up. Move one screen down. Move one screen left. Cell Border Shortcuts. Posted on August 1, 2006 by Dick Kusleika. Blue border along the bottom? If we’re talking shortcuts, one I learned recently is Ctrl+’ (the key to the left of the 1 along the top of the keyboard). It toggles between showing formulae and values. Which shortcut keys for apllying border in excel sheet.
www.wallstreetprep.com
Excel for Mac Reference Sheet General Excel navigation
Using Toolbars
Activate menu bar (ALT in PC)
CTRL + F2 (see WSP Mac Setup)
Make a toolbar active
ALT + F10
Page Up / Page Down
CTRL FN + UP / DOWN
Moving to left / right in toolbar
TAB / SHIFT + TAB
Moving to left/right tabs
CTRL + PAGEUP/DOWN
Select the next / previous toolbar CTRL + TAB / CTRL + SHIFT + TAB
Excel Options
⌘+,
Perform the desired action
Edit cells (F2 in PC)
CTRL+U
Formatting shortcuts
RETURN
Row / column shortcuts Select column
CTRL + Space (see WSP Mac Setup)
⌘+B Italic ⌘+I Underline ⌘+U Format Box ⌘+1 Outline border ⌘+ALT+ZERO Left, right, top, and bottom border ⌘+ALT+ARROW KEYS Remove border ⌘+ALT+HYPHEN
Select row
Shift + Space
Delete row(s) / column(s)
CTRL + ‘minus sign’
Add row(s) / column(s)
CTRL + i
Group / ungroup rows & columns
⌘ + Shift + K / J
Select All
⌘+A
Insert / delete a comment
SHIFT + F2 / SHIFT + F2 + DELETE
Fill Down
CTRL+D
Copy
⌘+C ⌘+V
Fill right
CTRL+R
Bold
Paste Paste Special formats Paste Special formulas Cut Repeat Undo Delete selected cells
CTRL + ⌘ + V, ⌘ + T (Excel 2011 only)
CTRL + ⌘ + V, ⌘ + F (Excel 2011 only)
⌘+X ⌘+Y ⌘+Z ⌘ + Minus sign
Workbook navigation shortcuts
Data editing shortcuts
Find CTRL+F Replace CTRL+H Start a formula
= (equal sign)
Insert AutoSum formula
⌘ + SHIFT + T
Data editing shortcuts when inside cell Start new line in same cell
CTRL+ALT+RETURN
Highlight within cells
SHIFT + Arrow keys
Highlight contiguous items
SHIFT + CTRL + Arrow keys
Toggle Excel workbooks
CTRL + TAB
Delete preceding character
DELETE
New workbook
⌘+N ⌘+P ⌘+O ⌘+S ⌘+W
Delete character to the right
FN + DELETE
Anchor “Fix” Cells
⌘+T
Cancel a cell entry
ESC
Print Open workbook Save workbook Close window
Other useful shortcuts
Auditing shortcuts Go to precedent cells
CTRL + [
Go to dependent cells
CTRL + ]
Recalculate all workbooks
SHIFT F9
Go back to original cell
F5, ENTER
Display a drop-down list
ALT + up/down arrow keys
“Go to”
F5
Display “Insert Function” box
SHIFT F3
Display “Name” box
CTRL+L
General Windows Shortcuts (Mac) Universal applications shortcuts
Cell navigation shortcuts
Switching between applications
⌘+TAB
Show the desktop / restore view
SHIFT F11
Go to end of contiguous range
CTRL + Arrow keys (see WSP Mac Setup)
Select a cell range
SHIFT + Arrow keys
Highlight contiguous range
SHIFT + CTRL + Arrow keys
Office forms (dialog boxes) navigation
Move to beginning of line
HOME
To go from tab to tab
CTRL+TAB
Delete cell/selection
Fn + Delete
Move in a list
Up and down arrow keys
Show formulas/values
CTRL + ~
To move to the next form field clockwise
Fill selection w/ entry
CTRL+RETURN
To move counter clockwise
Shift tab
Select ‘OK’
Enter
Select ‘Cancel’
Esc
Tab
Note: Some third-party utilities, macros and add-ins can overwrite native shortcut keys
Excel for Mac Reference Sheet General Excel navigation
Using Toolbars
Activate menu bar (ALT in PC)
CTRL + F2 (see WSP Mac Setup)
Make a toolbar active
ALT + F10
Page Up / Page Down
CTRL FN + UP / DOWN
Moving to left / right in toolbar
TAB / SHIFT + TAB
Moving to left/right tabs
CTRL + PAGEUP/DOWN
Select the next / previous toolbar CTRL + TAB / CTRL + SHIFT + TAB
Excel Options
⌘+,
Perform the desired action
Edit cells (F2 in PC)
CTRL+U
Formatting shortcuts
RETURN
Row / column shortcuts Select column
CTRL + Space (see WSP Mac Setup)
⌘+B Italic ⌘+I Underline ⌘+U Format Box ⌘+1 Outline border ⌘+ALT+ZERO Left, right, top, and bottom border ⌘+ALT+ARROW KEYS Remove border ⌘+ALT+HYPHEN
Select row
Shift + Space
Delete row(s) / column(s)
CTRL + ‘minus sign’
Add row(s) / column(s)
CTRL + i
Group / ungroup rows & columns
⌘ + Shift + K / J
Select All
⌘+A
Insert / delete a comment
SHIFT + F2 / SHIFT + F2 + DELETE
Fill Down
CTRL+D
Copy
⌘+C ⌘+V
Fill right
CTRL+R
Bold
Paste Paste Special formats Paste Special formulas Cut Repeat Undo Delete selected cells
CTRL + ⌘ + V, ⌘ + T (Excel 2011 only)
CTRL + ⌘ + V, ⌘ + F (Excel 2011 only)
⌘+X ⌘+Y ⌘+Z ⌘ + Minus sign
Workbook navigation shortcuts
Data editing shortcuts
Find CTRL+F Replace CTRL+H Start a formula
= (equal sign)
Insert AutoSum formula
⌘ + SHIFT + T
Data editing shortcuts when inside cell Start new line in same cell
CTRL+ALT+RETURN
Highlight within cells
SHIFT + Arrow keys
Highlight contiguous items
SHIFT + CTRL + Arrow keys
Toggle Excel workbooks
CTRL + TAB
Delete preceding character
DELETE
New workbook
⌘+N ⌘+P ⌘+O ⌘+S ⌘+W
Delete character to the right
FN + DELETE
Anchor “Fix” Cells
⌘+T
Cancel a cell entry
ESC
Print Open workbook Save workbook Close window
Other useful shortcuts
Auditing shortcuts Go to precedent cells
CTRL + [
Go to dependent cells
CTRL + ]
Recalculate all workbooks
SHIFT F9
Go back to original cell
F5, ENTER
Display a drop-down list
ALT + up/down arrow keys
“Go to”
F5
Display “Insert Function” box
SHIFT F3
Display “Name” box
CTRL+L
General Windows Shortcuts (Mac) Universal applications shortcuts
Cell navigation shortcuts
Switching between applications
⌘+TAB
Show the desktop / restore view
SHIFT F11
Go to end of contiguous range
CTRL + Arrow keys (see WSP Mac Setup)
Select a cell range
SHIFT + Arrow keys
Highlight contiguous range
SHIFT + CTRL + Arrow keys
Office forms (dialog boxes) navigation
Move to beginning of line
HOME
To go from tab to tab
CTRL+TAB
Delete cell/selection
Fn + Delete
Move in a list
Up and down arrow keys
Show formulas/values
CTRL + ~
To move to the next form field clockwise
Fill selection w/ entry
CTRL+RETURN
To move counter clockwise
Shift tab
Select ‘OK’
Enter
Select ‘Cancel’
Esc
Tab
Note: Some third-party utilities, macros and add-ins can overwrite native shortcut keys
To apply cell borders:
1. On the Home tab, in the Font group, click the arrow next to Borders:
Then choose a border style from the palette:
Click Line Colorand then click the color that you want to use. Click the arrow next to Line Styleand choose the style that you want to use:
If you want to use another style of borders, choose the More Borders... button to open the Format Cells dialog box:
Click the line style and color that you want, and then click one or more buttons to indicate the border placement.
2. Choose Format Cells... from popup menu to open the Format Cells dialog box:
Click the line style and color that you want, and then click one or more buttons to indicate the border placement.
Note: You also can use next shortcut keys:
Alt+P Apply or remove the top border.
Alt+B Apply or remove the bottom border.
Alt+L Apply or remove the left border.
Alt+R Apply or remove the right border.
Alt+H If cells in multiple rows are selected, apply or remove the horizontal divider.
Alt+V If cells in multiple columns are selected, apply or remove the vertical divider.
Alt+D Apply or remove the downward diagonal border.
Alt+U Apply or remove the upward diagonal border.
To remove cell borders:
1. On the Home tab, in the Font group, click the arrow next to Borders and choose Erase Borderand then do one of the following:
- To remove a single border, click that border with the eraser tool.
- To remove more than one border, drag the eraser tool across the borders that you want to remove.
To stop erasing borders, click Erase Border on the Borders toolbar again, so that the eraser tool is no longer displayed.
2. Choose Format Cells... from popup menu to open the Format Cells dialog box. Click one or more buttons to unselect the border placement.
Note: You also can use next shortcut keys:
Ctrl+Shift+_ Border lines off
Ctrl+Shift+& Border lines on