I need some information regarding excel

Question

I am doing a business spreadsheet for my daughters dress shotp. When the item has been collected I have a tick box colum. However I need to see all the info on the spreadsheet without the boxes that have been ticked. Is there an easy way of doing this. Please understand that I have not used spreadsheets for over 20 years and very new to all the new adapations on the systems.

Many thanks in advance for any help.

Jackie

Answer 1

Current versions of Excel provide for inserting active check boxes in cells. The feature is describede here: Using check boxes in Excel - Microsoft Support

If you used that feature the boxes equate to True/False. The data can be filtered on that basis:

Answer 2

Hi,

Thank you for sharing your question. I understand how confusing Excel can feel, especially when you haven’t used it in many years and just want a simple way to hide items that have already been collected.

Microsoft’s guidance shows that the easiest way to hide rows you no longer want to see is to avoid using checkbox controls and instead use a simple tick symbol in a cell that can be filtered with AutoFilter. This avoids the problems that real checkbox objects can cause when hiding rows.

If you replace your checkbox with a tick symbol (like ✓) or even a simple “Yes,” you can turn on Filter at the top of Excel and filter the column to show only rows that are not ticked. Excel’s AutoFilter lets you show only blank or unticked rows, which is exactly what you want. [learn.microsoft.com] [learn.microsoft.com], [learn.microsoft.com]

Are your current tick boxes actual checkboxes you click, or are they just marks typed into the cell?

Feel free to tell me which type you’re using and I’ll guide you step‑by‑step so you can easily hide the collected items and keep your spreadsheet clean and simple.

 

I hope this helps

 

Best Regards,

Noel

 

 

 

Answer 3

Hi,

Thank you for sharing your question. I understand how confusing Excel can feel, especially when you haven’t used it in many years and just want a simple way to hide items that have already been collected.

Microsoft’s guidance shows that the easiest way to hide rows you no longer want to see is to avoid using checkbox controls and instead use a simple tick symbol in a cell that can be filtered with AutoFilter. This avoids the problems that real checkbox objects can cause when hiding rows.

If you replace your checkbox with a tick symbol (like ✓) or even a simple “Yes,” you can turn on Filter at the top of Excel and filter the column to show only rows that are not ticked. Excel’s AutoFilter lets you show only blank or unticked rows, which is exactly what you want. [learn.microsoft.com] [learn.microsoft.com], [learn.microsoft.com]

Are your current tick boxes actual checkboxes you click, or are they just marks typed into the cell?

Feel free to tell me which type you’re using and I’ll guide you step‑by‑step so you can easily hide the collected items and keep your spreadsheet clean and simple.

 

I hope this helps

 

Best Regards,

Noel