Locking/Splitting Columns in Excel is not Working

Haunz10

New Member
Joined
Nov 20, 2020
Messages
5
Office Version
  1. 2013
Platform
  1. Windows
Hi,

I am trying to lock one half of my sheet (columns A thru J) while the rest of the columns/rows can be scrolled through. I clicked right of the last column that I wanted to lock and selected freeze panes and nothing changed except a gray line now appearing. I also tried splitting the sheet and that didn't accomplish anything either. Splitting and freezing work horizontally on rows on the same sheet but not vertical on columns for some reason.

Any idea what's going here and how I can address it?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
64,052
Office Version
  1. 365
Platform
  1. Windows
Locking the columns simply means those columns will always be visible if you scroll across to the right, the same way that locking a row means it's visible if you scroll down.
AFAIK there is no way to keep 10 columns static whilst being able to scroll vertically on the rest of the sheet.
 

Haunz10

New Member
Joined
Nov 20, 2020
Messages
5
Office Version
  1. 2013
Platform
  1. Windows
Locking the columns simply means those columns will always be visible if you scroll across to the right, the same way that locking a row means it's visible if you scroll down.
AFAIK there is no way to keep 10 columns static whilst being able to scroll vertically on the rest of the sheet.
Yeah, that makes sense now that you say it. Well it would be a cool feature if it was an option.

Thanks for the reply.
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
37,484
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
One possible way to approach this might be to open a new window (View tab, Window panel, New Window button), hide any sheets you don't want to see on it, set the view of cells you want... it will then remain that way while you can scroll the other window all you want. You can split columns independently on the two windows, so you might be able to achieve what you want using this idea.
 

Haunz10

New Member
Joined
Nov 20, 2020
Messages
5
Office Version
  1. 2013
Platform
  1. Windows
One possible way to approach this might be to open a new window (View tab, Window panel, New Window button), hide any sheets you don't want to see on it, set the view of cells you want... it will then remain that way while you can scroll the other window all you want. You can split columns independently on the two windows, so you might be able to achieve what you want using this idea.
Thank you for the recommendation. That is a helpful way to do things while I analyze the data. I had hoped that I could split things so when my analysis was checked it would be easy for other individuals to reference my comments and takeaways while scrolling down to look at the data. Its by no means a necessity for me but your tip will be a helpful tool for me in the future.
 

Forum statistics

Threads
1,144,522
Messages
5,724,830
Members
422,581
Latest member
samiak

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top