Excel Compendium: Using Hide and Protect

Kashflow logo
0

Excel Hide and Protect

Introduction - Why and how you should protect workbooks

Protection

  • Steps to protect a workbook
  • Tip: Give different levels of access and avoid issues with cutting and pasting

  • Excel passwords
  • Excel objects
  • Tip: Use a PivotTable for data analysis

Hiding

Further reading and ExcelZone Any Answers queries

Introduction - why and how you should protect Excel workbooks

Protecting worksheets and workbooks can help prevent users inadvertently replacing or changing cells containing formulae or other content whilst allowing them to enter data into appropriate cells. To impro...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

Simon Hurst
Columnist
Share this content

Replies

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.