Sat 01 Feb 2020

VBA - Optimize File Size by Clearing Unused Area

By |Saturday, February 01st, 2020|Categories: VBA|Tags: , , , , , , , |0 Comments

Sometimes, you find that your file size is very huge even though data contained in not much. The reason for this is that there are unused formatting beyond your data range. Either you can clear off your rows and columns beyond data range but if this is frequent, you can use a macro to do this. You can perform following manual steps to do this without a macro. (more…)

Sat 04 Oct 2014

Tips & Tricks 57 - Remove All Comments from a Sheet

By |Saturday, October 04th, 2014|Categories: Tips and Tricks|Tags: , , |0 Comments

1. Home Tab > Find and Select > Comments - This will select all the cells where comments are there.


2. Home Tab > Clear > Clear Comments - This will clear all comments from the sheet