1
Open or Navigate to Excel window
Open Microsoft Word or switch to the active Excel window on your taskbar to begin editing your worksheet.
How to make a table in Google Sheets
Learn how to quickly organize and format your data by converting it into a table in Google Sheets. This step-by-step tutorial guides you through creating a new spreadsheet, converting your data range, and customizing the table's style with custom colors and gridlines. By the end of this guide, you will be able to efficiently manage and visually enhance your tables for better data presentation.
Operations
2
Select Your Cell Range
Click and drag across the cells you want to convert into a table (e.g., A1:C7).
3
Click the Format menu
Click the Format menu in the top menu bar to view the formatting options.
4
Select the Convert to table option
Click the Convert to table option in the dropdown menu to format the selected cells.
5
Click the Table 1 dropdown arrow
Click the dropdown arrow next to "Table 1" to open the table options menu.
6
Update table header color
Click the #9b3642 color swatch in the Table Colors menu to apply it to the table header.
7
Click the Show table gridlines option
Click the "Show table gridlines" option in the sub-menu to toggle the visibility of gridlines within the table.
8
Preview Your Customized Table
Review the final design and layout before applying your changes.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.