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...
Category: Advanced
Advanced Excel Tips and Tutorials – Advanced Excel Features and Hacks Explained with Examples
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...
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...
List Unique Values In A Column
Often times you need list unique values in a column to summarize, check or compile results. I will show you three ways to do it...
