![]() Tables in Microsoft Excel do more than just look good. Filter Button – Check this box to add a dropdown arrow to the right of each column heading which lets you perform the filtering options we will discuss in the next section.This can conflict with the Banded Rows option, so it’s typically best to choose one or the other. Banded Columns – Check this option to alternate the colors of each row.Last Column – Check this option to bold all of the values in the rightmost column.First Column – Check this option to bold all of the values in the first column.Banded Rows – Check this option if you want the colors of the table rows to alternate automatically.Total Row – Check this box to include a Total cell at the bottom of the table for the rightmost column.Header Row – check this box if your table has a header row, which identifies the information contained in each column.Step 2: Select the data in the spreadsheet that you wish to turn into a table. Step 1: Open the spreadsheet in Excel 2013 that contains the data you want to turn into a table. If you don’t have headers (a row at the top of the spreadsheet that identifies the data in the columns) then you may want to add a header row to make this process a little easier. Once you have created a table in Excel 2013 you will be able to customize the design of that table, or filter it so that only some of the data appears in the table.įor the sake of this guide we will assume that you already have the data in your spreadsheet, and that the data has headers. The steps in this article are going to show you how to select data in a Microsoft Excel spreadsheet and convert it into a table. How to Create a Table in Excel 2013 (Guide with Pictures) Our Microsoft Excel add column tutorial can show you a simple way to get a total for the data in a column if you aren’t using a table. So continue below and find out how to make a table in Excel 2013. Our tutorial below will show you how to create a table from data in your spreadsheet, then customize the design of that data, filter it, or even convert it back into a standard range if you decide that you don’t need or don’t like the table layout. But occasionally you might have data that needs some additional formatting or filtering options, in which case it’s helpful to know how to make a table in Excel 2013. Our article continues below with additional information on how to make a table in excel 2013 and pictures of these steps, as well as information on formatting and filtering your table.Īdding data to a spreadsheet in Excel 2013 gives you the ability to sort data, edit it, and perform a number of different mathematical operations and functions on it. Check the box to the left of My table has headers (if it does) then click OK.Click the Insert tab at the top of the window.Select the cell data to turn into a table.6 See also How to Insert an Excel 2013 Table
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |