Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the horizontal split box back?
I have a spreadsheet that has data on it and would like to view the bottom
and top at the same time. I also want to be able to scroll each pane. The problem is that the horizontal and vertical split boxes are not there. Where did they go, or more importantly: how can I get them back? When I open a new spreadsheet, the split boxes are there. It's just on the spreadsheets that are already in use that the boxes aren't there. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the horizontal split box back?
On Nov 6, 11:00*am, CJred wrote:
I have a spreadsheet that has data on it and would like to view the bottom and top at the same time. I also want to be able to scroll each pane. The problem is that the horizontal and vertical split boxes are not there. Where did they go, or more importantly: how can I get them back? When I open a new spreadsheet, the split boxes are there. It's just on the spreadsheets that are already in use that the boxes aren't there. Well, that's backwards from most. Window Menu: Split. Or double click (or click-and-drag) on the tiny little bar just above the scroll up button for the horizontal split. And the little bar just to the right of the scroll right button for vertical split. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the horizontal split box back?
Double clicking doesn't work either because the tiny bar isn't there. That's
what I was referring to when I said the split boxes aren't there. Thanks anyway! "Spiky" wrote: On Nov 6, 11:00 am, CJred wrote: I have a spreadsheet that has data on it and would like to view the bottom and top at the same time. I also want to be able to scroll each pane. The problem is that the horizontal and vertical split boxes are not there. Where did they go, or more importantly: how can I get them back? When I open a new spreadsheet, the split boxes are there. It's just on the spreadsheets that are already in use that the boxes aren't there. Well, that's backwards from most. Window Menu: Split. Or double click (or click-and-drag) on the tiny little bar just above the scroll up button for the horizontal split. And the little bar just to the right of the scroll right button for vertical split. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the horizontal split box back?
Do you have Freeze Panes turned on? You can't use both Freeze and
Split. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the horizontal split box back?
OMG! Thank you so-o-o much. That was definitely the problem. I'm glad it was
something so simple. You learn something new everyday! "Spiky" wrote: Do you have Freeze Panes turned on? You can't use both Freeze and Split. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the horizontal split box back?
On Nov 6, 12:55*pm, CJred wrote:
OMG! Thank you so-o-o much. That was definitely the problem. I'm glad it was something so simple. You learn something new everyday! "Spiky" wrote: Do you have Freeze Panes turned on? You can't use both Freeze and Split. No problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove split a split window? | New Users to Excel | |||
copy back macro/roll back | Excel Worksheet Functions | |||
horizontal sumif help | Excel Worksheet Functions | |||
Horizontal Subtotals | Excel Discussion (Misc queries) | |||
Horizontal split | New Users to Excel |