Editing cell entries

You can edit cell entries in one of two ways — either in the formula bar or by using the Edit Directly In Cell feature. When you select a cell that contains an entry, the contents of the cell appear in the formula bar. As soon as you begin to enter a new value, the old value disappears. To make minor editing changes in the old entry, place the mouse pointer in the text at the point where you want to edit the entry. The mouse pointer becomes the vertical insertion-point cursor. You can now edit the text in the formula bar using the Copy, Cut, Paste or Delete commands or keys. Complete the entry using the Enter button in the formula bar, or by pressing the Enter key on the keyboard. 

Progress continues in fuel cell technology since the previous edition of the Fuel Cell Handbook was published in November 1998. Uppermost, polymer electrolyte fuel cells, molten carbonate fuel cells, and solid oxide fuel cells have been demonstrated at commercial size in power plants. The previously demonstrated phosphoric acid fuel cells have entered the marketplace with more than 220 power plants delivered. Highlighting this commercial entry, the phosphoric acid power plant fleet has demonstrated 95+% availability and several units have passed 40,000 hours of operation. One unit has operated over 49,000 hours. 

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. 

One way to remove, or strip, the parenthetical uncertainties in the table of atomic masses is to use Excel s Find/Replace function. We will illustrate this approach with a few of the entries. Copy the atomic masses from hydrogen through copper, including the uncertainties, to column F, cells F2 F30. Now highlight cells F2 F30. Go to the Edit menu and choose Replace. This should bring up the Find and Replace window shown below. Make sure the Replace tab is selected as shown. 

Under the View tab (i.e., under Tools => Options => View) you can toggle the appearance of spreadsheet Gridlines on or off. Under the Edit tab (Tools => Options => Edit) you can (de) select to Edit directly in the cell, which allows you to edit in the cell (after double-clicking) rather than in the formula bar. Here you can also Allow cell drag and drop or disallow it, and Move selection after enter in case you prefer the cursor to stay put or move sideways rather than move down one cell after each data, text, or formula entry. 

---