How to Convert Excel spreadsheet data into 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.
There are many benefits to working with Excel data in table form. This quick video focuses on the time-saving tip of formatting a spreadsheet. In January of 2017, I will be launching a 30-minute productivity series - 'Take CTRL of Your Time.'
Keep up-to-date with all my offerings by signing up for my newsletter at www.MOSTraining.com
Tags: How to Convert Excel spreadsheet data into a Table, Microsoft Office, Productivity, How to Excel, Excel Tips, Word Tips, Outlook tips, Donna Gilliland Microsoft Office Trainer