Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How to make workbooks smaller in window

I have several workbooks that, when opened, their boarders go beyond the
sides of the window/screen. Excel will not let me grasp the edges of the
workbook to make the dimensions smaller, and I cannot scroll down to grasp
the bottom of the workbook.
Regardless of the size of font of the worksheets, the workbook remains huge
and un-modifyable.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default How to make workbooks smaller in window

You can try using View/Zoom from the menu bar and selecting a lower
percentage value (maybe 50%) in order to see more of the grid.

--
Rick (MVP - Excel)


"govana" wrote in message
...
I have several workbooks that, when opened, their boarders go beyond the
sides of the window/screen. Excel will not let me grasp the edges of the
workbook to make the dimensions smaller, and I cannot scroll down to grasp
the bottom of the workbook.
Regardless of the size of font of the worksheets, the workbook remains
huge
and un-modifyable.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 117
Default How to make workbooks smaller in window

You may be refering the the Application window (Micorsoft Excel) on your
desktop but I think more likely you're refering to the File window within
Excel.
Within Excel each open file can be in one of three modes; minimized,
maximized or restored. In the restored mode the window can be re-sized by
grabbing and dragging a side or corner. It sounds as if the window has been
"stretched" beyond the boarders of the application window. You can maximize
the window by double-clicking on the Title bar (just above the column
headers). You can also resize the window by first moving the window (Click
on the title bar and drag) to a position where you can get hold of a corner.
Resize the window smaller by dragging a corner in toward the center. Repeat
this process until the window is within the application boarders.
Hope this helps.


"govana" wrote in message
...
I have several workbooks that, when opened, their boarders go beyond the
sides of the window/screen. Excel will not let me grasp the edges of the
workbook to make the dimensions smaller, and I cannot scroll down to grasp
the bottom of the workbook.
Regardless of the size of font of the worksheets, the workbook remains
huge
and un-modifyable.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How to make workbooks smaller in window

I'd resize the sheet windows to fit inside excel's window:

In xl2003 menus:
Window|arrange|tiled

Then resize them the way I want--maximized within excel or just drag by the
edges.

govana wrote:

I have several workbooks that, when opened, their boarders go beyond the
sides of the window/screen. Excel will not let me grasp the edges of the
workbook to make the dimensions smaller, and I cannot scroll down to grasp
the bottom of the workbook.
Regardless of the size of font of the worksheets, the workbook remains huge
and un-modifyable.


--

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
How do you make cells smaller? brawl Charts and Charting in Excel 4 April 5th 23 02:44 PM
How do I size a worksheet ? ( make smaller ) MartyH Excel Discussion (Misc queries) 5 May 31st 07 06:45 PM
The window opens in a smaller window not full sized window. Rachael Excel Discussion (Misc queries) 0 November 7th 06 09:04 PM
How to split worksheet to make smaller Ltl Doc Excel Worksheet Functions 1 April 5th 06 08:14 AM
Make Values Smaller Q John Excel Worksheet Functions 1 December 14th 04 03:40 PM


All times are GMT +1. The time now is 03:48 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"