Forum Discussion
Heidi Malone
Jun 13, 2018Copper Contributor
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 del...
Matt Mickle
Jun 13, 2018Bronze Contributor
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 Tab
2. Select New Window
3. Repeat
4. Arrange windows as needed
Here is a link to some more detailed instructions:
https://support.office.com/en-ie/article/view-multiple-panes-sheets-or-workbooks-fcdfb33e-5168-470d-a3d6-7ef1663599f3