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

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 ?

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

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.
--
Kevin Backmann


"Big Bad Nige" wrote:

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 ?

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

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:

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 ?

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

In article ,
Kevin B wrote:

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.

Kevin,

That is the MOST amazing trick ever. Unbelievable!

Where did you find that information???

-Dennis

--
Dennis Kessler
http://www.denniskessler.com/acupuncture