--- title: Tips and News | Woodthorpe IT (3) description: Microsoft Office Tips and news to help keep you in the know and save time. (3) --- [![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 ### Woodthorpe IT All Post - [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) - [OneDrive](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/onedrive) - [Outlook](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/outlook) - [Mobile working](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/mobile-working) - [Strategy](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/strategy) - [Windows](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/windows) - [Mobile Applications](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/mobile-applications) - [Office 365](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/office-365) - [AI](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/ai) - [CoPilot](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/copilot) - [Cybersecurity](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/cybersecurity) - [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) - [OneDrive](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/onedrive) - [Outlook](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/outlook) - [Mobile working](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/mobile-working) - [Strategy](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/strategy) - [Windows](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/windows) - [Mobile Applications](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/mobile-applications) - [Office 365](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/office-365) - [AI](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/ai) - [CoPilot](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/copilot) - [Cybersecurity](https://woodthorpeitsolutions.co.uk/tips-and-news/tag/cybersecurity) - [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) [![Duplicate slides quickly in PowerPoint](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Stock%20Images/campaign-creators-gMsnXqILjp4-unsplash%20(1).jpg?width=400&upsize=true&name=campaign-creators-gMsnXqILjp4-unsplash%20(1).jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/duplicate-slides-quickly-in-powerpoint) ##### [Duplicate slides quickly in PowerPoint](https://woodthorpeitsolutions.co.uk/tips-and-news/duplicate-slides-quickly-in-powerpoint) Building a presentation often means creating multiple slides with the same layout — for example, a... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/duplicate-slides-quickly-in-powerpoint) [![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) [![Preview your slideshow from the current slide](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Stock%20Images/austin-distel-rxpThOwuVgE-unsplash.jpg?width=400&upsize=true&name=austin-distel-rxpThOwuVgE-unsplash.jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/preview-your-slideshow-from-the-current-slide) ##### [Preview your slideshow from the current slide](https://woodthorpeitsolutions.co.uk/tips-and-news/preview-your-slideshow-from-the-current-slide) When you’re working on a presentation, it can be frustrating to keep starting the slideshow from... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/preview-your-slideshow-from-the-current-slide) [![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) [![Select text in Word without dragging your mouse](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/thisisengineering-uyfohHiTxho-unsplash.jpg?width=400&upsize=true&name=thisisengineering-uyfohHiTxho-unsplash.jpg)](https://woodthorpeitsolutions.co.uk/tips-and-news/select-text-in-word-without-dragging-your-mouse) ##### [Select text in Word without dragging your mouse](https://woodthorpeitsolutions.co.uk/tips-and-news/select-text-in-word-without-dragging-your-mouse) Dragging your mouse to select text can be slow and fiddly, especially in long documents. Word has... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/select-text-in-word-without-dragging-your-mouse) [![Split messy data into neat columns with Text to Columns](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/Portrait%20of%20a%20happy%20female%20student%20using%20laptop%20computer%20in%20university.jpeg?width=400&upsize=true&name=Portrait%20of%20a%20happy%20female%20student%20using%20laptop%20computer%20in%20university.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/split-messy-data-into-neat-columns-with-text-to-columns) ##### [Split messy data into neat columns with Text to Columns](https://woodthorpeitsolutions.co.uk/tips-and-news/split-messy-data-into-neat-columns-with-text-to-columns) If you’ve ever been given a spreadsheet where names, dates, or codes are all squashed into one... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/split-messy-data-into-neat-columns-with-text-to-columns) [![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) 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