Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i keep the names of the colums on each new page
I have a spread sheet in which each Column has a name, I want the name of
each column to appear on the subsequent pages How do I do that? Any and all information would be most Helpful Sharlene |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i keep the names of the colums on each new page
Quick and dirty (I love these)
1) If the sheet which already has the column names is the first sheet, it is easier 2) Activate that sheet then hold down the Shift Key and click on the last sheet. The first sheet will still be the one in view 3) Go to each column heading and hit F2 then Enter. Note, this has to be done individually. Even though you'd thing you could highlight every column heading using shift key and dragging, then hit F2-Enter so that the individual cells are highlighted without clicking in each column individually, you cannot. It only works if you go into the text of each heading individually with F2 or clicking in the formula bar "Sharlene" <Sharlene @discussions.microsoft.com wrote in message ... I have a spread sheet in which each Column has a name, I want the name of each column to appear on the subsequent pages How do I do that? Any and all information would be most Helpful Sharlene |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i keep the names of the colums on each new page
Thank you
"William Benson" wrote: Quick and dirty (I love these) 1) If the sheet which already has the column names is the first sheet, it is easier 2) Activate that sheet then hold down the Shift Key and click on the last sheet. The first sheet will still be the one in view 3) Go to each column heading and hit F2 then Enter. Note, this has to be done individually. Even though you'd thing you could highlight every column heading using shift key and dragging, then hit F2-Enter so that the individual cells are highlighted without clicking in each column individually, you cannot. It only works if you go into the text of each heading individually with F2 or clicking in the formula bar "Sharlene" <Sharlene @discussions.microsoft.com wrote in message ... I have a spread sheet in which each Column has a name, I want the name of each column to appear on the subsequent pages How do I do that? Any and all information would be most Helpful Sharlene |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i keep the names of the colums on each new page
Thank you, I need the names of the columns to print on the next page, not
just the sheet, so for example if sheet 1 is two pages then I need the name of the column to print on page two Thanks again ( the prior suggestion worked Great!) "William Benson" wrote: Quick and dirty (I love these) 1) If the sheet which already has the column names is the first sheet, it is easier 2) Activate that sheet then hold down the Shift Key and click on the last sheet. The first sheet will still be the one in view 3) Go to each column heading and hit F2 then Enter. Note, this has to be done individually. Even though you'd thing you could highlight every column heading using shift key and dragging, then hit F2-Enter so that the individual cells are highlighted without clicking in each column individually, you cannot. It only works if you go into the text of each heading individually with F2 or clicking in the formula bar "Sharlene" <Sharlene @discussions.microsoft.com wrote in message ... I have a spread sheet in which each Column has a name, I want the name of each column to appear on the subsequent pages How do I do that? Any and all information would be most Helpful Sharlene |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i keep the names of the colums on each new page
That is a Page Setup Issue. If you do the same things to select all sheets,
and go into File Page Setup, there is a tab names "Sheet" which has a text box labeled "Rows to repeat at top" ... enter the Row these headings appear in there (i.e., 1) or if multiple rows, "1:2", etc... "Sharlene" wrote in message ... Thank you, I need the names of the columns to print on the next page, not just the sheet, so for example if sheet 1 is two pages then I need the name of the column to print on page two Thanks again ( the prior suggestion worked Great!) "William Benson" wrote: Quick and dirty (I love these) 1) If the sheet which already has the column names is the first sheet, it is easier 2) Activate that sheet then hold down the Shift Key and click on the last sheet. The first sheet will still be the one in view 3) Go to each column heading and hit F2 then Enter. Note, this has to be done individually. Even though you'd thing you could highlight every column heading using shift key and dragging, then hit F2-Enter so that the individual cells are highlighted without clicking in each column individually, you cannot. It only works if you go into the text of each heading individually with F2 or clicking in the formula bar "Sharlene" <Sharlene @discussions.microsoft.com wrote in message ... I have a spread sheet in which each Column has a name, I want the name of each column to appear on the subsequent pages How do I do that? Any and all information would be most Helpful Sharlene |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i keep the names of the colums on each new page
Thank you again !!
"William Benson" wrote: That is a Page Setup Issue. If you do the same things to select all sheets, and go into File Page Setup, there is a tab names "Sheet" which has a text box labeled "Rows to repeat at top" ... enter the Row these headings appear in there (i.e., 1) or if multiple rows, "1:2", etc... "Sharlene" wrote in message ... Thank you, I need the names of the columns to print on the next page, not just the sheet, so for example if sheet 1 is two pages then I need the name of the column to print on page two Thanks again ( the prior suggestion worked Great!) "William Benson" wrote: Quick and dirty (I love these) 1) If the sheet which already has the column names is the first sheet, it is easier 2) Activate that sheet then hold down the Shift Key and click on the last sheet. The first sheet will still be the one in view 3) Go to each column heading and hit F2 then Enter. Note, this has to be done individually. Even though you'd thing you could highlight every column heading using shift key and dragging, then hit F2-Enter so that the individual cells are highlighted without clicking in each column individually, you cannot. It only works if you go into the text of each heading individually with F2 or clicking in the formula bar "Sharlene" <Sharlene @discussions.microsoft.com wrote in message ... I have a spread sheet in which each Column has a name, I want the name of each column to appear on the subsequent pages How do I do that? Any and all information would be most Helpful Sharlene |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i keep the names of the colums on each new page
You're welcome Sharlene
"Sharlene" wrote in message ... Thank you again !! "William Benson" wrote: That is a Page Setup Issue. If you do the same things to select all sheets, and go into File Page Setup, there is a tab names "Sheet" which has a text box labeled "Rows to repeat at top" ... enter the Row these headings appear in there (i.e., 1) or if multiple rows, "1:2", etc... "Sharlene" wrote in message ... Thank you, I need the names of the columns to print on the next page, not just the sheet, so for example if sheet 1 is two pages then I need the name of the column to print on page two Thanks again ( the prior suggestion worked Great!) "William Benson" wrote: Quick and dirty (I love these) 1) If the sheet which already has the column names is the first sheet, it is easier 2) Activate that sheet then hold down the Shift Key and click on the last sheet. The first sheet will still be the one in view 3) Go to each column heading and hit F2 then Enter. Note, this has to be done individually. Even though you'd thing you could highlight every column heading using shift key and dragging, then hit F2-Enter so that the individual cells are highlighted without clicking in each column individually, you cannot. It only works if you go into the text of each heading individually with F2 or clicking in the formula bar "Sharlene" <Sharlene @discussions.microsoft.com wrote in message ... I have a spread sheet in which each Column has a name, I want the name of each column to appear on the subsequent pages How do I do that? Any and all information would be most Helpful Sharlene |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fiting my workbook to get the most colums and rows per page | Excel Worksheet Functions | |||
HOW I PRINT MY PAGE,MADE IN EXCEL,WITH CELLS & COLUMS | New Users to Excel | |||
Is there a way to have colums wrap on a single page | Excel Discussion (Misc queries) | |||
How to separate names that are entered in 1 column into 2 colums | Excel Discussion (Misc queries) | |||
How to I set up a sheet to print colums/rows on every page in exce | Excel Discussion (Misc queries) |