--- title: Quickly Format your data as a table description: Transform your data with ease by quickly converting it into an Excel Table. Discover the benefits and streamline your work with this simple trick. image: https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20shows%20a%20computer%20screen%20displaying%20a%20vibrant%20Excel%20spreadsheet%20with%20a%20dynamic%20table%20format%20The%20table%20is%20neatly%20organized%20with%20alternating%20ro.png --- [![logo](https://woodthorpeitsolutions.co.uk/hubfs/logo.png)](https://woodthorpeitsolutions.co.uk) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) - [Home](https://woodthorpeitsolutions.co.uk) - [Private Course](https://woodthorpeitsolutions.co.uk/private-courses) - [Public Course](https://woodthorpeitsolutions.co.uk/public-course-dates) - [Tips](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Contact us](https://woodthorpeitsolutions.co.uk/contact) [0800 044 3779](tel://08000443779) [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) # Quickly Format your data as a table [Woodthorpe IT](https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it) 18 November, 2025 ![](https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20shows%20a%20computer%20screen%20displaying%20a%20vibrant%20Excel%20spreadsheet%20with%20a%20dynamic%20table%20format%20The%20table%20is%20neatly%20organized%20with%20alternating%20ro.png) Highlight your data and press **Ctrl + T** to turn it into a dynamic **Excel Table**.  You’ll instantly get filter buttons, alternating row colours, and automatic range updates when you add new data.  Excel tables are also the gateway to many features you may use in the future, such as Power Query, Power BI and other online services. Before: ![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/image-png-Oct-23-2025-12-55-25-2391-PM.png?width=508&height=133&name=image-png-Oct-23-2025-12-55-25-2391-PM.png) After: ![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/image-png-Oct-23-2025-12-56-01-0096-PM.png?width=508&height=166&name=image-png-Oct-23-2025-12-56-01-0096-PM.png) If you want more tips on Excel Tables please comment below. Previous Post ###### [Flash Fill Magic (Ctrl + E)](https://woodthorpeitsolutions.co.uk/tips-and-news/flash-fill-magic) Next Post ###### [Quick Totals Without Formulas](https://woodthorpeitsolutions.co.uk/tips-and-news/quick-totals-without-formulas) ### Similar Blog Posts [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/A%20phone%20bashing%20Microsoft%20excel%20humerous.jpeg?width=352&name=A%20phone%20bashing%20Microsoft%20excel%20humerous.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/i-cant-type-a-phone-number-in-to-excel) #### [Ahhh, I can't type a phone number in to Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/i-cant-type-a-phone-number-in-to-excel) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Cartoon%20post%20it%20note%20with%20writing%20in%20it%20stuck%20on%20a%20computer%20screen.jpeg?width=352&name=Cartoon%20post%20it%20note%20with%20writing%20in%20it%20stuck%20on%20a%20computer%20screen.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/add-a-comment-to-a-cell-using-a-shortcut) #### [Add a comment to a cell using a shortcut](https://woodthorpeitsolutions.co.uk/tips-and-news/add-a-comment-to-a-cell-using-a-shortcut) [![](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/missing%20information%20cartoon%20spreadsheet-1.jpeg?width=352&name=missing%20information%20cartoon%20spreadsheet-1.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) #### [Highlight all blank cells in an Excel list quickly](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) [![Logo 290x70 - white](https://woodthorpeitsolutions.co.uk/hubfs/Logo%20290x70%20-%20white.png)](https://woodthorpeitsolutions.co.uk) Woodthorpe IT Solutions are providers of Microsoft 365 training and consultancy.  Established in 2005 we have trained over 10k people and continue to help learners get the most from their computer. [Want to resell our courses?  Click here to learn more.](https://woodthorpeitsolutions.co.uk/reseller) [Follow us on LinkedIn](https://www.linkedin.com/company/woodthorpe-it-solutions/) [Follow us on YouTube](https://www.youtube.com/@WoodthorpeITSolutionsLtdBlacon) ###### Get In Touch 0800 044 3779 contactus@woodthorpeit.com ##### Company details Co number: 05572129 Vat number: 936 2824 09 ##### Trust [Privacy Notice](https://woodthorpeitsolutions.co.uk/privacy-notice) [Terms](https://woodthorpeitsolutions.co.uk/terms) [Slavery and Human Trafficking Statement](https://woodthorpeitsolutions.co.uk/slavery-and-human-trafficking-statement) Copyright © 2026 Woodthorpe IT Solutions Limited ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Woodthorpe IT", "url" : "https://woodthorpeitsolutions.co.uk/tips-and-news/author/woodthorpe-it" }, "dateModified" : "2025-11-18T11:00:00.973Z", "datePublished" : "2025-11-18T11:00:00.000Z", "headline" : "Quickly Format your data as a table", "image" : [ "https://woodthorpeitsolutions.co.uk/hubfs/AI-Generated%20Media/Images/The%20image%20shows%20a%20computer%20screen%20displaying%20a%20vibrant%20Excel%20spreadsheet%20with%20a%20dynamic%20table%20format%20The%20table%20is%20neatly%20organized%20with%20alternating%20ro.png" ], "mainEntityOfPage" : { "@id" : "https://woodthorpeitsolutions.co.uk/tips-and-news/quickly-format-your-data-as-a-table", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject" } } } ```