--- 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) - [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) [![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) [![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) [![Selecting Words, Sentences and Paragraphs quickly in Word](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/AI-Generated%20Media/Images/A%20vibrant%20digital%20workspace%20is%20depicted%20showcasing%20a%20computer%20screen%20filled%20with%20a%20Microsoft%20Word%20document%20The%20document%20contains%20neatly%20formatted%20text%20with%20highlighted%20sections%20indicating%20selected%20words%20and%20sentences%20The%20background%20is%20a%20soft%20gradient.jpeg?width=400&upsize=true&name=A%20vibrant%20digital%20workspace%20is%20depicted%20showcasing%20a%20computer%20screen%20filled%20with%20a%20Microsoft%20Word%20document%20The%20document%20contains%20neatly%20formatted%20text%20with%20highlighted%20sections%20indicating%20selected%20words%20and%20sentences%20The%20background%20is%20a%20soft%20gradient.jpeg)](https://woodthorpeitsolutions.co.uk/tips-and-news/selecting-words-sentences-and-paragraphs-quickly-in-word) ##### [Selecting Words, Sentences and Paragraphs quickly in Word](https://woodthorpeitsolutions.co.uk/tips-and-news/selecting-words-sentences-and-paragraphs-quickly-in-word) Please see below two really quick ways to select text in a Word Document: - **To select a word** -... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/selecting-words-sentences-and-paragraphs-quickly-in-word) [![Summarise any web page with Copilot in Edge](https://woodthorpeitsolutions.co.uk/hs-fs/hubfs/image-png-Jun-23-2025-11-07-35-9312-AM.png?width=400&upsize=true&name=image-png-Jun-23-2025-11-07-35-9312-AM.png)](https://woodthorpeitsolutions.co.uk/tips-and-news/summarise-any-web-page-with-copilot-in-edge) ##### [Summarise any web page with Copilot in Edge](https://woodthorpeitsolutions.co.uk/tips-and-news/summarise-any-web-page-with-copilot-in-edge) If you are researching and reading lots of complex websites, you can ask Copilot in the Edge... [Read More](https://woodthorpeitsolutions.co.uk/tips-and-news/summarise-any-web-page-with-copilot-in-edge) [![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