Any Solution for Overlapping Checkbox on filtered Data

andyka

Board Regular
Joined
Sep 20, 2021
Messages
52
Office Version
  1. 2019
Platform
  1. Windows
Hi
I have asked number of experts on youtube but none of them replied I assumed they have no answer.
When I apply filter to any column the Column that contains checkbox overlaps.
Checkbox are in C
Any solution to this issue

Checklist-in-Excel.xlsx
ABCDEFGHIJ
1
2To Do ListStatusCell Linked
3Define your project goalsDoneTRUE
4Identify all stakeholdersTo Be DoneFALSETask Completed4
5Determine your final deadlineDoneTRUE% of Tasks Completed66.7%
6List each step or taskDoneTRUE
7Assign a team memberTo Be DoneFALSE
8Work backward to set due datesDoneTRUE
9
10
Checklist
Cell Formulas
RangeFormula
I4I4=COUNTIF($F$3:$F$8,TRUE)
I5I5=COUNTIF($F$3:$F$8,TRUE)/COUNTIF($F$3:$F$8,"<>")
D3:D8D3=IF(F3,"Done","To Be Done")
Cells with Conditional Formatting
CellConditionCell FormatStop If True
D3:D8Expression=$D3="Done"textNO
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Try:

Select all checks press right button, select Size and Properties, select Move and size with cells

1666024018000.png
 
Upvote 0
Hi DanteAmor.
Unfortunately, It does not work. When I apply filter all the checkbox overlaps
1666024835821.png

Please help!
Thank you in advance
 
Upvote 0
They are not overlapping, you must center each check box in the center of the cell

1666026817401.png



Look at the result:
1666026915519.png
 

Attachments

  • 1666026930921.png
    1666026930921.png
    11.4 KB · Views: 30
Upvote 0
Solution

Forum statistics

Threads
1,224,815
Messages
6,181,136
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top