ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Repeating a column (https://www.excelbanter.com/excel-discussion-misc-queries/125098-repeating-column.html)

mdworske

Repeating a column
 
I have a multiple page worksheet. I need the 1st column repeated on every
page. Is this possible?

Thanks

JMB

Repeating a column
 
Click File/Page Setup/Sheet

Columns To Repeat At Left = $A:$A

"mdworske" wrote:

I have a multiple page worksheet. I need the 1st column repeated on every
page. Is this possible?

Thanks


Nick Hodge

Repeating a column
 
You can group the sheets... for non-contiguous sheets hold down the Ctrl key
and click the tabs, for contiguous sheets click the first, hold down shift
and click the last, all in between will be grouped (See [Group] in
application title bar). Now anything you do on one will be reflected in them
all.

To ungroup click on a tab not selected or right-click a tab that is selected
and select ungroup.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"mdworske" wrote in message
...
I have a multiple page worksheet. I need the 1st column repeated on every
page. Is this possible?

Thanks



David Biddulph

Repeating a column
 
Page Setup/ Sheet/ Columns to repeat at left.
--
David Biddulph

"mdworske" wrote in message
...
I have a multiple page worksheet. I need the 1st column repeated on every
page. Is this possible?





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

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