Difference between revisions of "Excel"

Revision as of 15:31, 24 June 2014

Hide zero values in selected cells

For a selection only

Follow this procedure to hide zero values in selected cells. If the value in one of these cells changes to a nonzero value, the format of the value will be similar to the general number format.

• • Select the cells that contain the zero (0) values that you want to hide.
  • On the Format menu, click Cells, and then click the Number tab.
  • In the Category list, click Custom.
  • In the Type box, type 0;-0;;@

For all worksheet

• Click the Microsoft Office Button Button image, click Excel Options, and then click the Advanced category.
• Under Display options for this worksheet, select a worksheet, and then do one of the following:
  • To display zero (0) values in cells, select the Show a zero in cells that have zero value check box.
  • To display zero values as blank cells, clear the Show a zero in cells that have zero value check box

How to reset the last cell in Excel

Manually delete excess rows and columns. To reset the last cell by manually deleting excess rows and columns, follow these steps:

1. Select all columns to the right of the last column that contains data by selecting the appropriate column headings. Tip One way to do this is to press F5 and type the appropriate reference. For example, type F:IV for columns, or type 5:65536 for rows.
2. On the Edit menu, click Clear All. Note If this step does not clear all the excess formatting, you may have to right-click the columns and then click Delete to fully remove the cells. If you delete cells that are referenced by formulas, the reference changes to "#REF!." Therefore, we recommend that you create a backup of the original file and then check your formulas for "#REF!" after you follow these steps.
3. Repeat steps 1 and 2 for the rows that are under the last row that contains data.
4. Save the file.
5. To continue working in the file, close and then reopen the file.