Create a macro name at the top (Header) of documents Microsoft Office? Excel 2010

For users working with documents, Excel 2010 to the documents furnished to look good. It is usually the name of the document or the company name or the other. Do you want the top of the document called Header? If we do, many documents and pieces to put together Header whenever it is working with too many steps. In order to facilitate the work, We create macros for Excel Header text that we want to be. Just press the key once Header of the document will be displayed as well.

1. Open Excel, click on the Ribbon? View and then click on the small arrow button Macros, select the Record Macro

2. On the Record Macro window Macro name: Please name your macro.
3. Shortcut key put the English alphabet. To take a shortcut to the macro function.
4.Store macro in a system that will store the macro in any place.

Personal Macro Workbook? Stored in the server's books.
New Workbook? Keep in Kraftwerk's new book.
The Workbook? Keep in Kraftwerk book that is being used.

5.Description: the details of our macro.
6. Enter values Click OK, it's done
7. Click OK and Excel will begin recording the macro and the six of us. Ribbon, click the Insert menu, click Header & Footer.

8. Do we want to put a name in the Header? When finished, click retire Header (any cell of the cell sheet).
9. Click on the small square. At the bottom left, It will stop recording macro

If we put the following Header created in an Excel document, just press the shortcut key that is set in step 3 The header that we created, it appears that the document Excel.

• Tweet
• Share
• Share
• Share
• Share