Fill down
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?
|