Excel Shortcut Keys: Ctrl + L (Create a Table)

Excel Shortcut Keys

Ctrl + L

Displays the Create Table dialog box. To Make a Table

or Make your data into uniform to change your range into Table

 

 

Create a Pivot Table

Excel Tutorial

Create a pivot Table

How to create a Pivot Table in Excel

Add a Total row in Excel Table

Excel Tutorial

Add a Total row in Excel Table

In default Excel Table Row total is not visible.

 

Create a table in Excel

Excel Tutorial

Create a table in Excel worksheet

Tables make it easy to sort, filter, and format data within a sheet. Also you can organize, manage and analyze related data, table also included the built-in filtering, sorting, and row shading.