Home

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

|
Updated:  
2017-02-27 21:24:30
|
From The Book:  
Excel Sales Forecasting For Dummies
Explore Book
Buy On Amazon
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.