ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing selected columns on a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/224573-printing-selected-columns-worksheet.html)

Mike B

Printing selected columns on a worksheet
 
Hi
I would be gratefull if anyone can help me with this problem,

I have a worksheet containing 13 colums of data of which the first column is
frozen. I need to print the worksheet onto two pages, with column 1 appearing
on both pages, ie page 1 = columns 1 - 7 and page 2 = columns 1 & 8-13

Thanks

mike B

Gord Dibben

Printing selected columns on a worksheet
 
In Page SetupSheet select column A to "columns to repeat at left"


Gord Dibben MS Excel MVP

On Tue, 17 Mar 2009 09:13:04 -0700, Mike B
wrote:

Hi
I would be gratefull if anyone can help me with this problem,

I have a worksheet containing 13 colums of data of which the first column is
frozen. I need to print the worksheet onto two pages, with column 1 appearing
on both pages, ie page 1 = columns 1 - 7 and page 2 = columns 1 & 8-13

Thanks

mike B




All times are GMT +1. The time now is 01:40 AM.

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