HDTutorial
EN
How to Record and Run Macro to Format Excel File

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Record and Run Macro to Format Excel File

128,086 views November 8, 2012 3:38

Watch on YouTube
ChannelContextures Inc.

Description from the creator

Instead of manually repeating the same steps every time you format an Excel file, you can record and run a macro, to automate the steps.

In this example, which has fake data from the FakeNameGenerator site, we're hiding worksheet columns, and adjusting the page setup, so the file will print at one page width.

Finally, we'll add a button to the Quick Access Toolbar, so the macro is easy to run.

See the steps in this short Excel tutorial. For written steps and Excel file, go to my Contextures site:
contextures.com/excel-macro-record-test.html

About this tutorial

Contextures Inc. published this 3:38 video tutorial on November 8, 2012. It has been watched 128,086 times on YouTube.

Duration
3:38
Published
November 8, 2012
Views
128,086
Likes
279

Tags

Share

This tutorial in other languages