ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need to lock one column and allow others to scroll (https://www.excelbanter.com/excel-discussion-misc-queries/206110-need-lock-one-column-allow-others-scroll.html)

Milazzolane

Need to lock one column and allow others to scroll
 
Hello everyone,

I have a spreadsheet with a long column of data in Column A for which I've
created a summary table on the same spreadsheet page. I want to be able to
scroll my data column (A) and leave the summary table in place, which is to
say scroll Column A vertically and none of the other columns. Is there a way
to do that?

Thanks!

David Biddulph[_2_]

Need to lock one column and allow others to scroll
 
Window/ New Window
Window/ Arrange/ Vertical
Adjust to suit
--
David Biddulph

"Milazzolane" wrote in message
...
Hello everyone,

I have a spreadsheet with a long column of data in Column A for which I've
created a summary table on the same spreadsheet page. I want to be able
to
scroll my data column (A) and leave the summary table in place, which is
to
say scroll Column A vertically and none of the other columns. Is there a
way
to do that?

Thanks!





All times are GMT +1. The time now is 07:34 AM.

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