Results 1 to 5 of 5

F4 function that locks the cells issue

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    derby england
    MS-Off Ver
    2007
    Posts
    33

    F4 function that locks the cells issue

    Hello
    I require a bit of help with the F4 function that locks the cells.
    As on the example spread sheet

    I have filled in the data on G11 with the cell E11 locked value.

    When I copy the cell G11 across along row 11, the cells populate fine with the function and all is well

    Now with G12 (all the way to G400) , is there a easier way of getting the cells locked (like =F12-$E$12 and =F13-$E$13) as i am having to lock the value manually

    Thank you
    Veer
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pasting into unlocked cells locks the cells
    By excel2007use in forum Excel General
    Replies: 0
    Last Post: 03-18-2015, 02:08 PM
  2. cut and paste locks cells
    By lima in forum Excel General
    Replies: 0
    Last Post: 03-01-2011, 05:48 PM
  3. [SOLVED] Programmatically pasting a Function locks macro
    By diglas1 via OfficeKB.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2006, 08:10 PM
  4. [SOLVED] Pasting from Word locks cells
    By Andy in forum Excel General
    Replies: 1
    Last Post: 10-29-2005, 01:08 AM
  5. Check Box that Locks all cells on it's column
    By JasonMiller in forum Excel General
    Replies: 1
    Last Post: 07-01-2005, 02:05 PM

Tags for this Thread

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