Solved

Excel How to hide cells

Posted on 2014-10-06
4
148 Views
Last Modified: 2014-10-06
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
Comment
Question by:gisvpn
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
James Elliott earned 500 total points
ID: 40363307
(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
 

Author Comment

by:gisvpn
ID: 40363319
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
 
LVL 12

Expert Comment

by:James Elliott
ID: 40363323
If you don't set a password can anyone unlock it?

Yep
0
 

Author Comment

by:gisvpn
ID: 40363348
Great thanks.
0

Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question