+ Reply to Thread
Results 1 to 2 of 2

Stop cell/formula editing in multiple sheet

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    1

    Stop cell/formula editing in multiple sheet

    New here so please bare with me....

    I have a document (excel 2010) with multpile sheets. I need to do some cut and pasting in the first sheet but when I do the cells/formulas in the second sheet change which I don't want. Is there anyway to prevent this?

    Thanks!

  2. #2
    Registered User
    Join Date
    11-05-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: Stop cell/formula editing in multiple sheet

    Well if the data in the second sheet is dependent on data in the first sheet, then by cut/paste you remove the relevant reference cells.. Drag the relevant cells instead, and you will preserve the references.

+ 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