Tag Archives: hidden

Don’t be fooled – protecting isn’t bullet-proof

SharynAvatarBlog120x120When I’m asked to teach a class on how to restrict editing within a document, the first 5 minutes of my instruction is usually spent explaining that protecting isn’t bullet-proof.

Why do I do this?  Because I have met so many people who assume that restricting the editing of a document by adding a password is in fact securing it so that only the holder or holders of the password can access the file.  Not true!  Via the Internet you can easily access a multitude of work-arounds that coach you through how to easily access the content of a restricted file. Continue reading Don’t be fooled – protecting isn’t bullet-proof

Excel – 5 Paste tips that will save you HEAPS of time

SharynAvatarBlog120x120Ever wondered what the most used command is in Excel?

I have. In fact a few years back I searched for the answer on Google.  I had thought that the answer would surely be ‘Undo’, especially when I think about how often I use the fabulous Ctrl + Z key combination. Amazingly I found a page (which sadly I’m unable to find now) that claimed that Undo wasn’t the most used…it was Paste, Ctrl + V. Continue reading Excel – 5 Paste tips that will save you HEAPS of time

Excel – hiding, unhiding and finding hidden Columns and Rows

SharynAvatarBlog120x120You can easily hide rows and columns in Excel.  However sometimes it isn’t obvious where columns and rows have been hidden.

In this tutorial I show you how to hide and unhide columns and rows and how to easily locate where columns and rows have been hidden in a worksheet. Continue reading Excel – hiding, unhiding and finding hidden Columns and Rows