Blogs

Tip of the Week - Create a Table in Excel

By ILTA Tips posted 12-14-2015 15:00

  

Create a Table in Excel

When you create a table in Excel, it gives you added functionality: 

  • Freezes the top row (making it stay in place as you scroll down)
  • Automatically applies filters to your data
  • Allows you to quickly and easily format your data.  (Hint:  Before converting your data to a table, ensure that there are no blank rows or columns.)
  1. Highlight all of your data by clicking anywhere inside of it and pressing Ctrl + A.
  2. Press Ctrl + T.
  3. Click OK.
0 comments
23 views

Permalink

https://iltanet.org/blogs/ilta-tips/2015/12/14/tip-of-the-week-create-a-table-in-excel