| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Header Rows
I am still a novice when it comess to Excel, but I'm learning more about it.
I had to edit a table in Excel today and could not figure out how to create a header row to print on each page. Any suggestions? -- Sactrain3 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Header Rows
In File, Page Setup, there is a field for "Rows to Repeat at Top".
"Sactrain3" wrote: I am still a novice when it comess to Excel, but I'm learning more about it. I had to edit a table in Excel today and could not figure out how to create a header row to print on each page. Any suggestions? -- Sactrain3 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Header Rows
Thanks KePaHa! :P
-- Sactrain3 "KePaHa" wrote: In File, Page Setup, there is a field for "Rows to Repeat at Top". "Sactrain3" wrote: I am still a novice when it comess to Excel, but I'm learning more about it. I had to edit a table in Excel today and could not figure out how to create a header row to print on each page. Any suggestions? -- Sactrain3 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Header Rows
Page Setup, Sheet, field "rows to repeat at top" then the tricky thing is
enter a range, eg "A1:A5". If you have more than one row, I'm lost. -- TGS "Sactrain3" wrote: I am still a novice when it comess to Excel, but I'm learning more about it. I had to edit a table in Excel today and could not figure out how to create a header row to print on each page. Any suggestions? -- Sactrain3 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Header Rows
A1:A5 will give you 5 rows repeated
For more than one row the general syntax is................ $1:$x where x is row number Gord Dibben MS Excel MVP On Sat, 21 Jun 2008 21:37:00 -0700, TGS wrote: Page Setup, Sheet, field "rows to repeat at top" then the tricky thing is enter a range, eg "A1:A5". If you have more than one row, I'm lost. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header Rows | Setting up and Configuration of Excel | |||
| Use rows 1-3 for header on all 13 pages | Excel Discussion (Misc queries) | |||
| How i can set two different rows as header and footer | Excel Worksheet Functions | |||
| Repeat Rows Across not in Header | Excel Discussion (Misc queries) | |||
| I need multiple header rows | Excel Discussion (Misc queries) | |||
![Sactrain3[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
