Forum Discussion
Splitting Spreadsheet
I'd like to divide my spreadsheet into vertical thirds so that I can have separate sets of information without as much scrolling. Is it possible to create a divide in a spreadsheet so that I can delete/add rows on the left one-third of the spreadsheet without impacting the middle section or right one-third of the spreadsheet?
Thank you!
Hey Heidi-
Hope you're doing well. Unfortunately, this is not possible. However, you can put the data on three different worksheets and then arrange them how you would like using native excel functionality. This will allow you to delete rows on one sheet and then they will only impact that particular dataset:
1. Go To the View Tab2. Select New Window
3. Repeat
4. Arrange windows as needed
Here is a link to some more detailed instructions:
