question

timisleib-7154 avatar image
0 Votes"
timisleib-7154 asked Lz-3068 commented

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

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 ??

office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Same thread title, same question here (& very similar pseudo)


0 Votes 0 ·

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @timisleib-7154,
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.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.