Prevent formats from copying

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

Guest

Hello. This is probably a really elementary question, but I just cannot work
it out.
When filling in cells by dragging (in any direction), I want the data to
appear but not the fill colours, etc.
I've hunted high and low and cannot fathom how to prevent this from
happening.
This happens in every file, so I'm guessing it's a general option.

Help, anyone?
:)
 
If you rightclick and drag that autofill button, you'll see some options when
you let go.

There's an option (at least in xl2003) that shows "fill without formatting".
 
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

Question about conditional formatting of zeros in Excel 0
Conditional formatting / blank cells 5
Displaying zeros in cells 2
Formatting Pivot Tables 3
Stop Overwriting (Fill, Copy, etc) Data Validation 3
Conditional formatting: Colour coding 4
Excel Excel 2013 conditional formatting 1
How to prevent users from changing cell format 1

Back
Top