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 ...
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:
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?