Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


Excel comment change shape

Many Excel users make use of the comment feature to leave notes for themselves and others about what they were thinking or with instructions for using the spreadsheets. A query we sometimes receive is whether the excel comment can change shape. So instead of the boring box, can you use one of the other shapes?

As shown on the Contextures site, you can do this via the Quick Access Toolbar. First thing to do is to get the Change Shapes button into your Quick Access Toolbar. Once that is done all you need to do is click on the comment and click again on the border of the comment so that the image is highlighted (no flashing cursor in the text).

Now click on the Change Shapes button in the Quick Access Toolbar and chose your shape.

For other visualisation and dashboard type tips attend our Dashboards in Excel course