• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 123
  • Last Modified:

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

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?
  • 2
1 Solution
can u upload a sample?
agwalshAuthor Commented:
here it is..in the original it's fine. Then i copy down the data and the bottom border disappears.
Rob HensonFinance AnalystCommented:
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.

Rob H
agwalshAuthor Commented:
Did the job :-)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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