How do I prevent an autofill column returning a zero

D

David Moss

I am a bit of a beginner & this might seem obvious, but when I create an
autofill column, it seems to return a zero by default, so that any chart I
then create has a vertical drop to zero and makes the scale look ridiculous.
Any help would be appreciated
 
J

Jen Hearns

It might help to post the formula in the cell. I had the same problem
i think you had. In my Page1, you would put an "x" to transfer over
to my Page2, and so it would not have a "0" on Page2, it put in the
following:

=IF(page1!O24="X","X","")

The "" will return an empty cell.

Hope this helps,
Jennifer
 

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

VBA to autofill from relative location 2
Column Of Numbers To A Text Format Problem 1
New computer, how do i move outlook 365 ENTIRELY? 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Keeping Leading Zeros; How Please ? 2
Single column to multiple columns 5
Autofill macro - variable destination cells 7
Using IF and VLOOKUP for range of cells 5

Top