General discussion


multiple window splits in excel

By Hi_Aftab ·
How can i use both window split at 2 different places in a single excel sheet or how can i use window plit and freeze panes in an excel simultaneously?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by zimonar In reply to multiple window splits in ...

Open all related workbook files. Size and position them accordingly; click Window from the menu bar, click Arrange?, select Tiled and click OK. Click on each title of your workbook and select Freeze Panes / Split.
To save, choose File, Save Workspace? In the File name box type a unique file name. Click on Save.

Related Discussions

Related Forums