Format tables and sheets

- [Voiceover] In this movie we're going…to shift our focus to working…with tables because there are advantages…to taking your data on a worksheet…and putting it into a table.…Not just formatting but filtering options…that we're going to look at,…as well as formatting your entire worksheets.…And we're going to continue working with this,…our Landon Hotel sheet.…"LH_sheet0305" if you're skipping to this movie…and you need to get caught up.…Let's go to the "GoalSeek" tab down below and click there.…Here we have some data just sitting on our worksheet…and you can see a lot of it is employee information…from column A through H and as we scroll down…with the scroll bar here on the right hand side…it goes way down past 740 rows.…

So lots of data to work with here.…If we put this into a table it becomes a little bit easier…to format and filter.…Now one option would be to click and drag across the range.…Let's start at A2,…click and drag across to column H and down.…Now we could go down 742 rows.…Or just release up here at the top…