expand spreadsheet to fit the screen

H

Howdego

Whenever I open a spreadsheet (originally developed from a larger
spreadsheet), the sheet opens in about 1/3 of the window. I cannot figure
out how to show more of the sheet so that it fills the whole screen. Is
there an option I am missing?
 
G

Gary''s Student

First make sure you have:
View > Normal and not PageBreak


Next make sure the Excel app and workbook windows are fully expanded


Next select the range of cells you would like to see without scrolling and:
View > Zoom... > Fit selection
 
H

Howdego

My view is normal and the and app and workbook windows are fully expanded
(douple window shown in the resize box). When I select a portion of the
worksheet and zoom to fit the selection, the highlighted section shrinks to
fill only a portion of the existing small window section. No Joy!
 
J

John

check tools>protection>workbook to make sure it is not protected and then try
to maximise again
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
H

Howdego

Got it! The workbook was protected. When I unprotected it, the spreadsheet
window added the cells to fill the screen. Now i have to learn how to
protect it and not have the problem again.

Thanks all for your help.
 
Top