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

16y ago

What else can I help you with?

Trending Questions
Where is the best place to buy the new iPad? How can transfer music from bitlord to your media player? How much do wooden desks cost? There are many types of memory chips that can be installed on a computer Which type should be installed in pairs to ensure functionality? Where can one find a general software help desk? How much space on a 640 GB hard drive? What is a user account on a laptop? What is Carly Fiorina fame in the computing industry? 20 ml equals how many teaspoons? How can a laptop notebook PC contain all the same elements as a desktop PC? .2quarts equals how many ml? Which ups should you get for a 550w power supply - 600va or 800va? How do you install Fedora 9 i386 or any Fedora or operating system on your ibook PS my ibook is whipped? When incident command has been transferred the process must include a briefing of essential information for continuing effective operations. Which element should be the first one addressed during tran? How do you measure volume without a graduated cylinder? What is the dollar sign called when put in between cell numbers in a spreadsheet? Does A hard disk provides much less storage capacity than a floppy disk or zip disk? Does word insert a page break automatically when the bottom margin is reached and starts a new page? Is this statement true or false Word's find and replace feature will locate each occurrence of a specified word or phrase and then replace it with specified text? What is the main physical reason for the failure of many mac schemes known from wred networks?