what is "fill handle". i don't see any fill handle in my excel

[Neelakanta]

how can i captalise the letters in the particular column of excel worksheet.
can it be done through only excel, but not vb programming.

Thanks in advance.
Regards
Neelakanta

 

[Gord Dibben]

Without VBA you will need a helper column.

=UPPER(A1)

Copy down as far as needed.


Gord Dibben MS Excel MVP

 

[Neelakanta]

hey guys can any one help me?(of course it is not a excel question)
My drives are not openinin. if i double click on my drives an "open with"
window opens. I know that it is a virus. Can u send the free link of the anti
virus software that removes this virus?

Thanks in advance.
Neelakanta.

 

[pberg]

Sandy, this formula worked great for my last job, but now i need to number in
triplicate starting with 0001 to 1500. Excel eliminates those preceding zeros
and I need them to be there. I have tried to format the cells to text but
then this formula does not work. Can you help me out with this one?

 

[Sandy Mann]

If it is just for display purposes then Custom format the cells, (Highlight
the calls then select Format > Cells > Custom ) as 0000 then numbers will
then be displayed with leading zeros if there are fewer digits.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[pberg]

Thanks again!!!

If it is just for display purposes then Custom format the cells, (Highlight
the calls then select Format > Cells > Custom ) as 0000 then numbers will
then be displayed with leading zeros if there are fewer digits.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You are very welcome.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[pberg]

How about this one... I need to number 0001 to 1500 only in groups of 5. iE:
0001,0002,0003,0004,0005,0751,0752,0753,0754,0755,0006,0007,0008,0009,0010,0756,0757,0758,0759,0760....all
the way to 1500. What formula or fill series will make this work?

 

[Sandy Mann]

What is the logic in deciding that

0751,0752,0753,0754,0755,

comes between 0001,0002,0003,0004,0005
and 0006,0007,0008,0009,0010 ?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[pberg]

Well, it is a crazy job that I'm numbering in another program and I need the
first five numbers 1-5 lined up on the left side of the page, next sheet is
to have the next five numbers 6-10 all the way to 750. The the other half of
the page will have numbers 751- to 755 on the first sheet. So I'm trying to
print 1-5 and 751 to 755 on the first sheet, 6-10 and 756 to 760 on the
second sheet etc.

 

[Sandy Mann]

Enter 1-5 in A1:A5 and 751 - 755 in A6:A10

In A11 enter:

=A5+1

In A12 enter:

=A11+1

and drag it down to A15 on the fill handle.

Next as MartinW said:
Type A11:A1500 in the name box and then tap enter,

and:
Then go to Edit > Fill > Series
and select Autofill and press OK.

Finally while the cells are still highlighted, copy them and then Past
Special > Values over the top of the formulas to remove the formulas..

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[pberg]

Magic.....thanks again

Enter 1-5 in A1:A5 and 751 - 755 in A6:A10

In A11 enter:

=A5+1

In A12 enter:

=A11+1

and drag it down to A15 on the fill handle.

Next as MartinW said:
Type A11:A1500 in the name box and then tap enter,

and:
Then go to Edit > Fill > Series
and select Autofill and press OK.

Finally while the cells are still highlighted, copy them and then Past
Special > Values over the top of the formulas to remove the formulas..

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You're welcome. Thanks for taking the time to feed back.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk