Dragging Text or Date Fields to Copy

B

billbrandi

When I have a date field, or a text field with numerals included, and then
drag that field down a range of cells, Excel increments the date or the
numeral within the text. How do I copy a field down a range, leaving it
unchanged, by dragging the value without incrementing the date or numeral
within text?

Thanks
Bill
 
D

Dave Peterson

I find this kind of thing difficult to remember, too.

So instead of struggling, I'll just rightclick on the autofill button (bottom
left corner of the activecell) and drag down.

When I let go of the right button, excel will prompt me with a bunch of
options. I can choose what I need.
 

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

Top