how to control the gray line on the border?

[cpliu]

I copied and pasted data from web and the gray lines disappears at the
cells I pasted on. The gray lines like the borders but can't be
controlled by applying the styles in "Borders". How can I make them
reappear?

Also, how can I apply borders setting on multiple cells. If I
highlight multiple cells and apply a bottom line, all it does is apply
it at teh last row instead of all the rows highlighted.

Thanks for the help,

liu

 

[Steve Latronica Jr.]

I copied and pasted data from web and the gray lines disappears at the
cells I pasted on. The gray lines like the borders but can't be
controlled by applying the styles in "Borders". How can I make them
reappear?

Also, how can I apply borders setting on multiple cells. If I
highlight multiple cells and apply a bottom line, all it does is apply
it at teh last row instead of all the rows highlighted.

Thanks for the help,

liu

Set the formatting you would like to see on all of the cells on one
cell, then highlight that single cell and select the format painter.
Now use the format painter and cover the rest of the data, and your
formatting will match the way you please.

 

[cpliu]

Set the formatting you would like to see on all of the cells on one

cell, then highlight that single cell and select the format painter.
Now use the format painter and cover the rest of the data, and your
formatting will match the way you please.

Thanks for the nice tip. The only problem is my cells have different
formats such as numbers, dates. When applying from one style, it
changes the styles of other cells with different styles.

Any other ways?

Thanks,

 

[cpliu]

I think I found it. It's the pattern. Once I select all and select "no
color" for the pattern > cell shading, it goes back to the old gray.
If I choose white for pattern, it becomes white with no gray thin
lines between cells. Also to make border changes to multiple cells,
select the cells and change the borders from Cell formats and it will
apply the same setting to all folders.

Thanks!

 

[Steve Latronica Jr.]

I think I found it. It's the pattern. Once I select all and select "no
color" for the pattern > cell shading, it goes back to the old gray.
If I choose white for pattern, it becomes white with no gray thin
lines between cells. Also to make border changes to multiple cells,
select the cells and change the borders from Cell formats and it will
apply the same setting to all folders.

Thanks!

Sorry it looks like I misunderstood what you had asked..hopefully it
was a good tip anyways!

 

[cpliu]

Sorry it looks like I misunderstood what you had asked..hopefully it

was a good tip anyways!

That is a nice tip. THANKS!