Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Conditionally Select Formulas (Excel 2002)

    I've been given a large spreadsheet to enter data into and want to avoid entering data into the cells with formulas in them.

    Is there a way to select a range and then conditionally select formulas within that range so I can protect them from myself?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditionally Select Formulas (Excel 2002)

    I have a similar spreadsheet and I locked the columns that contain formulas( the ones you don't want to change) and then protect the sheet. In the Protect Sheet menu, uncheck the Select locked cells

    Hope this helps
    Jackal

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Conditionally Select Formulas (Excel 2002)

    Unfortunately, the spreadsheet was not designed in a way that would allow that method. In this worksheet, each column represents a month, so that formulas for totals, sub-totals and variables are interspersed throughout the 2,439 rows.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditionally Select Formulas (Excel 2002)

    You should still be able to protect the cells that contain formulas. Try this:

    1- Select all of the cells on the sheet.

    2- Select Cells from the Format menu. Click on the Protection tab and remove the check from next to "Locked". Click OK.

    3- Click on GoTo on the Edit menu. Then click on the "Special" button in the GoTo dialog box.

    4- In the Special dialog box, click on the Formulas radio button. Then click on the OK button. All cells with formulas should now be selected.

    5- Again, click on Cells in the Format menu, then click on the Protection tab. Put a check mark next to "Locked". Click the OK button.

    6- In the Tools menu click on "Protection", then on the "Protect Sheet" in the fly out menu. Then click the OK button.

    You should now be able to enter data anywhere except cells that contain formula.
    Legare Coleman

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Conditionally Select Formulas (Excel 2002)

    Perfect! Thank you. I have not used that GoTo feature before today.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    339
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditionally Select Formulas (Excel 2002)

    This is such a handy tip it should be in the Star Posts --- thank you

Posting Permissions

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