Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SS
 
Posts: n/a
Default Is it possible to view Excel split screen by tab within same file

I would like to view split screen tabs within the same Excel workbook. Is
this possible?
  #2   Report Post  
Michael
 
Posts: n/a
Default

Hi SS. Go to Window - Arrange - and select the view you would like. It
shows all tabs. Minimize or close the ones you don't want. I find the
vertical view the easiest to use. HTH
--
Sincerely, Michael Colvin


"SS" wrote:

I would like to view split screen tabs within the same Excel workbook. Is
this possible?

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

Window|new window
Window|Arrange (horizontal/vertical/whatever you want)
Check windows of activeworkbook (if you only want that one workbook)

You'll see something like Book1.xls:1 and book1.xls:2 (and so forth).

When you're done seeing all these windows, click on one you don't want and hit
ctrl-w.

Repeat until there's only one window left (or as many windows as you want).

Remember to save it the way you want, too. But be careful, lots of users are
confused by those multiple windows into the same workbook.

SS wrote:

I would like to view split screen tabs within the same Excel workbook. Is
this possible?


--

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
Show colour on screen in Excel as printed in Excel Jim POLL Setting up and Configuration of Excel 4 August 24th 05 02:16 AM
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? Daniel Excel Worksheet Functions 2 June 28th 05 05:34 AM
Scroll the screen view with the scroll bar avbs Excel Discussion (Misc queries) 1 June 25th 05 04:43 PM
Can I view an excel file without having the excel programme. boogietracy Excel Discussion (Misc queries) 1 March 31st 05 07:54 PM
Tree View for excel sheets c2k2000 Setting up and Configuration of Excel 10 December 24th 04 06:01 PM


All times are GMT +1. The time now is 09:58 AM.

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

About Us

"It's about Microsoft Excel"