Thread: [Solved] page scrolling
View Single Post
 
Old 04-16-2014, 03:57 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Yes you can.

On the top right, under the formula bar, is a little doohicky that you can slide down to put a "pane" on the sheet. There is likewise another on the bottom right that you can slide to the left.

You can leave them like that but I like to freeze them in place. To do that: View:Freeze Panes:Freeze Panes.

See attached file.
Attached Files
File Type: xlsx Valve chart w panes.xlsx (22.3 KB, 9 views)
Reply With Quote