Well... you can't exactly do that through the standard user interface
You could do this though:
Hide all the rows except row 1
Hide all the columns except A
Protect the worksheet
This would force someone to unprotect it before they could unhide the rows and columns.
To request a password to unhide and view a worksheet all in one go, you'd need to resort to VBA code. (We can help you with this, and it's built into Excel.)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.