Forum Discussion
entry problem columns/cells
I use excel 2016 for my monthly bills. My lay out is a column for the bill, a column for the amount and a column for when and how paid. Example: column A visa, Column C $12.00, column E OL-2-4 ...
DTE, I just opened a new excel 2016 sheet, blank. If I make an entry each cell column A, the column B adjacent cell will duplicate my first entry. If I skip a few rows in column A, make another entry. Then the adjacent cell in column B will not duplicate.
This is a brand new sheet nothing else done. Is there something in the background , unseen, that can be adjusted?
This is a brand new sheet nothing else done. Is there something in the background , unseen, that can be adjusted?
Hi FredP76
I'm not sure if I fully understand:
You open a blank sheet and just enter something in column A. And this is duplicated automatically in column B? Without any formulas?
- Yes , no formulas.
Example:
column A- 1 att, 2 paper,3 house, 4 elect, skip 4 rows, 9 pge, 10 sewr, skip 2 rows, 13 mail
Column C - 1 ol 1-4, then in rows 2-4 ol 1-4 auto fills, when I skip to row 9 no auto fill but after entry row 10 auto fills
The auto fill function in settings is enabled but not consistent through out the form. I think that is what I'm talking about. I really have no understanding of Excel but really like using it when it's consistent.
Thanks so much for your help.