Format Cells dialog box

The Font tab in the Format Cells dialog box allows you to format individual cells in any of the installed fonts (Figure 1-25). In addition, you can format individual characters in various font styles or sizes, or as strikethrough, superscript or subscript characters. You can also insert Greek letters in text labels, as shown in Figure 1-7, by using the Symbol font. 

You can enter subscripts and superscripts in text, as in Figure 1-27. First, highlight the characters to be subscripted or superscripted. Choose the Font tab in the Format Cells dialog box, check the Subscript or Superscript check box (see Figure 1-25), press the OK button, then enter the text by pressing the ENTER key or the Enter button. 

The Border tab in the Format Cells dialog box allows you to place a border around one or more sides of a selected cell or range. This is useful if you want to emphasize comments, instructions or values. The Patterns tab is used to change the backgroimd color or pattern of cells. 

F w Activate the Font list box Display the Format Cells dialog box... 

Display Format Cells dialog box CONTROL+1 COMMAND+1... 

For Each...Next loop 268 For...Next loop 268 form, custom 159 Format Cells dialog box 33 Format Painter toolbutton 34 formats, number... 

There are three types of data that can be entered in the cells of the spreadsheet number, date/time, and text. For multiple entries of serial number with constant increment, enter the initial value into the first cell, highlight the cells, and select Edit -> Fill -> Series. To fill multiple entries of the same value into a range, enter the value into the first cell, move the pointer to the right-hand corner of the active cell to activate fill handle (a bold crosshair), and drag it through the range. Data are edited with the usual cut, copy, and paste operations in the Edit menu and the decimal places of scientific numbers is controlled via dialog box in Format -> Cells. 

Some people prefer to use a numeric format for addressing cells. The columns are numbered rather dian labelled widi letters. To change from the default, select the Tools option, choose General and select R1C1 from the dialog box (Figure A.1). 

When you Copy a cell and Paste it. Excel transfers the cell s contents, format and any comment. You can choose to transfer only some of these cell attributes by using Paste Special. The Paste Special dialog box (Figure 1-14) permits you to paste only Formulas, Formats or Comments. In addition, you can convert formulas to constants by choosing Values. 

To use the Across Worksheets option in the Fill submenu, you must have selected multiple sheets beforehand. Select adjacent or non-adjacent sheets in the same way you select cells. To select an adjacent range of worksheets click on the tab of the first sheet, then hold down the SHIFT key and click on the tab of the last sheet in the range. To select non-adjacent sheets, hold down the CONTROL key (Windows) or the COMMAND key (Macintosh) while selecting. When you choose Across Worksheets from the submenu, the Fill Across Worksheets dialog box (Figure 1-18) will appear you can choose to fill Contents, Formats or both. 

As you saw earlier. Excel recognizes the format of data typed into cells. If you enter a value such as 6/23/00 and then choose Cells... from the Format menu, choose the Number tab and choose the Custom category, you ll see that Excel has recognized the value as a date and applied the m/d/yy number format. Now choose the format d-mmm-yy from the menu and observe the Sample display at the top of the dialog box. The data is displayed as23-Jun-00. 

When you choose the Solver Statistics... command, a sequence of four dialog boxes will be displayed, and you will be asked to select four cell ranges (i) the yobsd data, (ii) the ycalc data, (iii) the Solver coefficients, (iv) a 3R x nC range of cells to receive the statistical parameters. The Step 1 dialog box is shown in Figure 12-11. The y values can be in row or column format. The Solver coefficients can be in non-adjacent cells. 

To illustrate the use of the Recorder, we ll record the action of applying scientific number formatting to a number in a cell. First, select a cell in a worksheet and enter a number. Now choose Macro from the Tools menu, then Record New Macro... from the submenu. The Record Macro dialog box (Figure 13-5) will be displayed. 

---