E
E. J.
Working with an Excel 2003 spreadsheet where a filter has
been invoked and not all records are being displayed. I
have tried to highlight a series of cells in a column and
then drag downward on the square in the lower right corner
to get a series of numbers displayed. All I can get the
program to do is to copy the number in the top cell. When
I enter 1, 2, 3 in a1, a10 a20 respectively, I want the
program to continue the trend all the way to the bottom of
my highlighted area. I can make it work when all records
are being displayed, but not when I'm using a filter.
Surely it will work with a filter, or it's not a very
useful tool. Please help
been invoked and not all records are being displayed. I
have tried to highlight a series of cells in a column and
then drag downward on the square in the lower right corner
to get a series of numbers displayed. All I can get the
program to do is to copy the number in the top cell. When
I enter 1, 2, 3 in a1, a10 a20 respectively, I want the
program to continue the trend all the way to the bottom of
my highlighted area. I can make it work when all records
are being displayed, but not when I'm using a filter.
Surely it will work with a filter, or it's not a very
useful tool. Please help