Difference between revisions of "Excel"
From NavykI
(Created page with "*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: #Sele...") |
|||
| Line 1: | Line 1: | ||
*How to reset the last cell in Excel | *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: | |
| − | #Select all columns to the right of the last column that contains data by selecting the appropriate column headings. | + | #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.'' |
| − | + | #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.'' | |
| − | |||
| − | #On the Edit menu, click Clear All. | ||
| − | |||
| − | |||
#Repeat steps 1 and 2 for the rows that are under the last row that contains data. | #Repeat steps 1 and 2 for the rows that are under the last row that contains data. | ||
#Save the file. | #Save the file. | ||
Revision as of 10:54, 11 December 2013
- 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:
- 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.
- 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.
- Repeat steps 1 and 2 for the rows that are under the last row that contains data.
- Save the file.
- To continue working in the file, close and then reopen the file.
