From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Create and format tables

From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

Create and format tables

“

- [Instructor] Converting the data in a worksheet into a table makes it much easier to manage the data. After watching this video, you will know how to create an Excel table from a cell range. You'll also learn how to apply table styles, and how to convert tables to a cell range. Let's jump right in to our Create Tables workbook and look at the information on our Orders worksheet. and is very hard to manage without having a good structure for the data. Now by converting this into a table, we will have extra functions available to us such as sorting and filtering the information and easily applying a style to the information to make it easier to read. To create a table from a range of data, we first select a range. I'll select the column headings and use control+shift+down-arrow to select all of the records in this worksheet. We'll then go to Insert table. Now there's also a very good keyboard shortcut control+T which will quickly take you into this window where you can confirm that the cell range is correct and just watch the marquee around the selection and make sure that you've included your column headings. And we also want to make certain that my table has headers is checked. All of that looks good, let's click OK. And here's our new table. Very bright, kind of matches our logo which is good. But it might be easier to read if we were to tone it down just a little bit. On our Table Tools Design tab, we have some great table styles that we can apply and as long as you're clicked anywhere within the table, you'll have your Design tab available to you. Let's use the down arrow and go in and look at our other styles we can apply. As we mouse over these, you'll see the instant preview of what it would look like if you were to apply that specific formatting. I like this one because it has banded rows where the rows go from green to white to green and it makes it a little easier to read the data. I'll select that. So we've created our table and we've applied a table style, what if you want to convert this table back into a regular range of cells? We can do that on our Table Tools Design tab, Convert to Range, this will convert it back to a normal range of cells and will also remove the filter buttons on each column but will maintain the formatting that you currently see. Let's go ahead and click Convert to Range. You'll always receive a question confirming that you really do want to convert the table. We'll say yes. And that quickly, what was our table has now become just a normal range of cells within our workbook. within our workbook.

Contents