There is no doubt in the Excel mines that Conditional Formatting is an unparalleled gem used to distinguish cells meeting defined characteristics. Sometimes, however, you may find your mind boggled on what rules belongs where with so much color fill, borders, and various font colors being a general part of worksheets.It also doesn’t help if … [Read more...]

By default, the first Table in the workbook is automatically named Table1 by Excel and it goes onto Table2, Table3, and so on. While that's helpful on Excel's part, we bet everyone is like us and can't remember what Table was for which dataset.Say, you want to jump to the Table of overdue orders but can't remember where it is in the workbook … [Read more...]

The world is ever-changing and the Excel universe can say the same. With changes in data, requirements, users (and even moods?), there may need to be a change in what bits of the dataset are made prominent or how.Changing from top 10 to top 5, from Data Bars to simple highlighting, from top 3 to the 90% percentile, highlighting cells with an … [Read more...]

Piles upon piles of data can quickly become overwhelming and Excel offers an equally quick solution to organize data and group it. Since deleting data can't be an option most of the time, grouping data allows you to choose which data you want to see and which you want to temporarily stow away.In addition to that, you can hide all the hundreds of … [Read more...]

Someone went overzealous with the visual ease of Conditional Formatting, slammed every Rule in the Conditional Formatting book, and made a circus out of a dataset. Too much Conditional Formatting is weighing your file down. Or maybe you're living a slightly easier work life than that and wanting to clear a Rule off the sheet is a small part of a … [Read more...]