+ Reply to Thread
Results 1 to 17 of 17

Locking cells in columns but allow copying and adding rows

Hybrid View

Skully Locking cells in columns but... 07-12-2012, 11:22 AM
Skully Re: Locking cells in columns... 07-13-2012, 02:06 AM
Fotis1991 Re: Locking cells in columns... 07-13-2012, 02:27 AM
Skully Re: Locking cells in columns... 07-13-2012, 02:47 AM
Fotis1991 Re: Locking cells in columns... 07-13-2012, 03:11 AM
Skully Re: Locking cells in columns... 07-13-2012, 03:49 AM
Fotis1991 Re: Locking cells in columns... 07-13-2012, 03:55 AM
Skully Re: Locking cells in columns... 07-13-2012, 04:11 AM
Fotis1991 Re: Locking cells in columns... 07-13-2012, 04:30 AM
Skully Re: Locking cells in columns... 07-13-2012, 05:02 AM
Fotis1991 Re: Locking cells in columns... 07-13-2012, 05:11 AM
Skully Re: Locking cells in columns... 07-13-2012, 06:14 AM
Fotis1991 Re: Locking cells in columns... 07-13-2012, 06:29 AM
Skully Re: Locking cells in columns... 07-13-2012, 06:46 AM
Fotis1991 Re: Locking cells in columns... 07-13-2012, 06:58 AM
peace4future Re: Locking cells in columns... 05-11-2017, 11:50 AM
ifernandezb Re: Locking cells in columns... 02-25-2020, 10:49 AM
  1. #1
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Locking cells in columns but allow copying and adding rows

    Didn't my photos helped you?

    ... gone to data on the ribbon, click on validation, dropped down to custom and then what to I do from there?
    Then you type or you copy your formula WITHOUT equal(=) sign.! I think this is the reason that does not works for you. See my photos again.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  2. #2
    Registered User
    Join Date
    06-07-2011
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Locking cells in columns but allow copying and adding rows

    Ah, I did not notice this. I have change this but this still does not lock the cells. So do I then go protect the sheet from there?

+ 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