+ Reply to Thread
Results 1 to 2 of 2

How can I protect certain columns on a sheet so that formulas are.

  1. #1
    Tan
    Guest

    How can I protect certain columns on a sheet so that formulas are.

    How do I go about protecting certain columns on an excel sheet so that
    formulas are not changed by someone else entering data onto the worksheet

  2. #2
    jiwolf
    Guest

    Re: How can I protect certain columns on a sheet so that formulas are.

    Right click on the cells you want to allow data entry in. Then select
    "format cells", Then "protection". uncheck the "locked" box. Then protect
    the worksheet.

    "Tan" <Tan@discussions.microsoft.com> wrote in message
    news:B7E54609-EA18-4882-8106-7B954F0C3F8B@microsoft.com...
    > How do I go about protecting certain columns on an excel sheet so that
    > formulas are not changed by someone else entering data onto the worksheet




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1