find/replace cell borders

S

Steve

Is it possible to change in an entire sheet at one time any double line
border (right, left, top, or bottom) with a single line border?
 
F

FSt1

hi
call the find dialog(ctrl+F)
click the replace tab
click the options button
on the find what line, click the format button and set the format you wish
to find
on the replace line, click the format button and set the format you wish to
replace.
click replace all

Regards
FSt1
 
S

Steve

That works if you're very specific on what you're finding/replacing. In my
case I have double line borders on the right and single lines on the other
sides; double borders on the top and no other borders; and so on. Isn't
there an easier way to just replace any double line border with a single
line? Other than having to do find/replace with every possible combination?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top