| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 35729 | 2003-07-20 04:16:00 | microsoft excel | yingxuan (3330) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 161410 | 2003-07-20 04:16:00 | Im using microsoft excel. And I need to type out all the streets .and the length for it As u can see in microsoft excel The number goes down like this 1 2 3 4 5 6 etc What i want is for excel is to be able to seperate the numbers into two coloumns like this 1 7 2 8 3 9 4 10 5 11 6 12 So that it doesn't waste any paper.just by printing one row on the left hand side and nothing on the right hand side is a waste. How can i set it up ? |
yingxuan (3330) | ||
| 161411 | 2003-07-20 04:17:00 | Also in excel.The number which identifies the cell.Can it be printed it out also with the data i put in or do i have to type the numbers in manually? | yingxuan (3330) | ||
| 161412 | 2003-07-20 05:43:00 | To do what you want, ignore the row numbers in Excel and type your own in. If you type in the first 2 (1, 2, ) then highlight them and drag them down they will "autofill" and keep going in the correct sequence. |
godfather (25) | ||
| 161413 | 2003-07-23 09:06:00 | From the menu select File, Page Setup - select the Sheets tab and under the Print section on the right hand side tag the "Row and Column headings" box. the only downside for you may that this option prinnts the column Number (in R1C1 format) or the letter as well as the Row Number. |
TeejayR (4271) | ||
| 1 | |||||