Excel Tips: Define Excel Table
Define Excel Table
Excel can also create an Excel table from an existing cell range as long as the range has no blank rows or columns within the data and there is no extraneous data in cells immediately below or next to the list.
To create an Excel table by using a keyboard shortcut, press Ctrl+L and then click OK.
When you add the total row, Excel creates a formula that summarizes the values in the rightmost Excel table column. You can change the summary function by picking a new one from the partial list displayed in the Excel table or by selecting a function
from the full set.