[PDF]Periodic Table Of Excel Keyboard Shortcuts

in General man


FL |


Excel Help


Toggle Italics


Ctrl


F2 || P


Edit Current Cell


F4


Redo Last
Action


Save File


F/ U


Check Underline


F9 V


Paste Contents
of Clipboard


Recalculate All
Worksheets


F12 X


Save File As Cut Selection


B Y


Redo Last


Toggle Bold Text
E8 Action


C Z


Undo Last
Action


Copy Selection


Primary Keyboard
Key to Press


Additional Keys to Be
Pressed in Conjunction
with Primary Key


Description


ih DataPig


Teci mologies


© Copyright 2013 datapigtechnologies.com


Apply Number
Format


Periodic Table of


Excel Keyboard Shortcuts


m Range Selection & Navigation


€


Select All Cells
to the Left


Select All Cells
to the Right


Select All Cells
Below


Select All Cells
Above


Select Entire
Region


Space


Select Entire
Column


Space


Select Entire
Row


Home


Move to Top of
Worksheet


End


Move to Last
Used Cell


€


Move to
Left-Most Cell


=>


Move to
Right-Most Cell


Move to
Last Cell in
Column


Move to
First Cell in
Column


Open Object
Browser


Open Project
Window


Formula Editing &
- Management ——


= F3


Insert Defined
Named Range
(Only If Any Exists)


F3


Create Named
Range from
Selection


Select Only
Visible Cells


FS


Go To Specified
Range


Insert Auto Sum


F4


Toggle Absolute
Reference
(In Edit Mode Only)


Apply General
Format


Ctrl


9 D !


Hide Row Toggle Formula Apply Number


View Format


O R ] @


Select
Dependents for
Active Formula


|


Select
Copy from Cell Precedents for
Above Active Formula


F3


Insert Function


Fill Values Down


Apply Time


Hide Column Format


Fill Values Right


Apply Date
Format


Enter $


Create an Array
Formula
(In Edit Mode Only)


Unhide Row Apply Currency


Format


F2 Y F2


Jump to Variable


PgDn


Jump to Bottom
of Procedure


R PgUp


Open Properties
Window


Open Immediate
Window


Jump to Next
Procedure


AS


Jump to Prev
Procedure


Jump to Top
of Procedure


Jump Back to
Prev Position


%


Apply Percent
Format


5


Apply
Strikethrough
Format


Enter


Add Carriage
Return
(In Edit Mode Only)


Remove
Borders


&


Apply Border
Around Selection


F


Find Dialog Box


H


Replace Dialog


Box


Start New
Workbook


Close Active
Workbook


F6


Move to Next
Open Workbook


F6


Move to Prev
Open Workbook


Visual Basic Editor Keyboard Shortcuts


FS


Run Procedure


Inset New
Worksheet


Move to Next
Worksheet


Move to
Prev Worksheet


F9


Recalculate
Active Worksheet


F8


Step Into


F8


Step Over


Open Existing
File Dialog Box


1


Format Cells


Dialog Box


Insert
Dialog Box


Delete
Dialog Box


F8


Macros
Dialog Box


F8


Run to Cursor


F8


Step Out


Name Manager


Dialog Box


F


Find
Dialog Box


H


Replace
Dialog Box


T


Create Table
Dialog Box


t
Open Visual
Basic Editor


F9


Toggle
Breakpoint


F9


Clear All
Breakpoints