Formats change when using Auto Fill

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

When I try to use auto fill from an existing row that has
various cell formats, it does not complete the fill with
the existing formats. So the outcome is different than
what I started with. Like I have 4 columns, one is a
number format, one is date, one is currency etc. When I go
to pull info with the black plus sign it does not copy the
exisiting formats and the numbers are completely different
than what I want them to be or what they are in above
rows. I hope this makes sense. Any ideas how to force the
formats to stay and not change?

Lisa
 
Only suggestion I have is to do a copy / paste special
values - 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

Auto fill not working 2
Series fill only copying and fill series greyed out 1
Conditional Formatting 3
Excel Conditional Formatting 1
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formatting from a group 6
Autofill questions 2
Auto Fill Down Macro 5

Back
Top