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

  • Thread starter Thread starter Neelakanta
  • Start date Start date
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
 
Without VBA you will need a helper column.

=UPPER(A1)

Copy down as far as needed.


Gord Dibben MS Excel MVP
 
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.
 
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?
 
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
 
Thanks again!!!

Sandy Mann said:
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
Click to expand...
 
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
 
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?
 
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
 
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.
 
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
 
Magic.....thanks again

Sandy Mann said:
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
Click to expand...
 
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
 
Back
Top