+ Reply to Thread
Results 1 to 2 of 2

How to add rows to sheet with protected cells

  1. #1
    Registered User
    Join Date
    07-08-2019
    Location
    London
    MS-Off Ver
    O365
    Posts
    1

    How to add rows to sheet with protected cells

    I have a sheet with 10 columns.
    Columns 7 & 10 contain formulas which I would like to protect.
    At the bottom of the sheet in column 10 I have an autosum function.
    The number of rows can vary but I need to be able to add or delete rows above the cell containing the autosum.
    Can this be done simply? If so how?

    Thanks in advance

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: How to add rows to sheet with protected cells

    In Protect Sheet menu, you'll have option to allow insert rows. While maintaining worksheet structure.

    However, I'd recommend turning data range into Excel Table first.
    As long as the formula syntax is consistent (excluding cell reference), it will replicate formula in newly added row.

    As well, instead of Autosum, take advantage of table's Total row to sum values.
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to delete rows in sheet with protected cells
    By Timmy2tone in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2014, 03:41 PM
  2. Inserting copied rows (some locked cells, some not) in a protected sheet
    By kmartinez0180 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2014, 08:09 PM
  3. Copy and paste insert rows with protected cells in protected worksheet
    By excel_gecko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 05:50 PM
  4. [SOLVED] Code to cut and paste rows (insert cut cells) in a protected Excel sheet
    By bob.mc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 04:47 PM
  5. Delete rows in a protected sheet with protected cells
    By Maranwe in forum Excel General
    Replies: 7
    Last Post: 10-31-2011, 08:12 AM
  6. Protected sheet - add rows & fix Summary
    By deejayh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2006, 10:04 AM
  7. Cannot Outline Rows in protected sheet
    By helmekki in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2005, 08:50 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1