Excel Compendium: Using Hide and Protect

Kashflow logo
Share this content

Excel Hide and Protect

Introduction - Why and how you should protect workbooks


  • 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


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.

About Simon Hurst


Please login or register to join the discussion.

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