converting plain data to table format

K

krazy4keno

It has been a while since I used excel but I am almost sure there is a way to convert just plain rows and columns of data into a table format. This way I believe that adding rows to this block of data is as simple as tabbing after the last cell and it should just drop down to the next row and insert one??? correct??
 
D

Debra Dalgleish

Excel should recognize a contiguous range as a table, or list. Include
headings in the first row, and leave at least one blank row and column
between the table and other items on the worksheet.

You can use the built-in data form to add records to the table
(Data>Form). Or, turn on the AutoExtend feature (Tools>Options, Edit
tab, 'Extend list formats and formulas), and you add rows on the worksheet.

View specific records by filtering the data (Data>Filter>AutoFilter),
and summarize with Pivot Tables.
 
Top