How do I make row "A" the same on each sheet

J

John Bordieri

Hi,

I have an inventory worksheet that I want row "A" to appear on each
individual printed page. An example is shown below of what row "A" looks
like. (This will be the first row on each page) I did it once a long time
ago, but I can't seem to rember how to do it.


DESCRIPTION CATEGORY UOM COST PER UOM CASE $/PER CS
VENDOR COUNT VALUE


Your help is greatly appreciated!

Thank you,
John Bordieri
 
P

prabhuraaman

Go to FILE-PAGESETUP-SHEET
Clik the rows you want to repeat at the top of each page in
ROWS TO REPEAT AT TOP option
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to add Multiple rows in same sheet 1
Keeping column titles for each printed page 2
Extracting data from Multiple columns to a Single row 1
How do I move entire row from one excel sheet to another 3
Automatically Combining Entries with Same Date 1
How do I specify row 1 as header row that is to be printed on every page, regardless of other page s 3
how do i overcome the xl2003 limit of 65,536 rows? 3
How to Output Data from Variable Ranges in Multiple Sheets into 1Report; Yikes 3

Top