| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
expand spreadsheet to fit the screen
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
expand spreadsheet to fit the screen
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 -- Gary''s Student - gsnu200713 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
expand spreadsheet to fit the screen
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! "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200713 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
expand spreadsheet to fit the screen
check toolsprotectionworkbook 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) "Howdego" wrote: 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! "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200713 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
expand spreadsheet to fit the screen
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. "John" wrote: check toolsprotectionworkbook 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) "Howdego" wrote: 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! "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200713 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easiest way to expand 1 spreadsheet to a workbook of 12. | New Users to Excel | |||
| spreadsheet too large on the screen | Excel Discussion (Misc queries) | |||
| my spreadsheet is too far up on the excel screen and I cannot cli. | Excel Worksheet Functions | |||
| Spreadsheet off screen | Excel Discussion (Misc queries) | |||
| The bottom of my spreadsheet is off the screen | Excel Discussion (Misc queries) | |||
Linear Mode
