answersLogoWhite

0

(Indonesian translated to English): How to lock a column in Excel 2007.

STEP 1: Format the cells in the column to be protected.

  1. Highlight the column.
  2. Select Format Cells (on the Home ribbon, in the Cells section).
  3. Click on the Protection tab in the Format Cells window.
  4. Check the Locked box.
  5. Click OK.

STEP 2: Turn on worksheet protection.

  1. Click the Review tab on the menu ribbon.
  2. Click protect worksheet.
  3. Add password or configure as you like.
  4. Click OK.
  5. To turn off protection, repeat the process.
User Avatar

Wiki User

15y ago

What else can I help you with?