--- title: Tips and News | Excel description: Excel | Microsoft Office Tips and news to help keep you in the know and save time. --- [![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) Tips and News # Stay up to date and learn new things [Discover More](https://www.hubspot.com/) [Get Started](https://www.hubspot.com/) - [Home](https://www.hubspot.com/) - Blog Topic # Excel excel - [All Post](https://woodthorpeitsolutions.co.uk/tips-and-news) - [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) - [Word](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/word) - [PowerPoint](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/powerpoint) - [Outlook](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/outlook) - [Mobile working](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/mobile-working) - [Windows](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/windows) - [Mobile Applications](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/mobile-applications) - [OneDrive](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/onedrive) - [Strategy](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/strategy) - [AI](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/ai) - [CoPilot](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/copilot) - [Office 365](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/office-365) - [Chrome](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/chrome) - [Edge](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/edge) - [Power Query](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/power-query) Search ###### Categories - [Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/excel) - [Word](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/word) - [PowerPoint](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/powerpoint) - [Outlook](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/outlook) - [Mobile working](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/mobile-working) - [Windows](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/windows) - [Mobile Applications](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/mobile-applications) - [OneDrive](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/onedrive) - [Strategy](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/strategy) - [AI](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/ai) - [CoPilot](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/copilot) - [Office 365](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/office-365) - [Chrome](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/chrome) - [Edge](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/edge) - [Power Query](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/power-query) ###### Popular Posts - [OOPS I LEFT MY CAPS LOCK ON](https://woodthorpeitsolutions.co.uk/tips-and-news/oops-i-left-my-caps-lock-on) - [Import multiple Excel or CSV files in to Excel using Power Query](https://woodthorpeitsolutions.co.uk/tips-and-news/import-multiple-excel-or-csv-files-in-to-excel-using-power-query) - [Quick Totals Without Formulas](https://woodthorpeitsolutions.co.uk/tips-and-news/quick-totals-without-formulas) - [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) - [Selecting Words, Sentences and Paragraphs quickly in Word](https://woodthorpeitsolutions.co.uk/tips-and-news/selecting-words-sentences-and-paragraphs-quickly-in-word) [![Clean up data fast with Find & Replace](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Stock%20Images/hazel-z-FocSgUZ10JM-unsplash.jpg?width=400&upsize=true&name=hazel-z-FocSgUZ10JM-unsplash.jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-data-fast-with-find-replace) ##### [Clean up data fast with Find & Replace](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-data-fast-with-find-replace) If you ever receive spreadsheets from other systems or people, you’ve probably seen inconsistent... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-data-fast-with-find-replace) [![Customize the Quick Access Toolbar to work faster](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Stock%20Images/john-FlPc9_VocJ4-unsplash%20(1).jpg?width=400&upsize=true&name=john-FlPc9_VocJ4-unsplash%20(1).jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/customize-the-quick-access-toolbar-to-work-faster) ##### [Customize the Quick Access Toolbar to work faster](https://woodthorpeitsolutions.co.uk/tips-and-news/customize-the-quick-access-toolbar-to-work-faster) The Quick Access Toolbar (QAT) is a small toolbar at the top of Word, Excel, or PowerPoint that... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/customize-the-quick-access-toolbar-to-work-faster) [![Save time when entering dates and times in Excel](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Stock%20Images/kobu-agency-7okkFhxrxNw-unsplash.jpg?width=400&upsize=true&name=kobu-agency-7okkFhxrxNw-unsplash.jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/save-time-when-entering-dates-and-times-in-excel) ##### [Save time when entering dates and times in Excel](https://woodthorpeitsolutions.co.uk/tips-and-news/save-time-when-entering-dates-and-times-in-excel) If you regularly log updates, track tasks, or note when something was completed, typing the date... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/save-time-when-entering-dates-and-times-in-excel) [![Fill formulas down in seconds](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Stock%20Images/campaign-creators-pypeCEaJeZY-unsplash.jpg?width=400&upsize=true&name=campaign-creators-pypeCEaJeZY-unsplash.jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/fill-formulas-down-in-seconds) ##### [Fill formulas down in seconds](https://woodthorpeitsolutions.co.uk/tips-and-news/fill-formulas-down-in-seconds) If you’ve ever dragged a formula down hundreds (or thousands) of rows, you’ll know how fiddly... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/fill-formulas-down-in-seconds) [![Clean Up Messy Text Fast](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20clean%20modern%20workspace%20with%20a%20sleek%20laptop%20open%20to%20an%20Excel%20spreadsheet%20displaying%20a%20list%20of%20text%20entries%20The%20cells%20contain%20vario.png?width=400&upsize=true&name=The%20image%20features%20a%20clean%20modern%20workspace%20with%20a%20sleek%20laptop%20open%20to%20an%20Excel%20spreadsheet%20displaying%20a%20list%20of%20text%20entries%20The%20cells%20contain%20vario.png)](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-messy-text-fast) ##### [Clean Up Messy Text Fast](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-messy-text-fast) If your imported text looks odd, Excel has clean-up formulas that fix it in seconds: - **=TRIM(A1)**... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/clean-up-messy-text-fast) [![Quick Totals Without Formulas](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20computer%20screen%20displaying%20an%20open%20Excel%20spreadsheet%20filled%20with%20numerical%20data%20in%20various%20cells%20At%20the%20bottom%20right%20corner%20of%20th.png?width=400&upsize=true&name=The%20image%20features%20a%20computer%20screen%20displaying%20an%20open%20Excel%20spreadsheet%20filled%20with%20numerical%20data%20in%20various%20cells%20At%20the%20bottom%20right%20corner%20of%20th.png)](https://woodthorpeitsolutions.co.uk/tips-and-news/quick-totals-without-formulas) ##### [Quick Totals Without Formulas](https://woodthorpeitsolutions.co.uk/tips-and-news/quick-totals-without-formulas) Need a quick sum, average, or count from your data  without any hassle?  - Just highlight your... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/quick-totals-without-formulas) [![Quickly Format your data as a table](https://woodthorpeitsolutions.co.uk/hs-fs/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?width=400&upsize=true&name=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)](https://woodthorpeitsolutions.co.uk/tips-and-news/quickly-format-your-data-as-a-table) ##### [Quickly Format your data as a table](https://woodthorpeitsolutions.co.uk/tips-and-news/quickly-format-your-data-as-a-table) Highlight your data and press **Ctrl + T** to turn it into a dynamic **Excel Table**. You’ll instantly get... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/quickly-format-your-data-as-a-table) [![Flash Fill Magic (Ctrl + E)](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/The%20image%20features%20a%20computer%20screen%20displaying%20an%20Excel%20spreadsheet%20The%20focus%20is%20on%20a%20column%20where%20a%20user%20has%20entered%20a%20few%20full%20names%20and%20next%20to%20it.png?width=400&upsize=true&name=The%20image%20features%20a%20computer%20screen%20displaying%20an%20Excel%20spreadsheet%20The%20focus%20is%20on%20a%20column%20where%20a%20user%20has%20entered%20a%20few%20full%20names%20and%20next%20to%20it.png)](https://woodthorpeitsolutions.co.uk/tips-and-news/flash-fill-magic) ##### [Flash Fill Magic (Ctrl + E)](https://woodthorpeitsolutions.co.uk/tips-and-news/flash-fill-magic) If you ever spend time retyping patterns of information like splitting full names into first and... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/flash-fill-magic) [![Look at the same file more than once](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/Multiple%20windows%20on%20a%20computer%20screen%20cartoon.jpeg?width=400&upsize=true&name=Multiple%20windows%20on%20a%20computer%20screen%20cartoon.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/look-at-the-same-file-more-than-once) ##### [Look at the same file more than once](https://woodthorpeitsolutions.co.uk/tips-and-news/look-at-the-same-file-more-than-once) Ever been in a large Word document and needed to look at two parts of it at the same time? Or a... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/look-at-the-same-file-more-than-once) [![Highlight all blank cells in an Excel list quickly](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/missing%20information%20cartoon%20spreadsheet-1.jpeg?width=400&upsize=true&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) If you need to highlight all the blank cells in an Excel list, you can use this simple shortcut: - ... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/highlight-all-blank-cells-in-an-excel-list-quickly) Load More ![Graduated Girl](https://woodthorpeitsolutions.co.uk/hubfs/raw_assets/public/@marketplace/MakeWebBetter/Academia/images/multipurpose/graduate.png) ## Want our tips straight to your inbox? Never miss an update. If you want to stay tuned with our latest tips and hacks then subscribe to our emails. Get all our updates delivered straight into your inbox. [Subscribe to our email](https://sibforms.com/serve/MUIFAAFCXDxGAMZeodM5k-3fyqYGzIOZWIM3lrz9241b8pAscOC17TwXpFMy0qym4dm5DYZr8jy_9PY1bmKOH6AU_xmo1uZPKlK4BACZ2TVAoLZWq-wWhN3ePHiliCE_kOVd1jlUoWivoRpLx8o_7FqN7RxoLUsmWwEL0sQP0MoKHUslTJ4aDOe7eLrhgCrkUt2rV56nCwqJ3I5G) [![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