| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting rows in a spread sheet.
How can I format the top row (or two) of an Excel spread sheet and make it
appear on every page? I'm trying to create a list and I want the top cell in each column to be on each page. -- Pete |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting rows in a spread sheet.
It's called a Header. Look under Page Setup. The specifics depend on which
version of Excel you are using. Regards, Fred "Pete" wrote in message ... How can I format the top row (or two) of an Excel spread sheet and make it appear on every page? I'm trying to create a list and I want the top cell in each column to be on each page. -- Pete |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting rows in a spread sheet.
Select A2 and WindowFreeze Panes to freeze row 1
In 2007 that would be ViewFreeze Panes. The row or rows above your selected cell will remain frozen. i.e. A3 and freeze wil keep rows 1 and 2 frozen. Gord Dibben MS Excel MVP On Tue, 9 Feb 2010 14:39:01 -0800, Pete wrote: How can I format the top row (or two) of an Excel spread sheet and make it appear on every page? I'm trying to create a list and I want the top cell in each column to be on each page. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting rows in a spread sheet.
The answer varies by version. A search for "rows to repeat at top" should
yield an answer. "Pete" wrote: How can I format the top row (or two) of an Excel spread sheet and make it appear on every page? I'm trying to create a list and I want the top cell in each column to be on each page. -- Pete |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting rows in a spread sheet.
On Feb 9, 7:15*pm, blake p wrote:
The answer varies by version. *A search for "rows to repeat at top" should yield an answer. "Pete" wrote: How can I format the top row (or two) of an Excel spread sheet and make it appear on every page? *I'm trying to create a list and I want the top cell in each column to be on each page. -- Pete I assume you are talking about printing the 1 or 2 rows on each sheet on a printed document. I always go to "Page Setup" and click on "Sheet" tab, In the window "Rows to repeat at top" you can select the rows or type in "a1:a2" to get the first two rows for example. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting rows in a spread sheet.
The "rows to repeat at top" search did the trick. Thanks Blake. FYI I'm
using MS Office 2007. -- Pete "blake p" wrote: The answer varies by version. A search for "rows to repeat at top" should yield an answer. "Pete" wrote: How can I format the top row (or two) of an Excel spread sheet and make it appear on every page? I'm trying to create a list and I want the top cell in each column to be on each page. -- Pete |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting rows in a spread sheet.
Fred,
I was talking about the first row being repeated on each printed page in addition to the Header. Blake's suggestion hooked me up. Thank you for your effort. -- Pete "Fred Smith" wrote: It's called a Header. Look under Page Setup. The specifics depend on which version of Excel you are using. Regards, Fred "Pete" wrote in message ... How can I format the top row (or two) of an Excel spread sheet and make it appear on every page? I'm trying to create a list and I want the top cell in each column to be on each page. -- Pete . |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting rows in a spread sheet.
To save everyone time, identify your version in your initial post. You get
better answers, and people don't waste their time trying to generalize the answer. Regards, Fred "Pete" wrote in message ... The "rows to repeat at top" search did the trick. Thanks Blake. FYI I'm using MS Office 2007. -- Pete "blake p" wrote: The answer varies by version. A search for "rows to repeat at top" should yield an answer. "Pete" wrote: How can I format the top row (or two) of an Excel spread sheet and make it appear on every page? I'm trying to create a list and I want the top cell in each column to be on each page. -- Pete |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting rows in a spread sheet.
You're right, they are two separate things. Glad you got it working.
Fred "Pete" wrote in message ... Fred, I was talking about the first row being repeated on each printed page in addition to the Header. Blake's suggestion hooked me up. Thank you for your effort. -- Pete "Fred Smith" wrote: It's called a Header. Look under Page Setup. The specifics depend on which version of Excel you are using. Regards, Fred "Pete" wrote in message ... How can I format the top row (or two) of an Excel spread sheet and make it appear on every page? I'm trying to create a list and I want the top cell in each column to be on each page. -- Pete . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding intermittent rows to a spread sheet | Excel Discussion (Misc queries) | |||
| Transfer CELL value and spread it among 24 ROWs on another sheet | Excel Worksheet Functions | |||
| Spread Sheet Print Formatting | Excel Discussion (Misc queries) | |||
| Printing a spread sheet and skipping rows. | Excel Discussion (Misc queries) | |||
| How do I get the top 4 rows of a spread sheet to print on each pa. | Excel Discussion (Misc queries) | |||
Linear Mode
