Ms Office Tune Up

When you’re building a worksheet model, you often begin by adding some labels or other data in a row or column. After you add some data, however, you may find that it will dis­play better if it’s transposed to display in the other direction. That is, row data might look better in a column (the usual case because Excel displays more rows than columns), or col­umn data might look better in a row. Either way, transposing the data by hand is a pain because you need to either click-and-drag or cut-and-paste the cells individually.

Rather than going through that hassle, Excel has a feature that enables you to transpose rows and columns with just a few mouse clicks:

1. Select and copy the source cells.
2. Select the upper-left corner of the destination range.
3. Choose Home, pull down the Paste menu, and choose Transpose.

Automatically Opening a Workbook at Startup in Excel 2007

By default, Excel opens a new, blank workbook every time you launch the program. If you use the same workbook every time you open Excel, you can tell the program to automati­cally open that workbook for you at startup.

To set up a workbook to open automatically, you must store the workbook file in one of the XLSTART folders on your computer. If you selected the default folder setting for storing Excel on your computer when you installed Office, you can find the XLSTART folder within the following folder:

%ProgramFiles%\Microsoft Office\Office12\

There’s also an XLSTART folder in your user profile:

%UserProfile%\AppData\Roaming\Microsoft\Excel\XLSTART

You can either move your workbook into one of those folders using Windows Explorer, or you can follow these steps to save a copy of your workbook in that folder:

1. Choose Office, Save As to open the Save As dialog box.
2. In the Address box, type the address of the XLSTART folder you want to use and press Enter.
3. Click Save.

Technorati Tags: transposing rows columns, opening workbook automatically

Popularity: 27% [?]

If you liked this post, would you please buy me a twelve-ounce lattes for only $2