ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hidden Columns are unhidden when inserting a Formula (https://www.excelbanter.com/excel-discussion-misc-queries/20491-hidden-columns-unhidden-when-inserting-formula.html)

Andy

Hidden Columns are unhidden when inserting a Formula
 
I have a spreadsheet where I have various formula columns
hidden. When I attempt to insert a formula in any of the
unhidden cells, it automatically unhides the hidden
columns, which is dramatically slowing down the
spreadsheet development process.

Any ideas? Is there a setting that I could toggle on-off?


All times are GMT +1. The time now is 11:16 AM.

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