Recording an Excel macro |
Ellen's opening statement is... well, you could say that it's reasonably accurate:
"Microsoft Excel has macro functions which allow users to automate spreadsheets and avoid entering the same information over and over again. Whether formatting a document a particular way, entering a range of information, or producing the same chart types over and over, a macro can help you perform these tasks with the push of a button."Yes, Excel macros let you do such things, thereby avoiding tedious repetition – though we'd have said "avoid entering the same steps" instead of "information." Macros also let you perform functions automatically, such as entering today's date. What they won't do, however, is what Stephanie says you're supposed to do:
- Open the spreadsheet
- Start recording a macro
- "Format the document. For example, design a budget document, make a bar graph, or enter information you'd like to enter in other spreadsheets."
- Stop recording and save.
¹ Not that eHow's content editors always edited for accuracy: all most of them did was make certain that the text met the in-house style guidelines. To hell with accuracy, they didn't understand that they were editing any more than the authors; sometimes even less.
copyright © 2018-2022 scmrak
SE - SOFTWARE
No comments:
Post a Comment