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.
(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
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…
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…