Borders - How to make permanent?

A

AC

Is there a way to make the Border (lines) more
permanent? I have some borders to separate section of
the spread sheet but sometimes I want to drag formulas
across sections. Once I do that the border in that
column disappear (over written). Is there a way to keep
borders in place until I really want them removed?
Thanks
AC
 
J

JE McGimpsey

With XL04 (and IIRC, XL03), the smart button that pops up after a drag
and drop allows you to fill without formatting. Alternatively,
right-clicking while dragging will give that option.
 

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

How to make scroll bar permanently visible, Word 365 0
make text fit within curvy border (that's in the header) 0
Infopath Rule/Code to Color for Section/Table/Cell Border? 0
Working on birthday "book" for my wife and having layout/editing trouble 0
Existing sheet formatting removed when changing active cell border color 3
Conditional borders 3
Making An Outside Border Different From Interior Borders In A Table ? 4
How to inert content from two DWT sources on one HTML page? 1

Top