asked 14.9k views
4 votes
Using the macro recorder record a macro that inserts the company phone number using short cut keys

1 Answer

5 votes

It is to be noted that recording a macro in Microsoft Excel is like creating a shortcut for repetitive tasks. The short-cut key for this is Ctrl+Shift+P.

Here's how you can record a macro to insert the company phone number.

1. Open Excel and go to the "View" tab.

2. Click on "Macros" and choose "Record Macro."

3. Name your macro and assign a shortcut key, like Ctrl+Shift+P.

4. Click "OK" and start typing the phone number in a cell.

5. Stop recording by going back to "Macros" and selecting "Stop Recording."

Now, whenever you press Ctrl+Shift+P, Excel will automatically insert the company phone number, saving you time on repetitive data entry.

answered
User Fhdrsdg
by
8.6k points