Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Hi Neelakanta,
Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Hi, I'm trying to do the same type of thing only numbering in triplicate. Is
this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#12
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Enter a number 1 in your start cell - I used A4 but any cell will work for
the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)<0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#13
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
YEA!!!!!!!!!THANK YOU!!!!
Wish I sould have discovered this group a couple days ago :) "Sandy Mann" wrote: Enter a number 1 in your start cell - I used A4 but any cell will work for the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)<0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#14
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Another technique you can adapt to suit your needs,
Put 1 in A1 Highlight A1 to A3 Grab the fill handle and drag to A30 Tap F5 Click Special Check Blanks and OK Type = Tap the up arrow Then hit Ctrl+Enter That technique comes courtesy of Debra Dalgleish at her excellent Contextures site, see here for that and lots more. http://www.contextures.com/xlDataEntry02.html HTH Martin "Sandy Mann" wrote in message ... Enter a number 1 in your start cell - I used A4 but any cell will work for the formula. Then in the cell below enter the formula: =A4+1-(MOD(ROW()-ROW($A$4),3)<0) Now highlight the range from A5 in my case to the end cell that you want using one of the methods already mentioned in this thread and then select Edit Fill down -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "pberg" wrote in message ... Hi, I'm trying to do the same type of thing only numbering in triplicate. Is this possible using the fill series. It is adding an extra cell every 3rd record. I need the database to read 1,1,1,2,2,2,3,3,3 etc Can this be done? "MartinW" wrote: Hi Neelakanta, Glad to hear you got it sorted out. As for personal emails, you will get far greater help from these newsgroups than any one person can offer. Regards Martin "Neelakanta" wrote in message ... Thank u Sandy and Martin. Actually i tried this but i made a mistake while implementing . Any way thank u ............ to both of u. I will be glad if both of u can give ur personal e mail id's so that we can share many things abt computers. hoping u will........... My e- mail id is Regards......... Neelakanta. |
#15
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Hi! can anyone tell me the ans for the following questions in excel........... Assume that there is a student table with the following attributes Name, stu Id , marks,(Assume that there are 500 students or columns) Q1. Student name starts with R Q2. marks which are less than 80 Q3. Marks which are greater than 50 Q4. Student name which has E in their Name?.............. |
#16
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
Are these homework questions?
Q1, Q2 & Q3 can be done using Autofilter Custom Q4 can be done using a Helper column & Autofilter -- 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 ... Hi! can anyone tell me the ans for the following questions in excel........... Assume that there is a student table with the following attributes Name, stu Id , marks,(Assume that there are 500 students or columns) Q1. Student name starts with R Q2. marks which are less than 80 Q3. Marks which are greater than 50 Q4. Student name which has E in their Name?.............. |
#17
Posted to microsoft.public.excel.newusers
|
|||
|
|||
captalize the letters in the Particular coloumn
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 |
#18
Posted to microsoft.public.excel.newusers
|
|||
|
|||
captalize the letters in the Particular coloumn
Without VBA you will need a helper column.
=UPPER(A1) Copy down as far as needed. Gord Dibben MS Excel MVP On Thu, 29 May 2008 08:55:01 -0700, Neelakanta wrote: 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 |
#19
Posted to microsoft.public.excel.newusers
|
|||
|
|||
what is "fill handle". i don't see any fill handle in my excel
No Sandy these are not Assignment questions......... just wanted to know.Thank u |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Handle | Excel Discussion (Misc queries) | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
What is a "fill handle" in Excel? | Excel Discussion (Misc queries) | |||
Fill Handle | Excel Discussion (Misc queries) | |||
Can you change the function of the fill handle on a cell in Excel | Excel Worksheet Functions |