Dec 13 2021 10:57 AM
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
Say 15 rows. Each month I pay about 8 bills. The names are set. I add the dollar amount and how payed in the appropriate row and cells.
Been doing this many years. Last few seems something has changed. Before when entering when and how, the cells going down, the rows would auto fill the entry, even when I skipped rows.
Now when I skip a row or 2 the entry won't auto fill.
Not sure if 'auto fill' is the correct term, getting old.
Thanks any help appreciated
Dec 13 2021 11:47 PM
Hi @FredP76
it sounds as if you are using a formatted table for your past entries and now the new entries seem to be outside of the formatted table.
Example: Up to row 11, everything is within the formatted table, as you can see the additional menu "Table Design" (the exact name may vary depending on your Excel version)
Row 13, on the other hand, is outside of the formatted table, as there is no additional menu visible.
Check this out in your file. If this is similar, you just need to extend the table range, so it includes all lines:
Dec 14 2021 10:19 AM
I looked at my spreadsheet and can see no indication of a table any where. How can I tell if cells or columns are in a table?
Dec 14 2021 10:44 AM
Dec 15 2021 08:09 AM
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?
Dec 15 2021 10:39 AM