Easy Methods To Reduce File Size Of Excel Spreadsheets

By Author: Sheree Schiffman
Total Articles: 5
Comment this article

Hard drive space is a great commodity on a computer. Your hard drive has all of the software files necessary to operate your computer. It is also the default location for where files will be saved on your computer. Due to this default action, a hard drive can quickly become full of different files just through sustained use of the computer. As hard drive space decreases, you have fewer places to store your files and your computer may become slow as managing so many files takes a lot of processing power. One file type in particular that uses a lot of hard drive space are Microsoft Excel spreadsheet files. These spreadsheets are huge files by default and rarely use all of the space accessible in the spreadsheet. Because of this, Excel spreadsheets can be one of first files chosen to delete and free up extra space.
There are a number of strategies available for cutting down on the size of Excel spreadsheet files. One way of doing this is to manually reduce the size of the file. To do this, the file must initially be opened on the computer. ...
... From this point, scroll down to any unused cells at the bottom of the spreadsheet. From here, select the rows of cells you want to delete by clicking the cell row number on the very left of the spreadsheet. After that, choose the delete button on the keyboard and the cells will be deleted, thus reducing the size of the spreadsheet.
A way of reducing the size of an Excel spreadsheet is to save the file in a format that uses less space on the hard drive. This can be executed like the previous mentioned method by first opening the Excel file. Then, click the ‘Office' button in the upper left hand corner of the Excel window. This will bring up a menu of options for the spreadsheet. Click the ‘Save As' button located about halfway down the list of options. This will bring up another window with various options for saving. Click the arrow next to the ‘File Type' option to bring up options for saving the file. Then, choose the .xlsb option to save as an Excel binary file, which uses much less space than a traditional .xls file.
A far easier way of reducing Excel file size is through software available from http://www.hothotsoftware.com/ms_excel_reduce_file_size_software/. By going to the website and searching ‘Reduce File Size of Excel Spreadsheets' you will find software designed specifically to meet your requirements. The software will open up in a single window and works completely within a single window. This reduces the chance of getting confused by the software. You will first see an empty field at the top of the software window. Excel files needing to be shrunk can be added to the software by clicking the ‘Add File(s)' button or the software can search through a folder for any Excel files available. After the files have been added to the software you just need to click the ‘Reduce Microsoft Excel Spreadsheet File Sizes' button to start the application process. The process completes very quickly and will output all of the Excel files in a smaller format.
If you'd like to learn more about how to use this software, please visit https://www.youtube.com/watch?v=Gxww0muDu7Q#t=10. Excel spreadsheets can take up a lot of hard drive space. Utilize this software to free up hard drive space so you can continue generating and saving important files.