Share via

In Excel, can you hide a range of cells with a checkbox?

tim isleib 1 Reputation point
2021-05-25T18:12:54.943+00:00

I made a Excel worksheet for "Paint to additive" ratio for different materials, glass, metal, ect.
I want to use a checkbox to hide a range of cells with calculations/results for materials not used.
Range- E24 to J28 ??

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,939 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,041 Reputation points Microsoft External Staff
    2021-05-26T06:37:25.887+00:00

    Hi @tim isleib ,
    In my opinion you're looking for SLICER feature in Excel:

    https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If my understanding is incorrect, please provide more information about your problem and I'm glad to help you.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.