Results 1 to 3 of 3

Thread: excel

  1. #1
    rex hooker

    Default excel

    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

  2. #2
    Heather P

    Default Re: excel

    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.

  3. #3

    Default Re: excel

    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

Similar Threads

  1. Replies: 1
    Last Post: 28-09-2008, 11:35 PM
  2. Excel
    By Tammy in forum PressF1
    Replies: 10
    Last Post: 23-12-2003, 04:52 PM
  3. Excel 97 to Excel 2000 Files
    By Scott Vail in forum PressF1
    Replies: 1
    Last Post: 03-07-2003, 03:26 PM
  4. MS Excel
    By Chris Knaggs in forum PressF1
    Replies: 2
    Last Post: 14-03-2003, 09:13 PM
  5. Excel 2000 & Excel 97 toolbars
    By in forum PressF1
    Replies: 0
    Last Post: 11-06-1999, 08:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts