#1   Report Post  
Posted to microsoft.public.excel.misc
MartaH
 
Posts: n/a
Default multi split view

Can I get a multi split view within my sheet (e.g. two horizontal or two
vertical splits)? Let's suppose I have a list whose column headers I want to
have displayed, then the list itself, then the totals, that I also want to
have displayed, together displayed with the column headers.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default multi split view

You get one split per window.

I like to put my totals at the top (in row 1 above the headers), then use
Window|Freeze panes to make sure that they're always visible.

An alternative that I wouldn't use is to open a new window (window|new window).
Then use Window|Arrange horizontal to position the windows the way you want.

When you're done, click on the window you don't want and hit ctrl-w to close
that window.

MartaH wrote:

Can I get a multi split view within my sheet (e.g. two horizontal or two
vertical splits)? Let's suppose I have a list whose column headers I want to
have displayed, then the list itself, then the totals, that I also want to
have displayed, together displayed with the column headers.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel view won't hold tyrone_owen Setting up and Configuration of Excel 2 April 26th 06 01:20 PM
spreadsheet contents have become hidden from view clive Excel Discussion (Misc queries) 2 March 23rd 06 08:40 AM
How to view a custom view when the worksheet is protected? JulesJam Excel Worksheet Functions 0 March 6th 06 02:15 PM
Split field based on number of characters and space william_mailer Excel Worksheet Functions 6 February 10th 06 01:26 AM
View and Cell Sum Range Dewayne Excel Discussion (Misc queries) 4 December 29th 04 03:23 PM


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"