Excel Compendium: Using Hide and Protect

Columnist
Share this content
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

Replies

Please login or register to join the discussion.

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