+ Reply to Thread
Results 1 to 2 of 2

Inserting and Deleting rows while maintaining formula consistency

  1. #1
    Registered User
    Join Date
    09-24-2012
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    15

    Inserting and Deleting rows while maintaining formula consistency

    Hopefully the thread title makes sense.

    The problem i'm having is that i'm having a bunch of stuff added together vertically and horizontally and when I insert new rows while the worksheet is unprotected everything is fine, but when i protect the worksheet and insert a new row no formulas doesn't get included.

    Also, when to worksheet is protected i'd like the user to be able to delete certain rows but the only way to do that currently is to un-protect the sheet. Is there a way around this too?

    Thanks for any help you can give.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Inserting and Deleting rows while maintaining formula consistency

    insert a new row no formulas doesn't get included
    Select the newly inserted Row and press Ctrl+D to apply above row formula, formatting & values.

    worksheet is protected i'd like the user to be able to delete certain rows
    While protecting the worksheet Give Rights to Delete Rows by Clicking Tick Mark in Delete Rows. But ensure the none of the cell in that row should be in Locked Mode.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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