Fill down

M

Mike Rogers

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
 
J

Jaci

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!
 
R

Rookie 1st class

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

Mike Rogers

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
 
J

Jaci

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
 
G

Gord Dibben

Jaci

Right-click and drag.

Release the button and select "copy cells".


Gord Dibben MS Excel MVP
 
T

Terry Tipsy

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.
 
Top