Here I am going to say excel tricks which will be very useful to you.
How to Reduce Excel File Size Without Using Any Software??
If you want to reduce the Excel file size for Example if the Excel file size is 20 MB you want to reduce to 70% or 60% of its size mean what will you do ??? Will you use a software to reduce the Excel file size ? But here I will say one method which is the built in feature in MS Excel to reduce the Excel file size without using any software. Just follow the following steps,
- First, Open the Excel file which you wish to reduce its size.
- Go to File Menu and click the “Save As” option.
- Then Click on the Browse and select your location where your Excel file wants to place and change the File name and in Save a type change to Excel Binary Workbook.
- Finally, click Save Button.
- Now Go to the location where you have saved and now you can see that file size is reduced when compared to the original file.
Top 5 Quick Time-Saving Excel Tricks:
I am going to say 5 shortcut keys on Excel which I believe most of you not be knowing about and if you start working on it, you will definitely start using it on an everyday basis. Wherever do you wish to write a formula click the cell and normally we write =vl and press the tab key to activate the full autocomplete of formula the point is once we reach the bracket with the formula i.e open parenthesis generally to able to access the function argument box we click on the fx button right? but this time you don’t want to use this procedure.
Just write =vl and press the tab key to autocomplete the formula and then press the control + A and it automatically gives you that function argument box and it works for all formula.
Now enter the values in number 1 and if you want to go the next box just press the tab key and if for some reason you want to go the previous text box press shift+tab key i.e to move backward and finally press the Enter to get the answer.
Now, for instance, you have written the formula and got the answer but you want to go back to the scenario where you able to look the formula from the same function argument box approach and for this click on the cell which you wish to see the formula and press the Shift+F3 and it Quickly opens the function argument box and now you can manipulate using the tab key or shift+tab key.
If you have written group of formulas and you want to see in a quick glance what are the formulas that have been used in the background? Just press control + backtick key then automatically it shows all formula which have been written in the entire sheet and once you saw press the same key to go back to the normal. Well, the backtick key is located above the tab key on the keyboard.
Use these shortcut keys and I am sure you strat loving it these as you proceed and start working on a day to day basis.
Hope, This helps you because it is the easiest way to reduce your excel file to lowest memory without using any software and You know easy excel tricks. If you have any doubt you may leave a comment here. I am here to help you.