View Single Post
 
Old 03-17-2023, 10:32 AM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 362
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by skeezix View Post
Thank you for replying and for the images.

I don't understand what a "proper" table is. Maybe it's something other than what Excel 2000 provides...?
Might be. I can't remember that far back. But in ribbon Excel-world, formatting your data range as a table does a bunch of things that make adding data, filtering, and doing formulas that you can repeat down the column easier.

Ten Reasons to use Tables in Excel | Chris Menard Training gives a pretty good look at what tables can do. The main thing I thought of with what you are doing is that the table will automatically see when you're adding a new row beneath the existing ones, and format them as part of the table. So if a chart were created off that column rather than cells (A2:A5), it would include any new data as you built it up.
Reply With Quote