•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Create a mini "viewing window" to another part of the worksheet
I have Excel 365. I want to create a small viewing window or pane that can display a portion of the same worksheet while it is offscreen. I have a list in one spot of the sheet and I want to be able to see it while working in another spot.
"Split" doesn't help because I need to view a lower portion of one column while working higher in a different column, and the split panes only scroll vertically together.
Ideally I would like to scroll the viewing pane completely separately from the sheet but even a static "peek" window would help a lot.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Excel 365
#viewing window
#worksheet
#split panes
#scroll vertically
#separate scrolling
#portion of sheet
#static peek window
#list
#mini window
#different column
#display
#offscreen
#lower portion
#higher column
#data visibility