Search

Create Table

Last Updated: Dec 1, 2020

Articles

Use this function to create a table with the specified name in the specified range of the excel sheet.

Syntax

Create Table (range, table_name)

Parameters

Input Parameter Name Description
range Two cell values (first cell and last cell) separated by ‘:’ to create the table
table_name Name of the table to be created

':' is used as separator between the cells.

Sample

Create Table (A1:F10, New_Table)

  • Creates a table with the name ‘New_Table’ in the range ‘A1’ to ‘F10’ of the excel sheet.

To view all the Excel functions, click here.

Did you find what you were looking for?