Chapter 5: Setting Up a Workbook


Page 107

To name a worksheet

 
  1. In the lower left corner of the workbook window, right-click the desired sheet tab.

  2. From the shortcut menu that appears, click Rename .

  3. Type the new name for the worksheet, and press [ENTER].

107

To merge cells

 
  1. Select the cells to be merged.

  2. On the Formatting toolbar, click the Merge and Center toolbar button.

107

To add cells to a worksheet

 
  1. On the Insert menu, click Cells .

  2. In the Insert dialog box, select the option button indicating whether to shift the cells surrounding the inserted cell down (if your data is arranged as a column) or to the right (if your data is arranged as a row).

  3. Click OK .

107

To add a row or column

 
  1. Click any cell in the row below which you want the new row to appear, or click any cell in the column to the right of which you want the new column to appear.

  2. On the Insert menu, click Rows or Columns .

107

To hide a row or column

 
  1. Select any cell in the row or column to be hidden.

  2. On the Format menu, point to Row or Column and then click Hide .

114

To prevent text spillover

 
  1. Click the desired cell.

  2. On the Format menu, click Cells .

  3. If necessary, click the Alignment tab.

  4. Select the Wrap text check box, and click OK .

114

To freeze column headings

 
  1. Click the first cell in the row below the rows you want to freeze.

  2. On the Window menu, click Freeze Panes .

117

To add a picture to a worksheet

 
  1. Click the cell into which you want to add the picture.

  2. On the Insert menu, point to Picture and then click From File .

  3. Navigate to the folder with the picture file, and then double-click the file name.

117

To scale and resize graphics

 
  1. Right-click the graphic, and from the shortcut menu that appears, click FormatPicture .

  2. Click the Size tab.

  3. Select the Lock aspect ratio check box if you want to maintain the relationship between the image s height and its width.

  4. Type the percentage value you would like the new image to be in the Height box.

  5. Click OK .




Microsoft Office 2003 Step by Step
MicrosoftВ® Office ExcelВ® 2003 Step by Step (Step By Step (Microsoft))
ISBN: 0735615187
EAN: 2147483647
Year: 2005
Pages: 350
Authors: Curtis Frye

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net