Excel/VBA Shortcuts You May Not Know
You may already have seen my Office Keyboard
Shortcuts pages. If not, go here and check them out.
http://personal-computer-tutor.com/officeshortcuts.htm
But, now, along with these, I've found some
additional shortcuts for Excel and VBA, from Ozgrid. Hope you like
them.
reprinted from Ozgrid's Excel Newsletter.
For more great Excel and VBA info, subscribe here:
http://www.ozgrid.com/
-
When copying and
pasting formulas from email or Web pages into Excel, copy the formula (Ctrl+C),
select a cell then click within the formula bar (or push F2) then
paste (Ctrl+V)
-
To get help on a
specific formula push F1 and type the formula name then push Enter.
-
To get a reminder
of a functions syntax, type = then the functions name, then
push Ctrl+Shift+A
-
To default the Paste
function (formula wizard) to a specific function type = then
the functions name, then push Ctrl+A
-
To copy and paste any
VBA code, open the Visual Basic Editor (Alt+F11), go to
Insert>Module and paste in the code.
-
To run any code after
copying and pasting it in, place your mouse insertion point anywhere
within the code and go to Run>Run Sub/UserForm, or
push F5
-
To easily access the
Private module of the "ThisWorkbook" Object, while in Excel, right
click on the Excel icon (top left next to File) and select "View
Code".
-
To easily access the
Private module of a Worksheet Object, while in Excel, right click on the
Worksheet name tab and select "View Code".
-
If the VBA code is a
Custom Function (i.e. begins with the word Function) after you have
pasted the code into a Module, switch back to Excel (Alt+F11),
go to Insert>Function... or push Shift+F3,
scroll down to User Defined (under Function category:)
then select the Function name from within the Function name:
box.
-
To assign a shortcut
key to any Macro go to Tools>Macro>Macros...,
or push Alt+F8 then select the Macro name and click
Options.
<<<back to contents
Linda Johnson is a
college instructor of all of the Microsoft Office Programs, as well
as Adobe PhotoShop and Windows. She also teaches online distance
learning classes in Excel, Outlook, PowerPoint, Publisher, and Word at
Eclectic Academy. She has worked helpdesk and teaches
and lectures at many local businesses and tech schools in her area. Support this
newsletter by checking out Linda's eBooks, MS Word MAGIC!, Book
I: Fonts, Fun & Formats and Book
II: Table Wizardry,
How
To Get Started As a Software Trainer, and
her newest series of MSOffice
eBook Tutorials and CD
|
,
