How to Convert Excel spreadsheet data into a Table
How to convert an Excel spreadsheet into a Table.
SPECIAL NOTE:
August 2022 NOTE: I created this video a few years back for Excel 2017 but it is still applicable to the newest version of Excel Office 365.
There are multiple data analysis benefits to converting your data to a Table. However, this quick video focuses only on the time-saving tip of the formatting benefits of conversion to a Table.
Save time formatting every other row of data in an Excel spreadsheet by converting the data into a list. Click in your list and press CTRL + T and click OK (older versions of Excel used CTRL + L). The table feature can also be accessed from the Insert ribbon. Once converted, every other row will be shaded. In the future, when you delete, add and/or insert rows and columns, the formatting will automatically adjust accordingly.
Keep up-to-date with all my offerings by signing up for my newsletter at www.MOSTraining.com