![]() To use a macro in other places, you must adjust its range of it by the following steps: Once you think you're done, hit the Enter key on your keyboard and go back to the "Developer" Tab to click on "Stop recording." Now all the changes you have done are set but unfortunately, just for that cell to become a macro, an excellent formula for your whole table, you need to edit it. Now you must go to the cell you want to change and apply those settings you need (like changing the cell color, bold the names, etc.) Here is why you need to start to form a cell that does not have the category you need. This means Excel, from now on, is recording your next steps. ![]() And, once you think you're done entering all that you consider necessary, hit "Ok." You'll see "stop recording" in the "Developer" tab. So, for example, if you set a macro named "VegetarianPeople," you set (for mac) Option+Cmd+V (or any letter you want)įinally, You can write under the description gap the information you must remember for that specific macro. In addition to the above, you can establish a shortcut key for that specific macro in that pop-up window. Tip: Try to keep it in the same workbook you're working on. The second option of the window you can set is the "Store macro," which is the place you want to save the settings. Once you have cleared those things you actually need, you can start inserting a macro: Click in a cell within your table that doesn't belong to the category you want to set, then go to the "Developer" tab and select the "Record Macro" option.Īfterward, you will get a pop-up window that will let you name your macro, but remember that it doesn't allow you to include any spaces. For example, in a massive table with a high amount of data, you may need to highlight with a specific color the cells with the names of vegetarian people or bold the kind of jobs of some members in a big company. You first must make sure about the categories you need to establish and how you will make them evident.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |