Can't Clear Print Area
Any suggestions as to why I can't clear the print area of my worksheets? I
get into the sheet, select "Clear Print Area", and then I do a print preview and it shows a bunch of stuff to be printed. I'm not printing the Workbook, just the sheet. None of the sheets in the book will clear. (If I select one cell, and make that the print area, it shows just the one blank cell in print preview, but then if I choose "Clear Print Area", I'm back to printing a bunch of stuff.) Thanks |
Clearing the print are removes a previously defined print area, it does not
define "no printing". What is it that you want to accomplish? ******************* ~Anne Troy www.OfficeArticles.com "GeorgeF" wrote in message ... Any suggestions as to why I can't clear the print area of my worksheets? I get into the sheet, select "Clear Print Area", and then I do a print preview and it shows a bunch of stuff to be printed. I'm not printing the Workbook, just the sheet. None of the sheets in the book will clear. (If I select one cell, and make that the print area, it shows just the one blank cell in preview, but then if I choose "Clear Print Area", I'm back to printing a bunch of stuff.) Thanks |
Anne -
Sorry, I was off on the wrong track with this. What I was trying to do is eliminate printing all of the 40 Worksheets I have in a workbook. What I needed was to simply select the appropriate sheets, then print active sheets (with each sheets print area having been set). Sorry to have wasted your time. Thank you. George "Anne Troy" wrote: Clearing the print are removes a previously defined print area, it does not define "no printing". What is it that you want to accomplish? ******************* ~Anne Troy www.OfficeArticles.com "GeorgeF" wrote in message ... Any suggestions as to why I can't clear the print area of my worksheets? I get into the sheet, select "Clear Print Area", and then I do a print preview and it shows a bunch of stuff to be printed. I'm not printing the Workbook, just the sheet. None of the sheets in the book will clear. (If I select one cell, and make that the print area, it shows just the one blank cell in preview, but then if I choose "Clear Print Area", I'm back to printing a bunch of stuff.) Thanks |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com