mthomas.co.uk

One of the features of Excel is the ability to hide cells. However, if you copy a range that contains hidden cells and paste the selection elsewhere, you get all the rows including the hidden ones. This short tutorial will show you how to copy just the visible cells.

I spend about 2 hours a day walking my dog. In order to ensure that this time is used effectively, I usually listen to a podcast on my iPhone. If it’s not raining, I’ll also use the phone to check email, send texts, surf the web and Twitter.