If you want to convert the Excel Table back to the normal tabular range, right-click anywhere on the table, go to Table and select Convert to Range. Converting Excel Table into Regular Tabular Data Note that when you convert tabular data into an Excel table, only the design changes. Data Filters are enabled (note the arrow pointing down at the right of the headers).The header is shaded in a different color.Note that some changes automatically happen with your data: When your tabular data is converted into Excel Table, your data would look as shown below: It would directly open the Format as Table dialogue box. TIP : A much faster way to do this is to select any cell within the data set and use the keyboard shortcut – Control + T. In case your data does not have headers, excel automatically inserts headers with generic name Column 1, Column 2, and so on. If your table has headers, keep the check box checked. In the Format as Table dialogue box, ensure that the right range is selected.Select any one of the pre-defined formats.If you have the data in the tabular format in a worksheet, here are the steps to convert it into an Excel table Just by converting a data range into a table, you are able to use a variety of features that will make your work super easy (I cover these features in detail below in this article). It makes it easy for a user to manage data if it is in a tabular format. It is super easy to understand and have a lot of merits over regular tabular data in Excel. Excel Table is probably one of the most underrated features in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |