ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I hide a column in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/15913-how-can-i-hide-column-excel.html)

tjenkgrp

How can I hide a column in excel?
 
How can I hide a column in Excel that others I send the sheet or workbook to
cannot unhide, but can still add/modify other information in a sheet or
workbook?

Dave Peterson

You can lock the cells in that column
(select the column|format|cells|protection tab|checked Locked)
Unlock the other cells
Hide that column
protect the sheet (tools|protection|protect sheet)

But xl's worksheet protection isn't made for this. It can be broken really
quickly. If you have stuff that others shouldn't see, don't put it in a
workbook that you share with others.

tjenkgrp wrote:

How can I hide a column in Excel that others I send the sheet or workbook to
cannot unhide, but can still add/modify other information in a sheet or
workbook?


--

Dave Peterson


All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com