© Copyright Ezee Computer Training 2010 Made by Wen Studio  It makes sense to add a calculator to the Excel toolbar.  Usually, you calculate numbers when you use Excel.  Here's how: Choose View, Toolbars, Customize. Click on the Commands tab then, in the Categories list, choose Tools. In the Commands list, choose Custom (you'll see a little grey calculator icon next to it). Drag the calculator icon to the toolbar, letting it drop wherever you'd like it to reside.  If you have a title for, let's say, a sales chart, it looks better vertical than horizontal. Here's how to invert it: Select the cell that contains your title and the cells you want the title to span. Choose Format, Cells and click on the Alignment tab. In the Degrees box, type 90. Under Text Control, check Merge Cells. Click on OK.  Hold down the Alt key while you type the equal sign. Excel will automatically write a SUM formula for the cells above or to the left.  The fastest way to format text that appears within a cell is to select the cell and press Ctrl+1. This will display the Format Cells dialog box.  How to print quickly an area in a worksheet. Don't waste a lot of time and paper sending entire worksheets to the printer when all you need is a printout of a few columns or rows. Select View | Page Break Preview. Select the cells you want to print. Right-click the selection and choose Set Print Area from the shortcut menu. Click Print.  Each Excel sheet has its own print setup options (orientation, margins, headers and footers, and so on). These options are specified in the Page Setup dialog box, which you access using the File, Page Setup command. When you add a new sheet to a workbook, it contains the default page setup setting. Here's an easy way to transfer the settings from one worksheet to additional worksheets: 1- Activate the sheet that contains the desired setup info. This is the "source" sheet. 2- Select the "target" sheets. Press Ctrl and click the sheet tabs of the sheets you want to update with the settings from the source sheet. 3- Select File, Page Setup and click OK. The Page Setup settings of the source sheet will be transferred to all of the target sheets.  Transpose -- Rows to Columns, Columns to Rows. Want to transpose your columns to rows or rows to columns? Select      the cells to transpose and click Copy. Click on an empty cell that can accommodate the transposed result. Choose Paste      Special and check the transpose checkbox. 519-473-1391 eMail