Forum Discussion
reducing size of worksheet
The size of a scroll bar indicates the proportional amount of the used area of the sheet that is visible in the window. My scrollbar indicates I have very many more active columns on my w...
use ctrl+end to see where your end cell is, then delete any blank cells
2. Reduce conditional formatting (try to avoid it unless necessary)
3. reduce formulas (if you can use values)
4. if using pivot table , dont save a copy of your data with pivot table, as it is already stored in pivot cache
2. Reduce conditional formatting (try to avoid it unless necessary)
3. reduce formulas (if you can use values)
4. if using pivot table , dont save a copy of your data with pivot table, as it is already stored in pivot cache