Printing selected columns on a worksheet

M

Mike B

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
 
G

Gord Dibben

In Page Setup>Sheet select column A to "columns to repeat at left"


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Dividing Worksheet into Two Columns 2
matching data on worksheet 1
VBA group the number in the Column and Copy to the new worksheet. 0
How to print separated, selected columns on a worksheet 11
counting blank cells within two columns 2
print setup -columns to repeat 2
Print selected pages from multiple worksheets 4

Top