| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create column headings at top of every sheet?
I once knew how to generate column headings at the top of every deisplayed
sheet as I moved down through seccessive sheets of a worksheet. But am now unable to find it again. Please help. Don J ------------------------------------------------------------------- |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create column headings at top of every sheet?
Do you mean....
From the Excel main menu: <window<freeze panes Does that help? *********** Regards, Ron XL2002, WinXP "Don J" wrote: I once knew how to generate column headings at the top of every deisplayed sheet as I moved down through seccessive sheets of a worksheet. But am now unable to find it again. Please help. Don J ------------------------------------------------------------------- |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create column headings at top of every sheet?
If you are trying to create multiple worksheets with the same headings, you
can do the following: 1) Select the first worksheet tab 2) Hold down shift and select the last worksheet tab (this selects all of the worksheets) 3) Type the column headings, formulas, enter formatting, etc. in the first tab. End Result: Whatever you enter while you've got the worksheet tabs selected will show up on all of the selected worksheets. "Don J" wrote: I once knew how to generate column headings at the top of every deisplayed sheet as I moved down through seccessive sheets of a worksheet. But am now unable to find it again. Please help. Don J ------------------------------------------------------------------- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| Create Headings from Column Data | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Hybrid Mode
