Solved

Excel How to hide cells

Posted on 2014-10-06
4
147 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to line 23 53
first name and last initial in excel 11 28
Getting rid of #VALUE! 7 22
Excel: How to compare data in two columns 17 30
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

839 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