Excel 2007 : Horizontally Scrolling Table

**HangMan** · 07-05-2012, 05:25 PM

I have a 'table' which is currently scrolling vertically to allow me to show 150 rows, however the data set has 30 columns, of which I'm displaying 15. Is it possible to also scroll the 'data', horizontally to allow the user to view all 30 columns?

I tried to apply the same logic to a horizontal scrollbar as to the vertical one, but that doesn't seems to do anything. Would I need to edit the OFFSET formula to achieve this or is it simply not possible to do?

I've attached a sample for reference.

**MarvinP** · 07-05-2012, 11:06 PM

Hey Hangman,

Excel has a feature called Freeze Panes which is build in and looks like what you are needing. Why not use their build-in feature. Read about it at:
http://spreadsheets.about.com/od/exc...freezepane.htm
If Freeze Panes doesn't do it for you try to us Split Screen.
http://www.ozgrid.com/Excel/split-panes.htm

**HangMan** · 07-09-2012, 01:14 PM

Hi MarvinP,

Freeze Pains and Split Screens really wouldn't work for this. I found a much better neater using OFFSET formula and data validation lists to overcome my 'problem', but many thanks for your help.