| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| how do I get infopath elements as column headings in excel xml lis | Excel Discussion (Misc queries) | |||
Hybrid Mode
