Difference between revisions of "Excel"

Revision as of 16:23, 24 June 2014

• Hide zero values in selected cells

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;;@

• 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.