This means that you’re actively recording your next steps. When you’re done entering the necessary information, hit “OK.” At that point, you’ll see “Stop Recording” in the “Developer” tab. You can also enter a keyboard shortcut to apply that macro (in Sophia’s case she’ll use option+command+b for board member) and a description (which is helpful if you record and store a lot of macros). Click to store the macro in that workbook (since that’s where Sophia is working with the data). To start, click in a cell that does not belong to a board member, go to the “Developer” tab, and then click “Record Macro.”Īt that point, you’ll see a window that gives you the option to name your macro (important note: Excel will not allow you to include any spaces in your macro name). Let’s build this macro right along with Sophia. With a little Excel knowledge under her belt, she decides to build a simple macro-so, when she finds a cell for a board member, she can apply those three formatting rules with just a single click of a button. But, she’s realizing that it’s taking her forever to find the board member at each table and then go through those three different formatting steps for each and every board member cell.
0 Comments
Leave a Reply. |
AuthorSofia ArchivesCategories |