Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

Excel How to hide cells

Hello,

I have a worksheet where I would like to send to a client to review but I want to hide certain rows on a spreadsheet but not delete them from the workbook.

I know you could do this by using the hide feature but I would like to client to not be able to 'unhide' them and also I would like to the client to be able to edit the cells that they can see when the other are hidden.

Is there something in Excel that would meet this requirements, I have been searching but could not find anything.

Regards,

GISVPN
0
gisvpn
Asked:
gisvpn
  • 2
  • 2
1 Solution
 
James ElliottManaging DirectorCommented:
(1) Ctrl+A to select all of your cells
(2) Right click => Format cells => Protection => Untick 'locked'
(3) Click ok
(4) Select the row(s) you want to hide
(5) Right click => Format cells => protection => Tick 'locked'. click ok
(6) right click => hide
(7) click 'review' tab at the top => protect sheet => untick 'select locked cells' (add optional password)

report back if any probs.
0
 
gisvpnAuthor Commented:
brilliant works a treat! Thank you had no idea this feature could be used.

If you don't set a password can anyone unlock it?
0
 
James ElliottManaging DirectorCommented:
If you don't set a password can anyone unlock it?

Yep
0
 
gisvpnAuthor Commented:
Great thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now