ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I unprotect a spreadsheet? (https://www.excelbanter.com/excel-worksheet-functions/206135-how-do-i-unprotect-spreadsheet.html)

Sofiya

How do I unprotect a spreadsheet?
 
I received a spreadsheet from my client and while I can view all the pages, I
can only print some, even if I select print entire worksheet.

How can I "unprotect" the worksheet so that I can print all the pages?

Thanks :)

Sofiya

John C[_2_]

How do I unprotect a spreadsheet?
 
Doesn't sound like it is protected, it sounds as if it has a defined Print
Area.

You could try File|Print Area|Clear Print Area
and see if that helps.

Forewarned, I myself design spread sheets to only print specific print areas
because I sometimes might have data 'hidden' in columns off to the side.
--
John C


"Sofiya" wrote:

I received a spreadsheet from my client and while I can view all the pages, I
can only print some, even if I select print entire worksheet.

How can I "unprotect" the worksheet so that I can print all the pages?

Thanks :)

Sofiya



All times are GMT +1. The time now is 11:40 PM.

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