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.
|