MS Excel - Freezing Certain Columns from Scrolling Vertically

A

AniV

Expert Member
Joined
Jul 12, 2010
Messages
1,142
Reaction score
4
Location
Centurion
Hi guys,

I have googled extensively and read a gazillion tutorials, but can't find a solution.

I have an Excel Spreadsheet, large-ish (30 columns, 66 rows) that I am using to track progress on a project.
I have a bar chart that serves as a "Progress Bar", basically showing the percentage complete, and some totals and legends in the first 8 columns on the left (up to column H).
I would like to freeze those 8 columns so that when the rest of the page (columns I to AC) are scrolled vertically the chart columns stay where they are and the progress bar is permanently visible.

However, the Freeze function for columns seems to only freeze the 8 columns if I scroll the other columns horizontally, which I have no need for. Freezing rows for vertical scrolling requires freezing rows, and I can't do that.

Does anybody have any suggestions as to how I can get around this? Split panes do nothing - all the columns still scroll together.

I'm using Excel 2010.
Thanks in advance!
 
Why doesnt freeze panes work? First select a cell....freeze panes freezes all cells above and to the left of this cell you first selected.

Sent from my HTC Vision using MyBroadband Android App
 
I'm not trying to freeze rows and columns together. Just 8 columns. Freeze wants to freeze an entire row or entire column. You can't select just a couple of rows and columns and freeze them.

Also, freezing columns only freezes them for horizontal scrolling, and freezing rows only works for vertical scrolling.
I'm trying to freeze columns from scrolling vertically.
 
AniV said:
I'm not trying to freeze rows and columns together. Just 8 columns. Freeze wants to freeze an entire row or entire column. You can't select just a couple of rows and columns and freeze them.
Click to expand...
Which cell(s) is selected when you do the freeze panes command?
 
You can use the Split option (Under the View ribbon) to just split your document in to two and then scroll them independently.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X