Register now or log in to join your professional community.
A) You can search for bold and replace with italics
B) You can decide whether to look for the whole word or not
C) You can search in formula too
D) You can search by rows or columns or sheets
A) You can search for bold and replace with italics
A.) You can search for Bold and replace with Italics.
A cell that contains mixed formatted text cannot be used with the Find & Replace command.
Find and Replace only works with cells that contains single formatted text.
D is the only answer here. all other options can be performed in excel file.
Definite option is letter D.) You can search by rows or columns or sheets.
B & D - TRUE
A & C - NOT TRUE/ FALSE
D) You can search by rows or columns or sheets
