{"id":9148,"date":"2023-09-04T14:33:00","date_gmt":"2023-09-04T14:33:00","guid":{"rendered":"https:\/\/randomtools.io\/blog\/?p=9148"},"modified":"2023-10-03T12:57:35","modified_gmt":"2023-10-03T12:57:35","slug":"how-to-make-a-table-in-google-sheets-in-2023","status":"publish","type":"post","link":"https:\/\/randomtools.io\/blog\/how-to-make-a-table-in-google-sheets-in-2023\/","title":{"rendered":"How to Make a Table in Google Sheets in 2023?"},"content":{"rendered":"\n

Tables are fundamental components of a spreadsheet that allow you to structure and complete data in one place. Though the basic concept of a table is the same, the basic varies depending upon the software you are using. This is why while using Google Sheets, you might sometimes have questions like – how to make a table in Google Sheets.<\/p>\n\n\n\n

Excel and Google Sheets are similar, with a hint of differences that might cause the users to wonder. So, in this blog, we discuss how to make a table in Google Sheets <\/a>and learn how to format it, which will help them be identified as tables. <\/p>\n\n\n\n

\n
TOC (Table Of Content<\/strong>)<\/td><\/tr>
Introduction
How to Create a Table in Google Sheets?
How to Make a Table in Google Sheets – Pivot Table
How to Make a Table in Google Sheets – Table Chart
How to Make a Table in Google Sheets – Border
How to Make a Table in Google Sheets – FormattingApply Alternating Row Color
How to Make a Table in Google Sheets – Filtered Table
How to Make a Table in Google Sheets – Collapsible Table
How to Make a Table in Google Sheets – Searchable Table
How to Make a Table in Google Sheets – Resizing Rows and Columns
How to Make a Table in Google Sheets – Sort the Columns
How to Make a Table in Google Sheet – With Colors and Indicator Arrows
How to Delete Table Columns and Row in Google Sheet?
Conclusion<\/gwmw><\/td><\/tr><\/tbody><\/table><\/figure>\n<\/div><\/div>\n\n\n

\nHow to Create a Table in Google Sheets?<\/strong><\/gwmw><\/gwmw><\/gwmw>\n<\/h2>\n\n\n

Like Excel, Google Sheets does not allow you to create a table. Instead, you can use borders and formatting to make a table. Creating a table is a two-step task. First, you need to open a spreadsheet in your browser. Once done, follow the steps below to create a table –<\/p>\n\n\n\n

  • Once you have your spreadsheet open, you can first enter the details that you want (like the ones mentioned below). <\/li><\/ul>\n\n\n\n
    \"How<\/figure>\n\n\n\n
    • You have your table ready. Now is the time to format and make it look more appealing and user-friendly.<\/li><\/ul>\n\n\n\n

      Now that you know how to make a data table in Google Sheets let’s see how to make other tables and format them – to make them look more appealing and scannable. <\/p>\n\n\n

      \nHow to Make a Table in Google Sheets – Pivot Table<\/strong><\/gwmw>\n<\/h2>\n\n\n

      A pivot table is a semi-automated tool that presents custom summarization of large data sets to ensure you and other users understand it well. Without a pivot table, you might have to use several formulas and techniques that might seem cumbersome at times. Here\u2019s how to make a pivot table in Google Sheets –<\/p>\n\n\n\n

      • Go to the Insert <\/em>option in the menu bar and select Pivot<\/em>. <\/li><\/ul>\n\n\n\n
        \"\"\/<\/figure>\n\n\n\n
        • Add a data range.<\/li><\/ul>\n\n\n\n
          \"\"\/<\/figure>\n\n\n\n
          • If you want to insert the pivot table in the existing sheet, click the existing sheet. <\/li>
          • Once done, click Create<\/em>. <\/li>
          • On the contrary, if you want to add the table to a new sheet, click on New Sheet<\/em>. <\/li>
          • Voila! You have a new sheet with a pivot table. <\/li><\/ul>\n\n\n\n
            \"\"\/<\/figure>\n\n\n\n

            A pivot table is also helpful if you have a question – how to make a frequency table in Google Sheets.<\/p>\n\n\n

            \nHow to Make a Table in Google Sheets – Table Chart<\/strong><\/gwmw>\n<\/h2>\n\n\n

            Creating a chart or graph helps in sorting your data. Thus making it easier for you to read and understand. Here\u2019s how to make a table chart in Google Sheets –<\/p>\n\n\n\n

            • Select the data you want to use. <\/li>
            • Go to Insert<\/em>. <\/li>
            • Select Chart<\/em>. <\/li><\/ul>\n\n\n\n
              \"\"\/<\/figure>\n\n\n\n
              • There will be a default bar graph just like the one below.<\/li><\/ul>\n\n\n\n
                \"\"\/<\/figure>\n\n\n\n
                • There will be options to make a bar chart, pie chart, column, and line chart. <\/li><\/ul>\n\n\n\n
                  \"\"\/<\/figure>\n\n\n\n
                  • Choose the chart type you want to use. <\/li>
                  • The chart updates automatically with the data given in the sheet. Also, you can customize any data or graph you want from the options at the side of the page.<\/li><\/ul>\n\n\n

                    \nHow to Make a Table in Google Sheets – Border<\/strong><\/gwmw>\n<\/h2>\n\n\n

                    Borders make huge differences in making your table look like a proper table. Here\u2019s how you can do it –<\/p>\n\n\n\n

                    • Once you have entered all the necessary details in the row and column, press CTRL+A to select the entire page.<\/li>
                    • From the bar above, click the icon that looks like a border.<\/li><\/ul>\n\n\n\n
                      \"\"\/<\/figure>\n\n\n\n
                      • You can select the type of border you want. In addition, you can also change the color of the border.<\/li>
                      • Once done, your table will be something like this. <\/li><\/ul>\n\n\n\n
                        \"\"\/<\/figure>\n\n\n

                        How to Make a Table in Google Sheets – Formatting<\/strong><\/h2>\n\n\n

                        Now that you have a table base ready, it is time to make it prettier, collapsible, filtered, searchable, and functional. Before that, you must know that there are no table formatting shortcuts. But here\u2019s how you can format your table so that you can customize it according to your wish –<\/p>\n\n\n

                        Apply Alternating Row Color<\/strong><\/h3>\n\n\n

                        Here\u2019s how to apply alternate row color – <\/p>\n\n\n\n

                        • Select the range of cells that contains your table, including the header. <\/li>
                        • Click on Format<\/em>. You will see an option of Alternating Colors<\/em>. <\/li><\/ul>\n\n\n\n
                          \"\"\/<\/figure>\n\n\n\n
                          • A page will appear at the side of the sheet, where you can see a green checkbox. <\/li><\/ul>\n\n\n\n
                            \"\"\/<\/figure>\n\n\n\n
                            • This happens when the Google Sheet will automatically recognize the headers. <\/li>
                            • If it is not checkmarked, you can do it manually. <\/li>
                            • In addition, you can also create a custom format by manually selecting the header color and the alternating color for the row. <\/li>
                            • Moreover, you can choose any one of the Google Sheets default to create a style of your own. <\/li><\/ul>\n\n\n\n
                              \"\"\/<\/figure>\n\n\n\n
                              • You can play around with the table formatting and select one that resonates with your brand or choice. <\/li>
                              • Once you are satisfied with the color, click on Done<\/em>. <\/li>
                              • If you want to remove the alternating colors, click on Remove Alternating Colors<\/em> below the end of the page.  <\/li><\/ul>\n\n\n\n
                                \"\"\/<\/figure>\n\n\n

                                How to Make a Table in Google Sheets – Filtered Table<\/strong><\/h2>\n\n\n

                                You must first know that Google Sheets allows one filtered table per sheet. However, you can use different tabs in one sheet. The filtering table helps you add filters to each column, allowing you to sort your data with a few clicks. Now that you know how it works, read below to create a filtered table –<\/p>\n\n\n\n