View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default How to show a whole worksheet on one screen?

On Jul 8, 2:09 pm, "Pete_UK" wrote:
If you try to display 255 columns on a screen you will not be able to read
what is in them. If you really must try it, then use the Zoom setting (on
the Format bar, or under View | Zoom) - you will probably need to set it to
about 10%.


10% is the smallest Excel goes, at least version 2003. And unless you
have a large monitor that can show more than 1500 horizontal pixels,
it still won't show 255 rows. Most people have their monitors set to
1024 pixels wide regardless of how big it is, which probably shows 160
columns or so maximum.