To get rid of just the contents of a cell selection, select the range of cells to be cleared and press the Delete key.When you delete a cell (or an entire row or column), Excel has to shuffle the position of entries in the surrounding cells to plug up any gaps caused by the deletion.
He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. If you end up at the bottom of the spreadsheet row 65536 in Excel 97 to 2003 or 1048576 in Excel 2007 then the column is empty. Then move over one column and press CTRL the up arrow to continue checking you should be in row 1. Repeat as necessary.) In this example you need to check then select columns E, F, and G. Without pressing SAVE at this point, you might as well have not done the previous steps. Since you can see these rows over to column D (now the last column with data) you do not need to check each row to be sure it is empty. If you want to check just to be sure, start in A46 then press CTRL the right arrow. If you end up in the right most column (IV in Excel 97 to 2003 and XFD in Excel 2007), then the row is empty. You would continue until you checked down to row 75 in this example. After May 1 she will be available for special projects on a limited basis. Eventually GretchenUhasCT.com will not work so make note of UhasCTTDS.net to contact Gretchen. Gretchen trained at a variety of training centers from 2000 to 2003. All classes are created to meet the training needs of the clients, who are businesses primarily located in NH and MA but Gretchen will travel throughout the New England area. The issue is when you once had data, for example, down to row 8000 and then you deleted that data. This post is to help Excel forget that data once was in row 8000 and that the end of the data is not in row 7713.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |