Learn how to format a table in Excel.
- [Instructor] Now we're going to work with tables in Excel,…and it's pretty much the same as working…with tables in Word.…What we want to do is we want to highlight…all the cells that are going to make up our table,…go over here where it says Format as Table,…do a drop-down, and we're going to pick one…of these table styles.…You want to check the box that says My Table Has…Headers, and click OK.…And notice where we didn't have…a header in here, it filled one in for us.…We already have a Column One so we don't…want another Column One.…
Let's go ahead and call this Rows, okay?…The other thing we want to do with our table…just like we did in Word is we want…to make sure that the Header Row is checked…and you notice the first column isn't.…So we're going to go ahead and check First Column.…Now our table's formatted appropriately…so a person using a screen reader can navigate…the table in the spreadsheet.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Making hyperlinks more accessible
- How color impacts accessibility
- Using heading styles in Word and Excel
- Formatting tables in Word
- Naming sheet tabs
- Using slide layouts and fonts
- Adding captions to presentations