How do I keep same column headings on different sheets in excel

B

Big Bad Nige

I want to keep the same column headings when I move to a new sheet in Excel,
how do i set it up so the new sheet always has the same titles, without the
need to copy and paste each time ?
 
K

Kevin B

If you select all the workbooks by clicking on the first sheet and then
Shift+Click on the last sheet it will group the worksheets. You can then
type or paste your heading and formulas,format the worksheet and type all
your constants and the changes occur in all selected workbooks.

To ungroup you can either click on an unselected tab, or right click on any
selected tab and select Ungroup.
 
M

Marcelo

another way, is select all sheets except the first and put on the read row
the formulas

=sheet1!a1 on A1
=sheet1!b1 on B1

etc

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Big Bad Nige" escreveu:
 
D

dk_

Kevin B said:
If you select all the workbooks by clicking on the first sheet and then
Shift+Click on the last sheet it will group the worksheets. You can then
type or paste your heading and formulas,format the worksheet and type all
your constants and the changes occur in all selected workbooks.

To ungroup you can either click on an unselected tab, or right click on any
selected tab and select Ungroup.
Click to expand...

Kevin,

That is the MOST amazing trick ever. Unbelievable!

Where did you find that information???

-Dennis
 
Top