Category: Excel User tips

Paste Special Percentage

One of many tricks that we overlook due to the huge number of possibilities in Excel and its functions. This one I wanted to keep...

Spreadsheet Compare application

This is only available in Microsoft 365 Enterprise version, an application that can compare two workbooks in all objects. This includes cells (values or formulas)...

Comments versus Notes

It is official and looks better now, I know it might be confusing, but I liked it so far Excel now has “Comments”, the classic...

Shapes with dynamic output

A trick learned awhile ago. Creating shapes connected to cell, that updated automatically. When following steps attached, you will be able to connect any shape...

The Excel “&” bug

Just a quick find I noticed few days ago. If you notice, the & inside cell has turned into an underline of the letter after...

CTRL+Y a mini macro

On your daily work, in Excel, you have had the need to redo actions, simple same action to multiple areas perhaps Or apply similar format...