| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 30661 | 2003-02-27 03:59:00 | excel | rex hooker (3254) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 124286 | 2003-02-27 03:59:00 | how can I make the first 50 pages in an excel spreadsheet have only 10 lines per page or the hole sheet have only 10 lines | rex hooker (3254) | ||
| 124287 | 2003-02-27 04:15:00 | What exactly are you trying to do? If you want to insert a page break after 10 lines click on the row name "11" (highlights row) and on the menu click Insert; Page Break. If you are trying to set up some sort of record set (like a cardfile) Access might be more suited to it. |
Heather P (163) | ||
| 124288 | 2003-02-27 04:20:00 | Option A Split the screen after the 10th row Unprotect the required cells Lock all the cells below the 10th row Apply password protection to the sheet - and to the workbook if required. Option B use a database |
Merlin (503) | ||
| 1 | |||||