Excel: How do I get a certain column to show on every page?

[Guest]

Columns A, B, and C of my excel spreadsheet have important labels/categories that apply to every row of every subsequent page in the sheet. How do I make these columns show up automatically on each page?

 

[papou]

Hi Heath
Not sure I understand what you're after.
File, PageSetup, Sheet tab and see "Titles to print section"

HTH
Cordially
Pascal

Columns A, B, and C of my excel spreadsheet have important

labels/categories that apply to every row of every subsequent page in the
sheet. How do I make these columns show up automatically on each page?

 

[Guest]

Hi Heath,

If you want them to appear on every page on your hard copy, then you can go to
Page Setup - Sheet - go to the Column to repeat at left -

and then just enter the columns that you want.

hope this helps.

 

[icestationzbra]

i do it in a way which does not require macros, but may not appeal t
the fastidious.

i have a workbook which has 3 sheets.

i keep CTRL pressed and left-click on all 3 sheets, this way all th
sheets are in a certain mode of combined-edit where in any changes o
the top-most sheet will be reflected on subsequent sheets. why i sa
top-most is that, if you click on a sheet in the middle of the stack
the selection vanishes.

suppose, i CTRL-clicked on sheet1 first, and then on sheet2 and sheet3
now, i enter column and row headings on sheet1, and adorn them wit
formats. throughtout this operation, all the 3 sheets are selecte
(tabs should be white in colour). once this is completed, i click o
sheet2 or sheet3 to come out of this combined-edit mode. i would hav
all 3 sheets having identical formatting (and layout, if the need be)