ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Filling cells (https://www.excelbanter.com/excel-discussion-misc-queries/172242-re-filling-cells.html)

FSt1

Filling cells
 
hi
step value = 1 makes it increase
step value = -1 makes it decrease

regards
FSt1

"Stumped" wrote:

Hello All,

I am trying to change how Excel automatically fills in a series. Currently,
it fills by keeping the cell number static and going up the alphabet. How
would I get it to keep the alpha static and *decrease* as it moves to the
right?


stumped

Filling cells
 
I guess I am still stumped. Instead of fill doing A1, B1, C1, D1....How would
I get it to fill A10, A9, A8, A7, A6.....

"FSt1" wrote:

hi
step value = 1 makes it increase
step value = -1 makes it decrease

regards
FSt1

"Stumped" wrote:

Hello All,

I am trying to change how Excel automatically fills in a series. Currently,
it fills by keeping the cell number static and going up the alphabet. How
would I get it to keep the alpha static and *decrease* as it moves to the
right?



All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com