dshi15
asked on
lost border line in Excel Sheet
Hi Expert,
I worked on excel sheet, but some record lost border line, how I can add them back?
Thanks,
I worked on excel sheet, but some record lost border line, how I can add them back?
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I select a row, then right- click on 'Format Cells' then Borders icon, I select a solid line and outside border, but after I click Ok, they add a dark line boder to my row, I like the color and everything as default style when I open new excel sheet.
How I can do that?
How I can do that?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did what you mentioned, but I don't like anything they provide, I like original (like default one) one when open new excel sheet.
When we open new excel sheet, it have record border line, somehow, I have several records the line lost I even don't know how and when it lost. I just like to restore them back.
When we open new excel sheet, it have record border line, somehow, I have several records the line lost I even don't know how and when it lost. I just like to restore them back.
You could copy a row with the correct borders, then select the row with the missing border and use Paste Special > Formats. That will only change the look of the cells, including borders, not the cell contents or formulas.
cheers, teylyn
cheers, teylyn
depending on what you do in an Excel sheet, cell borders may not be kept. In order to re-instate the cell borders, select the cells, then click on the Borders icon in the ribbon and select the setting you want to apply.
If this does not do what you want to achieve, please post more details about your situation.
cheers, teylyn