Locking a cell to delete value not formula
Results 1 to 2 of 2

Thread: Locking a cell to delete value not formula

  1. #1
    Board Regular
    Join Date
    Nov 2010
    Posts
    2,327
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Locking a cell to delete value not formula

    Hi,
    if you lock a cell which has a formula in it of which then returns a value in the same cell does the formula get deleted when you delete the cells value.
    I have learning difficulties so please be patient if i'm slow on the uptake,Thanks Very Much...

  2. #2
    Board Regular
    Join Date
    Sep 2016
    Posts
    2,513
    Post Thanks / Like
    Mentioned
    34 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Locking a cell to delete value not formula

    A cell can contain either a constant or a formula.
    If you delete the contents of a cell, whatever the cell contains is deleted.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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