How to Repair a Virus Infected Excel File?
Microsoft Excel, a spreadsheet application, offers Calculation, Graphing tools, Pivot tables, Macro programming language called Visual Basic for Applications (VBA), etc. it has become an...
Category: Advanced
Advanced Excel Tips and Tutorials – Advanced Excel Features and Hacks Explained with Examples
Task Manager with Conditional Formatting
This task manager with conditional formatting will show you practical ways of using conditional formatting other than comparing numbers, etc. It is lightweight and very...
Print Comments in Excel
If you want to print comments in Excel, you probably realized that comments are not visible on printed worksheets by default. You need to adjust...
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...
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.
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...
