increase data with cursor on cell bottom right corner

G

Guest

Hi,
I can't incremente cells data by setting the pointer on the bottom right
corner of the selected cell. The pointer doesn't change to allow to perform
such operation.
Pls give a hand.
Sabin.
 
B

Bernard Liengme

Not too sure I understand the question but I will assume it is something
like:
You have a number (say 5) in a10 and you want a11:A20 to read 5, 6,7,8 ...
15

Method 1: enter 6 in A11; select A10 and A11; place the pointer over the
fill handle (lower right corner) of A11; drag down to A20

Method 2: select A10; use command Edit | Fill; specify Series; select
Columns and stop- number 15; click OK

best wishes (please return if I did not answer the question)
 
D

Debra Dalgleish

Choose Tools>Options
Hi,
I can't incremente cells data by setting the pointer on the bottom right
corner of the selected cell. The pointer doesn't change to allow to perform
such operation.
Pls give a hand.
Sabin.
 

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