Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 121
  • Last Modified:

Borders in body of spreadsheet overwriting double external borders - way to fix?

hi
I've got a customer with the following scenario..they have a spreadsheet with single lines on internal borders, and double lines on external borders.
They add new data and copy down the border information - the new single line border overwrites the external double line border and he has to use Format Painter to recreate the double external line..any suggestions?
0
agwalsh
Asked:
agwalsh
  • 2
1 Solution
 
ProfessorJimJamCommented:
can u upload a sample?
0
 
agwalshAuthor Commented:
here it is..in the original it's fine. Then i copy down the data and the bottom border disappears.
borders-overwritten.xlsm
0
 
Rob HensonIT & Database AssistantCommented:
Insert a blank row at the bottom of the table and set the height to only a few pts. When new rows are inserted, ensure this row is selected before inserting. When the rows above are then copied/dragged down into the new rows make sure they don't go into the last row, the double border at the bottom will then stay.

Thanks
Rob H
0
 
agwalshAuthor Commented:
Did the job :-)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now