Group Data in Excel
You can group data in Excel to use worksheet space more efficiently. Grouped columns and rows can be collapsed and expanded easily to hide or...
Category: Advanced
Hide/Show Sheet Tabs
You can hide/show sheet tabs in Excel to prevent users seeing and accessing sheets that you don’t want them to.
Unable to Open Excel File After Recovery
Summary: The blog describes the standard recovery features such as AutoRecover and Open & Repair offered by MS Excel application to repair corrupt or damaged...
Microsoft Excel File Size Became 0 KB
Summary: The blog summarizes the methods to repair MS Excel workbook and explains various benefits that each procedure offers. It also describes a third-party Excel...
Search By Color In Excel
Most users does not know that they can search by color in Excel. But with a bit of attention to details, you can search by color...
Fix Microsoft Excel Error – PivotTable Field Name Is Not Valid
PivotTable is a powerful feature offered by Microsoft Excel. It helps extracting important details from detailed and large data sets. While creating a new PivotTable...
