copying within cells

Discuss the spreadsheet application

copying within cells

Postby raichlea » Tue Apr 15, 2008 12:20 am

Hi all and thanks in advance

I am trying to copy a cell hundreds of times by dragging.

If I type something "text-only" into the cell and then drag the plus sign for awhile, it will copy the contents as many times as I want. However. if there is a number at the end like "NK1" it automatically increments the number when I drag to NK2, NK3, etc. I don't want this to happen... Is there a way to turn this off?
raichlea
 
Posts: 1
Joined: Mon Apr 14, 2008 11:33 pm

Re: copying within cells

Postby RonIA » Tue Apr 15, 2008 1:20 am

Normally this behavior is desired. What I would recommend that I have done previously is to put NV1 in cell A1 and NV1 in cell A2, then highlight BOTH A1 and A2 and drag to copy. You have just set the increment pattern to NOT increment.
Ron from Iowa, USA
RonIA
Volunteer
 
Posts: 139
Joined: Mon Oct 08, 2007 1:34 am
Location: Iowa USA

Re: copying within cells

Postby acknak » Tue Apr 15, 2008 1:47 am

Holding Ctrl while doing a drag-fill will also force a simple copy of the first cell. You can hold Ctrl while dragging, or just press it at the end, just before you release the mouse button.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: copying within cells

Postby huw » Tue Apr 15, 2008 9:49 am

It can be quicker to select the range you want to fill, type the entry, and press Alt+Enter instead of just Enter.
huw
Volunteer
 
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 20 guests