How to Make a Table in Google Sheets [Easiest Way 2023]
In this article we will show you how to make a table in google sheets in just a few simple steps from your spreadsheet data.
For the purpose of this demonstration an example data set has been created, access and follow along by clicking this link.
How to Create a Table in Google Sheets
In this example we will show you how to create a table in just a few simple steps. We will use the example data set containing numbers, months, active status and financial values below to demonstrate this.
1. Highlight the Header Row for the Table
Click on the first cell of the header row and then drag the cursor over the rest of the required cells to highlight them.
In this example we will highlight cells A3 to D3.
2. Apply Bold Formatting to the Table Header
Make the text in the header row bold by selecting it and clicking the B icon in the toolbar.
Other options that can be applied to text include changing the color, italic or strike through.
3. Apply Text Wrapping to the Header Text
Text wrapping keeps the values of a cell contained in a tidy and uniform way, while displaying all of the information within.
With the header cells still highlighted, wrap the contents of the cell values to remove overflow by first clicking the Text wrapping icon then from the dropdown the Wrap option.
The cells have been resized to accommodate the values within, but only the text in cell D3 is long enough to wrap.
4. Center the Values of the Header Cells using the Toolbar
Highlight the required text to center. click the Horizontal align icon in the toolbar and then click the Center icon.
The values in the highlighted cells have now been centered.
5. Apply Alternating Colors by Clicking “Format” followed by “Alternating colors”
Select and highlight the whole data set. In the toolbar click Format and in the dropdown select Alternating colors
The alternating colors have been applied and the header has automatically been assigned a bold color to stand out from the rest of the data set.
The sidebar can be used to select custom colors that can be applied to the entire data set, including headers and footers.
6. Formatting Data as a Currency
You can now apply additional formatting to your dataset. For our example we will format the data in column D as a currency.
In our example we have highlighted the cells D4 to D11, omitting The header cell of D3. With the data highlighted, in the toolbar click the dollar symbol $.
The currency format has now been applied to the values of column D.
The currency section of the toolbar offers many options to customize your data. Decimal points can be moved and further options can be found in the 123 icon including the option to change the currency type.
7. Center the Values of Cells using the Toolbar
Highlight the range of cells you want to center and click the Horizontal align icon from the toolbar followed by clicking the Center iconfrom the drop down.
In our example below we have highlighted the cell range A4:C11.
The data has now been aligned to the center of each cell.
8. Create a Border around the Table by Clicking Borders in the Toolbar
Highlight the entire dataset and Click the Borders Icon in the toolbar. From the drop down menu select Outer Borders.
The table now has a border surrounding it.
To distinguish the header from the rest of the data set, highlight the header row and from the toolbar click Borders. In the dropdown options click Bottom border
9. Your Table has Now Been Created and Formatted
The data set is now contained in a complete table.