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,610 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 20,106 Reputation points Microsoft Vendor
    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 No comments