A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old May 26th, 2008, 10:40 AM posted to microsoft.public.excel.newusers
Neelakanta
external usenet poster
 
Posts: 15
Default what is "fill handle". i don't see any fill handle in my excel

what is "fill handle". i don't see any fill handle in my excel. can any one
guide me in the usage of this fill handle please? And also can anyone tell
how to get the numbers in series please

  #2  
Old May 26th, 2008, 10:58 AM posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
 
Posts: 2,264
Default what is "fill handle". i don't see any fill handle in my excel

The "fill handle" is the small square at the bottom right-hand corner of a
cell. If you hover the cursor over it the cursor will change into black
crosshairs - don't be confused with the four headed arrow cursor that you
get when on the edge of a cell, that will actually move the cell cot copy
the formula. With the blackbcrosshairs showing, left click and drag in the
direction you wish.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
what is "fill handle". i don't see any fill handle in my excel. can any
one
guide me in the usage of this fill handle please? And also can anyone tell
how to get the numbers in series please




  #3  
Old May 26th, 2008, 11:20 AM posted to microsoft.public.excel.newusers
Neelakanta
external usenet poster
 
Posts: 15
Default what is "fill handle". i don't see any fill handle in my excel

Thank u for the quick reply. But can u also teach me how easily to fill the
numbers in the columuns please.
  #4  
Old May 26th, 2008, 11:48 AM posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
 
Posts: 2,264
Default what is "fill handle". i don't see any fill handle in my excel

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the first
cell, 2 in the second and highlight both and drag down or along as the case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what you
are trying to do.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to fill
the
numbers in the columuns please.



  #5  
Old May 26th, 2008, 12:09 PM posted to microsoft.public.excel.newusers
Neelakanta
external usenet poster
 
Posts: 15
Default what is "fill handle". i don't see any fill handle in my excel

