horizontal Scroll

[fesambay]

I have an excel spreadsheet that is over 50,000 rows long
and over 50 inches wide. How do I get the horizontal
Scroll to appear on screen at all times?

 

[Cutter]

Have you tried Tools/Options/View and put a check mark beside Horizonta
scroll bar

 

[Gord Dibben]

Not sure, but you may be asking for some rows and columns to remain in view
when you scroll to the right or down.

Select a cell and Window>Freeze Panes.

Rule is.......everything above and to the left of the selected cell will
remain in view.

i.e Select B2 and Freeze Panes.

Row 1 and Column A will remain in view as you scroll.

Gord Dibben Excel MVP