How do I "fill down" the same number using the fill handle?

Jaci

Select the range that you want the same number in, goto the formula bar and
enter the number you want in that range, holding "ctrl" hit "enter" and your
range will have the number you want.

Does this help?

Mike Rogers

"Jaci" wrote:

How do I "fill down" the same number using the fill handle?

Thanks for your help Mike! I was able to figure out that if I use the fill
handle, I can select the Copy from the Auto Options that pops up, but I'm not
sure now how to get it so that it keeps that as the option always instead of
increasing the number. I know that it can be done, as I have had it that way
before. Any ideas? Do I make sense??

Thanks!

"Mike Rogers" wrote:

Jaci

Select the range that you want the same number in, goto the formula bar and
enter the number you want in that range, holding "ctrl" hit "enter" and your
range will have the number you want.

Does this help?

Mike Rogers

"Jaci" wrote:

How do I "fill down" the same number using the fill handle?

I typed the same number in adjacent cells, selected both, then fill handle
does what you want.
Lou

"Jaci" wrote:

Thanks for your help Mike! I was able to figure out that if I use the fill
handle, I can select the Copy from the Auto Options that pops up, but I'm not
sure now how to get it so that it keeps that as the option always instead of
increasing the number. I know that it can be done, as I have had it that way
before. Any ideas? Do I make sense??

Thanks!

"Mike Rogers" wrote:

Jaci

Select the range that you want the same number in, goto the formula bar and
enter the number you want in that range, holding "ctrl" hit "enter" and your
range will have the number you want.

Does this help?

Mike Rogers

"Jaci" wrote:

How do I "fill down" the same number using the fill handle?

I think I may have found the root cause of my error. Here's what I have and
keep running into:
Column A Column B Column C
405 678 Dallas
563 Houston
798 Fort Worth
I am pulling information from a pivot table and where cell A1 shows 405
above, I need to fill that down with all 405, not 405, 406, 407, etc...
Because my data is not consecutive in Column B it won't just copy 405 when I
fill down. I think that it is being read as text and needs to be converted
to a number, but how can I change that so that I can keep that as the default
on my spreadsheet and not have to change it all the time?

"Rookie 1st class" wrote:

I typed the same number in adjacent cells, selected both, then fill handle
does what you want.
Lou

"Jaci" wrote:

Thanks for your help Mike! I was able to figure out that if I use the fill
handle, I can select the Copy from the Auto Options that pops up, but I'm not
sure now how to get it so that it keeps that as the option always instead of
increasing the number. I know that it can be done, as I have had it that way
before. Any ideas? Do I make sense??

Thanks!

"Mike Rogers" wrote:

Jaci

Select the range that you want the same number in, goto the formula bar and
enter the number you want in that range, holding "ctrl" hit "enter" and your
range will have the number you want.

Does this help?

Mike Rogers

"Jaci" wrote:

How do I "fill down" the same number using the fill handle?

Press Ctrl when you drag using fill handle
It will show + sign, it means copy.

"Jaci" wrote:

I think I may have found the root cause of my error. Here's what I have and
keep running into:
Column A Column B Column C
405 678 Dallas
563 Houston
798 Fort Worth
I am pulling information from a pivot table and where cell A1 shows 405
above, I need to fill that down with all 405, not 405, 406, 407, etc...
Because my data is not consecutive in Column B it won't just copy 405 when I
fill down. I think that it is being read as text and needs to be converted
to a number, but how can I change that so that I can keep that as the default
on my spreadsheet and not have to change it all the time?

"Rookie 1st class" wrote:

I typed the same number in adjacent cells, selected both, then fill handle
does what you want.
Lou

"Jaci" wrote:

Thanks for your help Mike! I was able to figure out that if I use the fill
handle, I can select the Copy from the Auto Options that pops up, but I'm not
sure now how to get it so that it keeps that as the option always instead of
increasing the number. I know that it can be done, as I have had it that way
before. Any ideas? Do I make sense??

Thanks!

"Mike Rogers" wrote:

Jaci

Select the range that you want the same number in, goto the formula bar and
enter the number you want in that range, holding "ctrl" hit "enter" and your
range will have the number you want.

Does this help?

Mike Rogers

"Jaci" wrote:

How do I "fill down" the same number using the fill handle?

Jaci

I have a feeling you are on the right track, but I think what you need to do
is: When you select the cell and move over the lower right corner and get
your little "+" double click and drag it down. I think you might be just
clicking once in the selected cell and getting the menu.

Does this help?

Mike Rogers

"Jaci" wrote:

Thanks for your help Mike! I was able to figure out that if I use the fill
handle, I can select the Copy from the Auto Options that pops up, but I'm not
sure now how to get it so that it keeps that as the option always instead of
increasing the number. I know that it can be done, as I have had it that way
before. Any ideas? Do I make sense??

Thanks!

"Mike Rogers" wrote:

Jaci

Select the range that you want the same number in, goto the formula bar and
enter the number you want in that range, holding "ctrl" hit "enter" and your
range will have the number you want.

Does this help?

Mike Rogers

"Jaci" wrote:

How do I "fill down" the same number using the fill handle?

Jaci

Right-click and drag.

Release the button and select "copy cells".


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 11:35:02 -0800, Mike Rogers
wrote:

Jaci

I have a feeling you are on the right track, but I think what you need to do
is: When you select the cell and move over the lower right corner and get
your little "+" double click and drag it down. I think you might be just
clicking once in the selected cell and getting the menu.

Does this help?

Mike Rogers

"Jaci" wrote:

Thanks for your help Mike! I was able to figure out that if I use the fill
handle, I can select the Copy from the Auto Options that pops up, but I'm not
sure now how to get it so that it keeps that as the option always instead of
increasing the number. I know that it can be done, as I have had it that way
before. Any ideas? Do I make sense??

Thanks!

"Mike Rogers" wrote:

Jaci

Select the range that you want the same number in, goto the formula bar and
enter the number you want in that range, holding "ctrl" hit "enter" and your
range will have the number you want.

Does this help?

Mike Rogers

"Jaci" wrote:

How do I "fill down" the same number using the fill handle?

the below process works well for filling in blanks often found in pivot table
data. Maybe this will help.

How to 'Fill Blank Cells' -

Start by selecting the empty cells:
1. Select the cells in the column, starting in the row below the column
heading.
2. Choose Edit | Go To
3. Click the Special button
Select Blanks, click OK
Enter the formula to copy the value:
1. Type an equal sign
2. Press the up arrow on the keyboard -- this will enter a reference to the
cell above -- cell A2 in this example
Hold the Ctrl key and press Enter -- this enters the formula in all selected
cells
Change the formulas to values:
In order to sort or filter the data, the formulas must be changed to values.
1. Select the entire column
2. Choose Edit | Copy
3. With the column still selected, choose Edit | Paste Special
4. Select Values, click OK
Note: Do this carefully if there are other cells in the range which contain
formulas.

--
T Tipsy


"Jaci" wrote:

How do I "fill down" the same number using the fill handle?