ji4474的部落格

How would you similar to estate a few keys, past sit hindmost and ticker Excel do your career for you? Creating a macro in Excel will let you to do this. And it's a lot easier to do than maximum nation deliberate.

A large to complete a round of regime ladder can be created so that it runs from a baby grand cutoff.

For example, if you commonly data formatting your spreadsheets for printing, you can instigate a macro that goes through with all of the steps of formatting the programme. Or you can dash off a large to format your information for easier display. Many programs goods data into a .txt or .csv directory which you may later want to sweat next to in Excel. Although you can accessible these files in Excel, you unremarkably status to do many initial formatting so that the information is easier to seascape and to profession next to. You can conceive a macro to carry out all of these staircase for you. You can past run these macros but by pressing a few keys.

To transcript a macro, in Excel 2003 or sooner versions, sound on Tools in the Menu Bar, Macros, Record New Macro. In the Record Macro porthole that appears, kind a text into the box below Shortcut key: (I advocate that you use one that is not allotted to a usually used road.)

Click OK.

You will now be cd every footfall you yield. Carefully carry out all tactical manoeuvre of the regular exactly as you want it to be taped. When you are finished, clink Tools, Macros, Stop Recording.

What are any examples of how you could use this?

Example 1: A large that formats a program for printing

Click on Tools in the Menu Bar, Macros, Record New Macro.

In the Record Macro framing that appears, variety a text into the box below Shortcut key: (I advise that you use one that is not assigned to a commonly previously owned road.)

Click OK.

You are now record.

Click on File in the Menu Bar, chink on Page Setup.

Click on the Page tab at the top of the Page Setup framework and prize the position (portrait or outlook)

Click on the Margins tab at the top of the Page Setup pane and set the margins (I ever bill of exchange the "horizontally" box under "center on page" to halfway the database on the page)

Click on the Header/Footer tab at the top of the Page Setup windowpane and prize a heading and a footer from the dropdown lists

Click on the Sheet tab at the top of the Page Setup windowpane. If you would like the top row of the programme to go over on all written page, click sometime in the "Rows to say again at top" box and class $1:$1 If you prefer to have the facility lines showing, click quondam to leave a bill of exchange in the framework lines box

Click on OK.

You have now all gone playing the stairway you poorness to record: you now deprivation to finish copy.

Click on Tools in the Menu Bar, sound on Macros, click on Stop Recording.

To run the macro, go to the database you poorness to data formatting for writing and strain in your road. Excel will go done all of the recorded ladder as you study.

To concoct a large that formats raw facts in an Excel program (Excel 2003 or more rapidly):

Example 2: A large that formats exported raw aggregation for easier viewing

Open a computer program (this can be one you have simply created)

Click on Tools in the Menu Bar, Macros, Record New Macro.

In the Record Macro framing that appears, sort a notification into the box underneath Shortcut key: I propose that you use one that is not assigned to a readily used road.

Click OK.

You are now signal.

Select the top row of the computer programme by clicking on the row heading (the digit 1 all the way at the left-handed of the row)

Click on the Bold god on the toolbar.

Type Ctrl A to select the total spreadsheet

Double-click on the vertical line involving the line "A" and the head "B" at the top of the spreadsheet, to insentience resize all of the columns to fit their tabular array.

Select the ordinal row of the programme by clicking on the row line (the figure 2 all the way at the leftmost of the row)

Click on Window in the Menu bar, chink on Freeze Panes to hold on to the top row in judgment once you ringlet vertically.

Click former in the middle of the database.

You have now spent performing the way you privation to record: you now poverty to decrease cd.

Click on Tools in the Menu Bar, clink on Macros, chink on Stop Recording.

To run the macro, embark on a computer programme that contains raw unformatted information and variety in your road. Excel will info the aggregation so you can effortlessly estimation it and manual labour next to it.