ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Very Wide Spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/170234-very-wide-spreadsheet.html)

Kristine

Very Wide Spreadsheet
 
I have a large spreadsheet that we need to update info all the way across
25-30 columns. We tried hiding columns but then when we changed data say in
row W, it wouldn't let us unhide the other columns.

Can we use freeze? Does anyone have a better idea.

Thanks for your help.

Stephen[_2_]

Very Wide Spreadsheet
 
I cannot understand this. Firstly, W is a column, not a row. Secondly, if
you need to change data in 25-30 columns, you need access to these, so why
would hiding columns help? (Or for that matter, any kind of freeze?)
Thirdly, changing data in cells doesn't affect the ability to hide/unhide
columns. Lastly, what exactly is the problem?

"Kristine" wrote in message
...
I have a large spreadsheet that we need to update info all the way across
25-30 columns. We tried hiding columns but then when we changed data say
in
row W, it wouldn't let us unhide the other columns.

Can we use freeze? Does anyone have a better idea.

Thanks for your help.





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

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