Make the adjustments here in the dialog box if Excel’s guess is not right. The marching-ants line denotes the range Excel guesses for the table.This is why you need to select a cell in the table in Step 1, so Excel can estimate the range of the table. Upon selecting the style, you will get a Create Table dialog box asking the range of the table.This option will automatically set the style to Table Style Medium 2, Blue, which can be changed later. Alternatively, you can use the keyboard shortcut Ctrl + T to create an Excel Table.You will see a menu from where you can select the style for the Excel Table. From the Home tab, in the Styles group, click Format as Table.Follow along to covert this dataset into an Excel Table: Let’s suppose the plain dataset below is what you have to start with.
#HOW TO USE MICROSOFT EXCEL TO ADD A ROW HOW TO#
Now, let's see how to convert your datasets into an Excel Table. This helps you to have an instant overview of the data without much effort. One of such convenient features of an Excel Table is the Total Row, which gives you the summary of calculations for each column with different data aggregation functions. While a dataset will give the benefit of being organized, an Excel table can take that further, making the data dynamic (adjusting the range with added or deleted data), pre-styled, and easier to analyze & summarize through its several useful and convenient features. You will actually have to convert the dataset into an Excel table to be able to use its many features. A table made up of rows, columns, and data is a dataset. If you are also under the common confusion that any table in an Excel file is an Excel table, let’s begin by clearing that up for you. Customize Totals with the SUBTOTAL function.Method 2 – Adding Total Row from the Table Design Tab.Method 1 – Adding Total Row from the Right-click Context Menu.