Link to home
Start Free TrialLog in
Avatar of gisvpn
gisvpnFlag for United States of America

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of James Elliott
James Elliott
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gisvpn

ASKER

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?
If you don't set a password can anyone unlock it?

Yep
Avatar of gisvpn

ASKER

Great thanks.