how to control the gray line on the border?

  • Thread starter Thread starter cpliu
  • Start date Start date
C

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
 
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
Click to expand...

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.
 
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.
Click to expand...

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,
 
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!
 
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!
Click to expand...

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