EXCEL SHORTCUTS

Excel has built-in keyboard shortcuts that significantly boost productivity.

Editing File

Cut Ctrl Alt Shift X Save Ctrl Alt Shift S

Copy Ctrl Alt Shift C Save as Ctrl Alt Shift F12
Paste Ctrl Alt Shift V Print Ctrl Alt Shift P
Paste special Ctrl Alt Shift V Close file Ctrl Alt Shift F4
Fill down Ctrl Alt Shift D Close all Excel files Ctrl Alt Shift F4
Fill right Ctrl Alt Shift R
Other
Insert row Ctrl Alt Shift IR
Insert column Ctrl Alt Shift IC Autosum Ctrl Alt Shift =
Right click Ctrl Alt Shift F10 Enter date Ctrl Alt Shift ;
Insert worksheet Ctrl Alt Shift F11 Enter time Ctrl Alt Shift :

Formatting Inside Cell

Format cells menu Ctrl Alt Shift 1 Confirm change in a cell Ctrl Alt Shift Enter
Bold Ctrl Alt Shift B Cancel cell entry and exit Ctrl Alt Shift Esc
Underline Ctrl Alt Shift U Accept autocomplete Ctrl Alt Shift Tab
Italic Ctrl Alt Shift I Insert line break Ctrl Alt Shift Enter
Delete row/column Ctrl Alt Shift - Select Ctrl Alt Shift Left/Right
Number format Ctrl Alt Shift 1 Select Sections Ctrl Alt Shift Left/Right
Date format Ctrl Alt Shift 3 Toggle edit mode Ctrl Alt Shift F2
Currency format Ctrl Alt Shift 4 Paste name into cell Ctrl Alt Shift F3
Percent format Ctrl Alt Shift 5 Lock cell references Ctrl Alt Shift F4
Outside border Ctrl Alt Shift 7
Remove borders Ctrl Alt Shift -

Navigation Other Navigation

Move to last used cell Ctrl Alt Shift Arrow Repeat last action Ctrl Alt Shift F4
Select to last used cell Ctrl Alt Shift Arrow Go to command Ctrl Alt Shift F5
Move one screen up/dn Ctrl Alt Shift PgUp/PgDn Calculate workbook Ctrl Alt Shift F9
Move one tab left/right Ctrl Alt Shift PgUp/PgDn Go to cell A1 Ctrl Alt Shift Home
Select column Ctrl Alt Shift Spacebar Go to end of used range Ctrl Alt Shift End
Select row Ctrl Alt Shift Spacebar Go to beginning of row Ctrl Alt Shift Home
Name manager Ctrl Alt Shift F3 Next workbook Ctrl Alt Shift Tab

Auditing Data Editing

Go to precedent cell Ctrl Alt Shift [ Find Ctrl Alt Shift F

Return from precedent cell Ctrl Alt Shift F5 Enter Replace Ctrl Alt Shift H
Check row differences Ctrl Alt Shift \ Undo Ctrl Alt Shift Z
Check column differences Ctrl Alt Shift \ Redo Ctrl Alt Shift Y
Go to special 1
F5 Alt Shift S Select all Ctrl Alt Shift A

Ribbon

Show/hide ribbon Ctrl Alt Shift F1

Show accelerator keys 2
Ctrl Alt Shift

1
Starts with F5 not Ctrl.
2
Accelerator keys enable the user to navigate through the ribbon using keyboard shortcuts.
Keystrokes may differ for non-English keyboards and Office versions. macabacus.com
MACABACUS SHORTCUTS

Macabacus is a productivity and brand compliance solution for Microsoft Office.

Modeling Numbers
Fast Fill Right Ctrl Alt Shift R General Number Cycle Ctrl Alt Shift 1
Fast Fill Down Ctrl Alt Shift D Date Cycle Ctrl Alt Shift 2
Error Wrap Ctrl Alt Shift E Currency Cycle Ctrl Alt Shift 4
Simplify Formula Ctrl Alt Shift Q Percent Cycle Ctrl Alt Shift 5
Multiple Cycle Ctrl Alt Shift 8
Paste
Binary Cycle Ctrl Alt Shift Y
Paste Insert Ctrl Alt Shift I
Increase Decimals Ctrl Alt Shift ,
Paste Duplicate Ctrl Alt Shift D
Decrease Decimals Ctrl Alt Shift .
Paste Transpose Ctrl Alt Shift T
Colors
Auditing
Blue-Black Toggle Ctrl Alt Shift ;
Trace In Ctrl Alt Shift [
Font Color Cycle Ctrl Alt Shift ‘
Trace Out Ctrl Alt Shift ]
Fill Color Cycle Ctrl Alt Shift K
Show All Precedents Ctrl Alt Shift [
Border Color Cycle Ctrl Alt Shift ‘
Show All Dependents Ctrl Alt Shift ]
AutoColor Selection Ctrl Alt Shift A
Clear Arrows Ctrl Alt Shift \
AutoColor Sheet Ctrl Alt Shift S
Uniformulas Ctrl Alt Shift Q
AutoColor Workbook Ctrl Alt Shift Q

View
Alignment
Zoom in Ctrl Alt Shift =
Horizontal Cycle Ctrl Alt Shift H
Zoom out Ctrl Alt Shift -
Left Indent Cycle Ctrl Alt Shift I
Toggle Gridlines Ctrl Alt Shift G
Hide Page Breaks Ctrl Alt Shift B Borders
Bottom Border Cycle Ctrl Alt Shift Down
Rows & Columns
Left Border Cycle Ctrl Alt Shift Left
Row Height Cycle Ctrl Alt Shift PgUp
Right Border Cycle Ctrl Alt Shift Right
Column Width Cycle Ctrl Alt Shift PgUp
Outside Border Cycle Ctrl Alt Shift 7
Group Row Ctrl Alt Shift Right
No Border Ctrl Alt Shift -
Group Column Ctrl Alt Shift Down
Ungroup Row Ctrl Alt Shift Left Fonts
Ungroup Column Ctrl Alt Shift Up Font Size Cycle Ctrl Alt Shift G
Expand All Rows Ctrl Alt Shift = Increase Font Ctrl Alt Shift F
Expand All Columns Ctrl Alt Shift = Decrease Font Ctrl Alt Shift G
Collapse All Rows Ctrl Alt Shift -
Collapse All Columns Ctrl Alt Shift -
Paintbrush
Capture Paintbrush Style Ctrl Alt Shift C
Export Apply Paintbrush Style Ctrl Alt Shift P
Quick Export to PowerPoint Ctrl Alt Shift Left
Other Formatting
Quick Export to Word Ctrl Alt Shift Right
Underline Cycle Ctrl Alt Shift U

Utilities & Other List Cycle Ctrl Alt Shift L

Quick Save Ctrl Alt Shift S Leader Dots Ctrl Alt Shift L

Quick Save All Ctrl Alt Shift S Footnote Cycle Ctrl Alt Shift 6

Quick Save As Ctrl Alt Shift F12 Footnote Toggle Ctrl Alt Shift 6

Quick Save Up Ctrl Alt Shift F12 Wrap Text Ctrl Alt Shift W

Delete Comments & Notes Ctrl Alt Shift D Custom Cycles Ctrl Alt Shift 1-8

This sheet shows the default Macabacus keyboard shortcuts which can be changed in the Shortcut Manager.
We have only shown some selected keyboard shortcuts here. More are available in Macabacus.
Keystrokes may differ for non-English keyboards and Office versions. macabacus.com