ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protect Hidden Columns and Rows (https://www.excelbanter.com/excel-discussion-misc-queries/185545-protect-hidden-columns-rows.html)

Jeremy

Protect Hidden Columns and Rows
 
I have a Spreadsheet that has several hidden columns. Oftentimes, entire
rows will be deleted. Is there any way to delete a row, while protecting the
hidden content?

Dave Peterson

Protect Hidden Columns and Rows
 
You mean avoid deleting that hidden column when you delete a row?

Nope. If you delete a row, you delete a row.

Any chance you could move the hidden column to a different worksheet--and even
hide that worksheet???

Jeremy wrote:

I have a Spreadsheet that has several hidden columns. Oftentimes, entire
rows will be deleted. Is there any way to delete a row, while protecting the
hidden content?


--

Dave Peterson


All times are GMT +1. The time now is 04:08 AM.

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