eemoon
asked on
Can we delete labeled or unlabeled digit in Excel?
Hi The below is a group of data. Can we delete labeled or unlabeled digit in Excel with a simpler way? Thank you
18 34
21 35
23 36
25 36
25 40
27 43
29 45
18 34
21 35
23 36
25 36
25 40
27 43
29 45
what are you trying to achieve ? what do you mean with labeled or unlabeled digit?
Please explain what you mean by "labeled or unlabeled".
ASKER
Sorry it is not clear.
The labeled or unlabeled is highlighted one with Bold or other colors
In this case, they are 35, 25, and 43
The labeled or unlabeled is highlighted one with Bold or other colors
In this case, they are 35, 25, and 43
When you delete them what should happen to the cell? Should it be blank or should the other data in the column move up?
ASKER
it does not matter because I can put them together by sorting. It could be blank
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.