Category: Advanced

Advanced Excel Tips and Tutorials – Advanced Excel Features and Hacks Explained with Examples

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...

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...