Remove any links to other Excel filesĭoes your file have any links to other Excel workbooks? Want other tips to reduce the file size of your Microsoft Excel workbook? Try the Ultimate Guide to Reducing File Size in Excel. If this cell is far beyond where your data is, then you’ll need to delete some rows & columns. To check on the Used Range, press Ctrl + End and the cursor will jump to the end of the workbook. This range of cells is called the “Used Range” and it’s what Excel keeps in its memory. When this happens, Excel still “stores” those cells in its memory and if there are a lot of unused cells, it can slow down your Excel workbook. In old Excel files, some additional rows & columns might have been used a long time ago but the data has now been deleted. Get rid of unused cells by reducing the Used Range
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |