Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2007
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spreadsheet format Question (2007)

    Is there a way to lock specific columns from being edited in a spreadsheet, but allow users to add rows?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spreadsheet format Question (2007)

    Yes, you can lock/unlock cells (or rows or columns), and when you protect the worksheet, you can specify what is allowed. Inserting rows is among the features that you can allow.

    See Protect worksheet or workbook elements or Excel 2007: Protecting Your Files and Worksheets for a detailed description.

  3. #3
    Star Lounger
    Join Date
    Jul 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Spreadsheet format Question (2007)

    I have found that in Excel 2003 when a worksheet is locked with permission to add rows
    that the Insert Rows toolbar icon is grayed out, but that inserting can be done through the Insert|Rows menu commands with no difficulty. This may or may not be true in Excel 2007, but might be useful to know.

    axsc

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spreadsheet format Question (2007)

    You're correct about Excel 2003. Other methods that work in a protected sheet (if adding rows is allowed):
    - Right-click a row header and select Insert from the popup menu.
    - Select a series of rows by dragging across their row headers, then right-click anywhere in the selection and select Insert from the popup menu.
    - Select one or more rows then press Ctrl+Shift+=

Posting Permissions

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