How to create a command cell for specific cells in a column

Angela Mesenberg 0 Reputation points
2026-11-19T15:14:21.6033333+00:00

Is it possible to create a command cell where i can change the values for only some specific cells in a column?

Microsoft 365 and Office | Excel | For business | Windows

2 answers

Sort by: Newest
  1. Ruby Nguyen 3,920 Reputation points Independent Advisor
    2026-11-19T17:04:06.2+00:00

    Good day Angela, 

    Certainly, you can do this. The best option depends on how you want the cells to behave. 

    Option 1: Link specific cells to one control cell 

    Use this option if certain cells should always show the same value as a control cell. 

    • For example, use B1 as the control cell and D3, D7 and D12 as the target cells. 
    • Select D3 and enter:=B1  
    • Press Enter. 
    • Repeat the same formula in D7 and D12. 
    • When you change the value in B1, only those cells update automatically. 

    If you plan to copy the formula, use: 

    • =$B$1 to keep the reference fixed. 

    Option 2: Create a drop down list in the control cell 

    Use this option if you want the control cell to offer preset choices such as Yes, No, Pending, or Completed. 

    • Enter the list values in an unused range, for example H1:H4. 
    • Select the control cell, such as B1. 
    • Go to Data > Data Validation. 
    • Choose List under Allow. 
    • Select H1:H4 as the source and select OK. 
    • Enter =B1 in each target cell that should follow the control cell. 
    • When you select a different value in B1, only the linked cells update. 

    Option 3: Update several nonadjacent cells at the same time 

    Use this option if you want to enter the same value once without using formulas. 

    • Hold Ctrl and select each target cell. 
    • Type the value. 
    • Press Ctrl+Enter. 

    Excel enters the value into all selected cells at once. The cells are updated only once and don't remain linked afterward. 

    Option 4: Allow changes only through the control cell 

    Use this option if you want users to edit only the control cell and prevent accidental changes elsewhere. 

    • Select the control cell. 
    • Press Ctrl+1 and open the Protection tab. 
    • Clear Locked and select OK. 
    • Go to Review > Protect Sheet. 
    • Choose the actions users can perform and set a password if needed. 
    • Select OK. 

    Users can then edit the control cell while the linked formula cells remain protected. 

    Note: Worksheet protection helps prevent accidental edits, but it isn't designed as a security feature for sensitive data. 

    If you have any questions, please don’t hesitate to reach out at any time. 

    Thank you for your patience and understanding. 

    Was this answer helpful?

    0 comments No comments

  2. Angela Mesenberg 0 Reputation points
    2026-11-19T15:41:44.02+00:00

    This code did not work

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.