How to print line/row numbers as well ?
I want to print an Excel sheet where the line numbers (only them ! NOT the row chars !)
as well. How can I display the row/line numbers on the paper as well? Jeff |
How to print line/row numbers as well ?
Hi,
I don't believe you can do that, the only options are to print row numbers and column headers in page setup or cheat by creating your own row numbers in Column A. Mike "Jeff Korn" wrote: I want to print an Excel sheet where the line numbers (only them ! NOT the row chars !) as well. How can I display the row/line numbers on the paper as well? Jeff |
How to print line/row numbers as well ?
Go to FilePage Setup, click Sheet tab, select "Row and column
headings" Is that what you needed? --JP On Feb 26, 2:12*pm, (Jeff Korn) wrote: I want to print an Excel sheet where the line numbers (only them ! NOT the row chars !) as well. How can I display the row/line numbers on the paper as well? Jeff |
How to print line/row numbers as well ?
You say you want to print line numbers but not row characters.
Lines and rows are same thing. Do you want to print row numbers but not column letters? Cannot be doneby setup...........you must have both or neither. Workaround is to diasble row and column headers under Page Setup but in column A have the numbers 1 through whatever just for printing. Gord Dibben MS Excel MVP On 26 Feb 2008 19:12:54 GMT, (Jeff Korn) wrote: I want to print an Excel sheet where the line numbers (only them ! NOT the row chars !) as well. How can I display the row/line numbers on the paper as well? Jeff |
How to print line/row numbers as well ?
Jeff Korn wrote:
I want to print an Excel sheet where the line numbers (only them ! NOT the row chars !) as well. How can I display the row/line numbers on the paper as well? Jeff You can print both row and column headings using the Page layout dialog box. If you just want to include the line numbers, add an extra column before column A and insert numbers to match the row number. Be sure to uncheck the "print row and column headings" on the Page layout dialog box. Bill |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com