Structured references are automatically created these are like range names and will be explained later.The headers are always visible as you scroll down the table.Filter icons are automatically added to the header row.The table range automatically expands (including the format) when you add new rows or columns to the table.By using the Format as Table icon you instruct Excel to treat a table like a basic database.įormatted tables have many advantages, such as: Unfortunately, most people think it is a formatting feature. The Format as Table icon on the Home ribbon tab was added in Excel 2007.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |