Subtitles section Play video Print subtitles Here's how to make a table in Microsoft Excel. A table is a specific set of rows and columns that you can apply functions to, such as adding filters, formatting or creating graphs. Let's turn our buying report for our fashion. Start up into a table. First, highlight the cells you want to add to your table. Click on insert, then click on table. If your cells include headings, check the my table has headers box, then click OK, your cells will now be turned into a table. Yeah, on the top right corner of the screen. Under the table section, you'll see a Siris of colored designs. Choose the one you like, and you'll see your table change. You can expand the size of your table by amending the number of columns or rows in it. To do this, hover your cursor over the bottom right corner of the table on click and drag the black narrowed square across the columns or rows. You want to be added to your table. The sort and filter features on tables helped organize your data. Click on the drop down arrow next to one of the headings. A pop up will appear next two sorts. Click on Ascending. The table will now be arranged in ascending order of retail prices. Now use the filter function by uncheck ing, one of thes boxes. This will hide all the items on the table that are $182.50.
B1 table click ascending filter excel corner How To Make A Table In Excel 6 1 林宜悉 posted on 2020/12/15 More Share Save Report Video vocabulary