LinkBack URL
About LinkBacks
I'm now using 2013. I can't find the thick bar that I used to split panes in the past. Where did it go?
I'm now using 2013. I can't find the thick bar that I used to split panes in the past. Where did it go?
Take a look at the top of teh scroll bar, just above the ^ you should see a small "square" with a "minus" sign on it...likewise to the right of the bottom scroll bar
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes, that's what I'm used to seeing. But it's not there. There is a blank space just above the ^. If I hold down the mouse button there, a double headed arrow appears and dragging it increases the size of the box where the current cell contents are located. I suspect, if it's still available in 2013, that it's been suppressed.
the "button" Im refering to is below the double-down arrow and above the scroll bar ^ arrow
split screen.JPG
Yes, I know what to look for and it would be exactly that. But it's not there.
There's no little block to select and the double down arrow is missing too.
Here is what I'm seeing:
excel split pane control.jpg
hmm OK (no offence meant, we get users at all levels of experience, hence my reply)
I will push this to the other experts, maybe there is a setting in 2013 for that
I don't see any setting for this in the Options so that would leave me to believe that this feature must have been deprecated from Excel 2013.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Don't have 2013, Whether this shortcut works in 2013?
Alt+W+S
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I was afraid of this!! It's gone in 2013. Thanks vlady.
(ALT+W+S is to switch windows and not split panes it appears.....)
You can still invoke the split screen from the View ribbon, though.Originally Posted by fred3
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yeah, it does almost the same thing but takes more steps!You can still invoke the split screen from the View ribbon, though.
In older versions you could split the window with one vertical split and one horizontal split.
Using the Split command from the View tab gives you 4 splits, 2 of each, but you can "drag" one of each off the window if you want.
It takes two clicks ...
I get one vertical and one horizontal when I click on the split button.In older versions you could split the window with one vertical split and one horizontal split.
Using the Split command from the View tab gives you 4 splits, 2 of each, but you can "drag" one of each off the window if you want.
Duplicate post - sorry!
Before, it didn't take any clicks!
In my version of Excel 2013 I get 4 splits. I can't see why anyone would want 4. Makes the screen look too "busy".I get one vertical and one horizontal when I click on the split button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks