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.


Sort Named Range in Excel

Names ranges are a controversial topic with Excel experts differing in their view on whether they are good or bad. Due to a number of model reviews we have performed we believe that they are more bad than good and try and avoid them in general. One example is when you need to sort named range in excel.

The simple answer is that the cell values move around but the named ranges continue to refer to the original cell. So if you had GP% by branch in a list with named ranges and then decided to re sort the order of the branches you could have a problem!

Speed up a slow Excel spreadsheet