Chapter 5: Setting Up a Workbook

Page 107	To name a worksheet
	In the lower left corner of the workbook window, right-click the desired sheet tab. From the shortcut menu that appears, click Rename . Type the new name for the worksheet, and press [ENTER].
107	To merge cells
	Select the cells to be merged. On the Formatting toolbar, click the Merge and Center toolbar button.
107	To add cells to a worksheet
	On the Insert menu, click Cells . 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). Click OK .
107	To add a row or column
	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. On the Insert menu, click Rows or Columns .
107	To hide a row or column
	Select any cell in the row or column to be hidden. On the Format menu, point to Row or Column and then click Hide .
114	To prevent text spillover
	Click the desired cell. On the Format menu, click Cells . If necessary, click the Alignment tab. Select the Wrap text check box, and click OK .
114	To freeze column headings
	Click the first cell in the row below the rows you want to freeze. On the Window menu, click Freeze Panes .
117	To add a picture to a worksheet
	Click the cell into which you want to add the picture. On the Insert menu, point to Picture and then click From File . Navigate to the folder with the picture file, and then double-click the file name.
117	To scale and resize graphics
	Right-click the graphic, and from the shortcut menu that appears, click FormatPicture . Click the Size tab. Select the Lock aspect ratio check box if you want to maintain the relationship between the image s height and its width. Type the percentage value you would like the new image to be in the Height box. Click OK .