microsoft excel courses - macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Macros

microsoft excel courses - Macros

resolvedResolved · Low Priority · Version Standard

Hannah has attended:
Excel Introduction course

Macros

What is a macro?

RE: macros

a macro is a sequence of steps / commands that can be stored and then recalled with a single click or keyboard stroke.

For example, in Excel you may want to create a button that when pressed, will change the margins of a page, add gridlines, and change the Font to bold. By using a Macro you could record this action, and any time you press the button, it would repeat those steps to your active worksheet

I hope that makes sense

Tracy


 

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips


Server loaded in 0.07 secs.