Is there a way to add a scroll bar to a few columns only in Excel?

Question

Most columns in my Excel sheet are only filled in till about row 50. However, I have 3 consecutive columns that are filled in till about row 150.

Is there any way I can add a scroll bar to these 3 columns so I can scroll down to the bottom rows while leaving the rest of the sheet put?

score 0 · Answer 1 · answered Sep 10 '14 at 11:23

0

I think you'll want to use the freeze panes feature.

It's located in the ribbon: view - window - freeze panes. You can freeze them along a row or along a column to keep what's above or left of the frozen data from moving out of view.

answered Sep 10 '14 at 11:23

Raystafarian

21,743
12
62
90

That's not really an ideal option, is there no way of adding a scroll bar to a range of cells? – user3662257 Sep 10 '14 at 14:50
or is there a way to have columns a,b,c scroll down only till row 50 and columns d, e, f scroll down till 200? – user3662257 Sep 10 '14 at 15:26
no there isn't in excel – Raystafarian Sep 10 '14 at 15:28

Is there a way to add a scroll bar to a few columns only in Excel?

1 Answers1