Excel Guides

Selecting Combo Boxes in Locked Worksheets in Excel

When you have a locked worksheet in Excel, you can still select combo boxes by following these steps:

  1. Click on the combo box to select it.
  2. Press and hold the Shift key on your keyboard.
  3. While holding down the Shift key, click on the worksheet tab at the bottom of the Excel window.
  4. Release the Shift key.
  5. Click on the combo box again to select it.

Note:

  • "Locked" refers to cells that have been locked for editing. To lock cells in a worksheet, select the cells that you want to lock, then click Lock cells. To unlock cells, select the cells that you want to unlock, then click Unlock cells. For more information about protecting worksheets and locking cells, see Protecting worksheets and workbooks.
More information:
  • How to quickly select all combo boxes in active sheet? | ExtendOffice

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.