![]() |
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? |
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