| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print row one on each printed page
from Page set up/sheet/rows to repeat at top.....I've tried entering 1 on
the line to repeat rows but I get a message, "Reference not valid", I've missed something important but...what? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to print row one on each printed page
It's looking for a range address.
Type 1:1 or click in that box (delete the existing entry) and then click on row 1. (That'll let excel do the heavy lifting.) Pleiades wrote: from Page set up/sheet/rows to repeat at top.....I've tried entering 1 on the line to repeat rows but I get a message, "Reference not valid", I've missed something important but...what? Thank you -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print same header at top of each printed page | Excel Discussion (Misc queries) | |||
| How do I fix diff from print preview and the actual printed page | Excel Discussion (Misc queries) | |||
| Print sequential page numbers on one worksheet printed multiple ti | Excel Worksheet Functions | |||
| My print preview is only showing one page to be printed | Excel Worksheet Functions | |||
| Set up a single page to print a chronolgy of sheets printed | Excel Discussion (Misc queries) | |||
Linear Mode
