Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Andy
 
Posts: n/a
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot tables - inserting columns Scott Excel Worksheet Functions 1 March 19th 05 01:07 AM
excel macros truncating tabs for hidden columns. SharanS Excel Discussion (Misc queries) 0 February 17th 05 05:05 AM
How do I lock hidden columns? Henk Neuhoff via OfficeKB.com Excel Worksheet Functions 3 January 26th 05 12:50 PM
How can I see column headings of hidden columns in Excel before u. Beachcomber Excel Discussion (Misc queries) 10 December 10th 04 01:35 PM
a way sum only columns not hidden? Todd Excel Worksheet Functions 4 December 7th 04 05:16 PM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"