Home

Excel Macros: Shortcut Keys for Working in the VBE Code Window

Updated
2017-02-27 21:24:30
Share
Microsoft 365 Excel For Dummies
Microsoft 365 Excel For Dummies book cover
Explore Book
Microsoft 365 Excel For Dummies
Microsoft 365 Excel For Dummies book coverExplore Book
What to Press on Your Keyboard What It Does
Ctrl + Down Arrow Selects the next procedure
Ctrl + Up Arrow Selects the previous procedure
Ctrl + Page Down Shifts one screen down
Ctrl + Page Up Shifts one screen up
Shift + F2 Goes to the selected function or variable
Ctrl + Shift + F2 Goes to the last position
Ctrl + Home Goes to the beginning of module
Ctrl + End Goes to the end of module
Ctrl + Right Arrow Moves one word to the right
Ctrl + Left Arrow Moves one word to the left
End Moves to the end of the line
Home Moves to the beginning of the line
Tab Indents the current line
Shift + Tab Removes the indent for the current line
Ctrl + J Lists the properties and methods for the selected object

About This Article

This article is from the book: 

About the book author:

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.