Drag without incrementing

T

trvlnmny

I have cells that contain the account id for the named provider on that row. The account ids are numeric but I have them formatted as Text.
When I want to enter data for the same provider on a new row I elect the provider and id columns and drag them to the new row. The problem I am having is that the account id is incremented up by 1.
How can I prevent this?
Thanks for any and all help.
 
C

Claus Busch

Hi,

Am Tue, 29 Apr 2014 03:11:25 -0700 (PDT) schrieb (e-mail address removed):
I have cells that contain the account id for the named provider on that row. The account ids are numeric but I have them formatted as Text.
When I want to enter data for the same provider on a new row I elect the provider and id columns and drag them to the new row. The problem I am having is that the account id is incremented up by 1.
How can I prevent this?
Click to expand...

drag with pressed CTRL


Regards
Claus B.
 

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

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Excel - Wich Function should I use? 1
REINSTALLING MS OFFICE PRO PLUS 2019 0
New computer, how do i move outlook 365 ENTIRELY? 0
Need Help with a VBA subroutine 0
ISO best steps to export (import) all from Outlook 2003 to Outlook in MS 365 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0

Top