Did you ever wonder why your Excel File is so huge while it actually has very little information?
When you receive an excel file it was in KBs but when you make changes and save, file size surprisingly increased to MBs!! Fortunately there are several ways to overcome this problem, this article will help you learn the Top Ten Awesome Tips & Tricks to Reduce Excel File Size to a great extent without losing the actual content.
Sometimes we need to add a Prefix&Suffixto existing data to clearly indicate what the data pertains to and make it more understandable to the reader. If you want to add certain text in every selected cell beforeor after the original cell text, you can follow these steps, rather than editing each cell individually. This will save […]
Q. What is the best way to create identical worksheets? I do a lot of copying and pasting, but I’m sure there is a better way. A. One of the easiest ways is to create them all at once. Try this six-step process. Create the number of blank worksheets you’ll need. Select the first worksheet in […]
Filter/Identify Unique Values or Remove Duplicate Values In Microsoft Office Excel 2007, you have several ways to Filter for Unique Values or Remove Duplicate Values, 3 most commonly used options are listed below: 1 > To highlight unique or duplicate values, use the Conditional Formatting command in the Style group on the Home tab. 2 […]
