| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to I set up a sheet to print colums/rows on every page in exce
I have a spreadsheet in excel and want several rows and columns to print on
every page. It will display by freezing panes but I need it to print that way also. |
|
#2
|
|||
|
|||
|
see http://www.mvps.org/dmcritchie/excel/freeze.htm
file, page setup, sheets, Rows to Print at top: $1:$2 columns to print at left: $A:$A --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Michelle" wrote in message ... I have a spreadsheet in excel and want several rows and columns to print on every page. It will display by freezing panes but I need it to print that way also. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Objects On Sheet Shift after Print | Excel Discussion (Misc queries) | |||
| I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions | |||
| Setting up a macro to print? | Excel Worksheet Functions | |||
| I want print excel sheet with nos in the back ground, as shown in. | Excel Discussion (Misc queries) | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Linear Mode
