How do I keep border permenant in a worksheet template?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using an accounting form for a worksheet to enter monthly figures and I
have problems keeping the cell formats permenant. Whenever I copy and paste,
I inadvertently overwrite the current cells borders and need to re-enter the
previous fromatting. Is there a way anyone knows to keep the formats besides
using the clumsy Paste Special-Cell Contents option?
 
If you are using Excel 2003, the Paste icon on the toolbar has a drop-down
arrow on the right side. The drop down has choices like Values, Formulas
and No Borders.

Tim C
 
Thank you so much!!!!

Tim C said:
If you are using Excel 2003, the Paste icon on the toolbar has a drop-down
arrow on the right side. The drop down has choices like Values, Formulas
and No Borders.

Tim C
Click to expand...
 
And later on when that Option button become too annoying, you can go in and
disable it in Tools>Options>Edit


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut & Paste in Excel without erasing cell borders? 1
How can I test a range of cells for the presence of a border? 7
how do i get borders around selected cells in a worksheet? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I stop cell borders dissappearing when pasting data? 2
How can I stop format change when copying data into unlocked cells 1
how to link format of cells 1
How do I set a formula, that add next cell reference in a Formula 2

Back
Top