A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
This code did not work
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Is it possible to create a command cell where i can change the values for only some specific cells in a column?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
This code did not work
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.
If you plan to copy the formula, use:
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.
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.
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.
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.