Thanks Sandy for replying soon. The things that u have described in the
privious post are familiar to me. The question is that without dragging the
"Fill paddle" how can i easily fill the numbers.(e.g. if i need to drag about
7000 numbers then it takes time. Isn't it? )in this case the easy thing is
that choose the entire column suppose "A" enter no. 1 and then go to edit-
fill- series- here type the desired stop value and press enter. that's it!
u will get the numbers until the specified stop value. But this works only
if u select the entire row . i need this feature to be worked in the middle
of the row also ........... can u help me please.........
Thanks in Advance.
Regards
Neelakanta

"Sandy Mann" wrote:

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the first
cell, 2 in the second and highlight both and drag down or along as the case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what you
are trying to do.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to fill
the
numbers in the columuns please.




  #6  
Old May 26th, 2008, 12:27 PM posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
 
Posts: 2,264
Default what is "fill handle". i don't see any fill handle in my excel

If you select the first cell then do a Goto and enter the last cell that you
want then press and hold the Shift key while you press the OK button on the
Goto dialog box then the range that you want will be highlighted.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thanks Sandy for replying soon. The things that u have described in the
privious post are familiar to me. The question is that without dragging
the
"Fill paddle" how can i easily fill the numbers.(e.g. if i need to drag
about
7000 numbers then it takes time. Isn't it? )in this case the easy thing is
that choose the entire column suppose "A" enter no. 1 and then go to
edit-
fill- series- here type the desired stop value and press enter. that's
it!
u will get the numbers until the specified stop value. But this works
only
if u select the entire row . i need this feature to be worked in the
middle
of the row also ........... can u help me please.........
Thanks in Advance.
Regards
Neelakanta

"Sandy Mann" wrote:

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the
first
cell, 2 in the second and highlight both and drag down or along as the
case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The
formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what
you
are trying to do.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to fill
the
numbers in the columuns please.









  #7  
Old May 26th, 2008, 01:20 PM posted to microsoft.public.excel.newusers
MartinW[_2_]
external usenet poster
 
Posts: 167
Default what is "fill handle". i don't see any fill handle in my excel

Hi Neelakanta,

Maybe this is what you are looking for.

Type A25:A7000 in the name box and then tap enter,
(the range A25:A7000 will be highlighted)
Type 1 and tap enter,
(A25 will show 1 and A26 will become the active cell)
Then go to EditFillSeries set your options and tap OK

HTH
Martin


"Neelakanta" wrote in message
...
Thanks Sandy for replying soon. The things that u have described in the
privious post are familiar to me. The question is that without dragging
the
"Fill paddle" how can i easily fill the numbers.(e.g. if i need to drag
about
7000 numbers then it takes time. Isn't it? )in this case the easy thing is
that choose the entire column suppose "A" enter no. 1 and then go to
edit-
fill- series- here type the desired stop value and press enter. that's
it!
u will get the numbers until the specified stop value. But this works
only
if u select the entire row . i need this feature to be worked in the
middle
of the row also ........... can u help me please.........
Thanks in Advance.
Regards
Neelakanta

"Sandy Mann" wrote:

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the
first
cell, 2 in the second and highlight both and drag down or along as the
case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The
formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what
you
are trying to do.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to fill
the
numbers in the columuns please.






  #8  
Old May 26th, 2008, 06:37 PM posted to microsoft.public.excel.newusers
Neelakanta
external usenet poster
 
Posts: 15
Default what is "fill handle". i don't see any fill handle in my excel

no martin my question is that how can u fill the series of numbers from say
50 to 90 without using the fill paddle and that too from the middle of the
column

"MartinW" wrote:

Hi Neelakanta,

Maybe this is what you are looking for.

Type A25:A7000 in the name box and then tap enter,
(the range A25:A7000 will be highlighted)
Type 1 and tap enter,
(A25 will show 1 and A26 will become the active cell)
Then go to EditFillSeries set your options and tap OK

HTH
Martin


"Neelakanta" wrote in message
...
Thanks Sandy for replying soon. The things that u have described in the
privious post are familiar to me. The question is that without dragging
the
"Fill paddle" how can i easily fill the numbers.(e.g. if i need to drag
about
7000 numbers then it takes time. Isn't it? )in this case the easy thing is
that choose the entire column suppose "A" enter no. 1 and then go to
edit-
fill- series- here type the desired stop value and press enter. that's
it!
u will get the numbers until the specified stop value. But this works
only
if u select the entire row . i need this feature to be worked in the
middle
of the row also ........... can u help me please.........
Thanks in Advance.
Regards
Neelakanta

"Sandy Mann" wrote:

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the
first
cell, 2 in the second and highlight both and drag down or along as the
case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The
formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what
you
are trying to do.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to fill
the
numbers in the columuns please.







  #9  
Old May 26th, 2008, 06:48 PM posted to microsoft.public.excel.newusers
Sandy Mann
external usenet poster
 
Posts: 2,264
Default what is "fill handle". i don't see any fill handle in my excel

With the start number in the start cell use: Fill Series and enter the
stop number

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
no martin my question is that how can u fill the series of numbers from
say
50 to 90 without using the fill paddle and that too from the middle of
the
column

"MartinW" wrote:

Hi Neelakanta,

Maybe this is what you are looking for.

Type A25:A7000 in the name box and then tap enter,
(the range A25:A7000 will be highlighted)
Type 1 and tap enter,
(A25 will show 1 and A26 will become the active cell)
Then go to EditFillSeries set your options and tap OK

HTH
Martin


"Neelakanta" wrote in message
...
Thanks Sandy for replying soon. The things that u have described in the
privious post are familiar to me. The question is that without dragging
the
"Fill paddle" how can i easily fill the numbers.(e.g. if i need to drag
about
7000 numbers then it takes time. Isn't it? )in this case the easy thing
is
that choose the entire column suppose "A" enter no. 1 and then go to
edit-
fill- series- here type the desired stop value and press enter.
that's
it!
u will get the numbers until the specified stop value. But this works
only
if u select the entire row . i need this feature to be worked in the
middle
of the row also ........... can u help me please.........
Thanks in Advance.
Regards
Neelakanta

"Sandy Mann" wrote:

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the
first
cell, 2 in the second and highlight both and drag down or along as the
case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The
formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example
the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what
you
are trying to do.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to
fill
the
numbers in the columuns please.










  #10  
Old May 26th, 2008, 10:15 PM posted to microsoft.public.excel.newusers
MartinW[_2_]
external usenet poster
 
Posts: 167
Default what is "fill handle". i don't see any fill handle in my excel

Hi,

Sandy's way is simpler, although they are basically the same, anyway
try it like this,
Click in the Name box and type A25:A65 and hit enter.
Type 50 and hit enter
go to EditFillSeries and tap OK

A25:A65 will show the numbers 50 to 90
incrementing by 1 each time.

HTH
Marin


"Neelakanta" wrote in message
...
no martin my question is that how can u fill the series of numbers from
say
50 to 90 without using the fill paddle and that too from the middle of
the
column

"MartinW" wrote:

Hi Neelakanta,

Maybe this is what you are looking for.

Type A25:A7000 in the name box and then tap enter,
(the range A25:A7000 will be highlighted)
Type 1 and tap enter,
(A25 will show 1 and A26 will become the active cell)
Then go to EditFillSeries set your options and tap OK

HTH
Martin


"Neelakanta" wrote in message
...
Thanks Sandy for replying soon. The things that u have described in the
privious post are familiar to me. The question is that without dragging
the
"Fill paddle" how can i easily fill the numbers.(e.g. if i need to drag
about
7000 numbers then it takes time. Isn't it? )in this case the easy thing
is
that choose the entire column suppose "A" enter no. 1 and then go to
edit-
fill- series- here type the desired stop value and press enter.
that's
it!
u will get the numbers until the specified stop value. But this works
only
if u select the entire row . i need this feature to be worked in the
middle
of the row also ........... can u help me please.........
Thanks in Advance.
Regards
Neelakanta

"Sandy Mann" wrote:

If you mean a series of numbers like 1, 2, 3, 4 etc then put 1 in the
first
cell, 2 in the second and highlight both and drag down or along as the
case
may be on the fill handle of the 2nd cell.

If you mean copy the formula in the first cell to a range then with a
formula - say =A1+B1 then simply drag down on the fill hande. The
formula
will index uplike:

=A1+B1
=A2+B2
=A3+B3

If you want one of the cells to remain constant - say in this example
the
cell A1 then make it an absolute reference like:

=$A$1+B1
=$A$1+B2
=$A$1+B13

If this is not what you want then post back with more details for what
you
are trying to do.

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Neelakanta" wrote in message
...
Thank u for the quick reply. But can u also teach me how easily to
fill
the
numbers in the columuns please.









 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.