ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to delete a section of column extending to 2nd page in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/93298-how-delete-section-column-extending-2nd-page-excel.html)

carequest

How to delete a section of column extending to 2nd page in Excel?
 
I am a novice with Excel. One column on a single page worksheet extends to a
second page that prints. It is not needed. How do I delete it?

KellTainer

How to delete a section of column extending to 2nd page in Excel?
 

Simple, go to print preview and find out the column which overflows to
the 2nd page. After that, go back to your spreadsheet, then select the
area which you are sure will not overflow and you do want to print.

Go to File-Print Area-Set Print Area

That will do the job.

Alternatively, you could always print it in landscape, and not have to
delete it.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=550751


carequest

How to delete a section of column extending to 2nd page in Excel?
 


"carequest" wrote:

I am a novice with Excel. One column on a single page worksheet extends to a
second page that prints. It is not needed. How do I delete it?


Thanks!


All times are GMT +1. The time now is 05:08 PM.

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