ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/149238-excel.html)

Andy

Excel

Can I hide rows or columns on a protected worksheet?

JLatham

Excel

In Excel 2003, when you choose to protect a sheet you have some options you
can set - two of those are "Format Columns" and "Format rows". If you 'tick'
"Format Columns" then you can hide/unhide them even if the sheet is
protected. Same for Rows.

"Andy" wrote:

Can I hide rows or columns on a protected worksheet?

Andy

Excel

"Andy" wrote:

Can I hide rows or columns on a protected worksheet?

Thank you that was very helpful.

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