ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   SPREADSHEET VIEW (https://www.excelbanter.com/excel-worksheet-functions/161956-spreadsheet-view.html)

Donna Wilson

SPREADSHEET VIEW
 
The data in my spreadsheet is in a small window on the screen, but it will
not allow me to simply drag at the corner to expand the view. I am not sure
how I got in this view but I cannot seem to get it back to normal view.
There are 5 spreadsheets in the .xls file and the data window is only 3x4
inches. THANKS.

John

SPREADSHEET VIEW
 
check toolsprotectionunprotect workbook to see if the structure or window
has been protected
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Donna Wilson" wrote:

The data in my spreadsheet is in a small window on the screen, but it will
not allow me to simply drag at the corner to expand the view. I am not sure
how I got in this view but I cannot seem to get it back to normal view.
There are 5 spreadsheets in the .xls file and the data window is only 3x4
inches. THANKS.


Gord Dibben

SPREADSHEET VIEW
 
Maybe the workbook protection is enabled.

Are the restore, minimize and close icons missing from the title bar of the
window?

ToolsProtectionUnprotect workbook.


Gord Dibben MS Excel MVP

On Fri, 12 Oct 2007 11:45:05 -0700, Donna Wilson <Donna
wrote:

The data in my spreadsheet is in a small window on the screen, but it will
not allow me to simply drag at the corner to expand the view. I am not sure
how I got in this view but I cannot seem to get it back to normal view.
There are 5 spreadsheets in the .xls file and the data window is only 3x4
inches. THANKS.



Donna Wilson[_2_]

SPREADSHEET VIEW
 
Thank you, John. Worked great!

"John" wrote:

check toolsprotectionunprotect workbook to see if the structure or window
has been protected
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Donna Wilson" wrote:

The data in my spreadsheet is in a small window on the screen, but it will
not allow me to simply drag at the corner to expand the view. I am not sure
how I got in this view but I cannot seem to get it back to normal view.
There are 5 spreadsheets in the .xls file and the data window is only 3x4
inches. THANKS.



All times are GMT +1. The time now is 11:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com