Forum Discussion
FredP76
Dec 13, 2021Copper Contributor
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 ...
FredP76
Dec 14, 2021Copper Contributor
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?
Martin_Weiss
Dec 15, 2021Bronze Contributor
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?