Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
londonchick
 
Posts: n/a
Default Possible to view spreadsheets without scroll bars?


Hi all.
I have a question regarding large spreadsheets.
I want it to look very professional and ideally would like the user to
view it on the screen rather then having to scroll down and then across
at various points!
Any way to achieve this?

Any suggestions regarding a way in which to make spreadsheet more
professional are very welcome.

Thank you!


--
londonchick
------------------------------------------------------------------------
londonchick's Profile: http://www.excelforum.com/member.php...o&userid=24529
View this thread: http://www.excelforum.com/showthread...hreadid=381590

  #2   Report Post  
keithl816
 
Posts: n/a
Default


Hi londonchick,

Depending on how far across and down you have gone on your spreadsheet
you could try clicking on the zoom button and reducing the cell size to
view a larger area.


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=381590

  #3   Report Post  
londonchick
 
Posts: n/a
Default


Is there a way to view/display 2 or 3 sheets within one spreadsheet?


--
londonchick
------------------------------------------------------------------------
londonchick's Profile: http://www.excelforum.com/member.php...o&userid=24529
View this thread: http://www.excelforum.com/showthread...hreadid=381590

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

Window|new window
(twice to get 3 total windows)

Window|Arrange|Tiled(?)
check windows of activeworkbook

You'll see book.xls:1, book.xls:2, book.xls:3 in the title bars.

These are just your separate windows.

When you're tired of viewing those separate windows, select the one you want to
get rid of and hit ctrl-w.

(Repeat until you're happy!)

londonchick wrote:

Is there a way to view/display 2 or 3 sheets within one spreadsheet?

--
londonchick
------------------------------------------------------------------------
londonchick's Profile: http://www.excelforum.com/member.php...o&userid=24529
View this thread: http://www.excelforum.com/showthread...hreadid=381590


--

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
of Named Ranges, Dynamic Charts and scroll bars... z.entropic Charts and Charting in Excel 2 May 20th 05 07:16 PM
Excel opens saved workbook without tabs or scroll bars showing? Dave W Franklin Excel Worksheet Functions 1 May 11th 05 11:11 PM
Custom scroll bars skipping values hodeware Excel Discussion (Misc queries) 0 March 29th 05 08:31 PM
Scroll Bars Do Not Appear in Excel XP LeoMac Excel Discussion (Misc queries) 1 February 3rd 05 04:30 PM
Scroll bars (vertical and horizontal). Doc Excel Discussion (Misc queries) 2 December 7th 04 03:33 PM


All times are GMT +1. The time now is 08:58 PM.

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"