How-tos - Sharing Tips and Tutorials for Microsoft Office
Author: Tech Support
Last Modified: 2023-02-28
Here we share the tips and tricks we know about Microsoft Office. It's sharing all those things that we learn and experience along the way of developing Office add-ins and using Microsoft Office.
-
- Start page numbering from specific page in Word – Easy tricks
- How to create a hanging indent in Word
- How to Easily Duplicate a Page in Word: Complete Guide
- Add line numbers in Word – A step-by-step guide
- Change margins in a Word document
- Insert Online or Offline video in Word document – 3 useful ways
- Insert Emoji in Microsoft Word: A Comprehensive Guide
- Quickly insert current date and time in Word – (Easy tricks)
- A Simple Method to Translate Text in Word
- How to insert a horizontal or vertical line in Word
-
- How to copy Excel page setup to other worksheets in Excel?
- How To Remove First, Last X Characters Or Certain Position Characters From Text In Excel?
- How to add text to the beginning or end of all cells in Excel?
- How to print ranges in Excel?
- Excel Tips: Count/sum cells by color (background, font, conditional formatting)
- How to apply a formula to an entire column in Excel (5 tricks)
- How to combine multiple workbooks into one master workbook in Excel?
- Calculate age (convert birthdate to age) quickly in Excel
- How to extract text before/after space or comma only in Excel?
- Merge and Combine Columns without Losing Data in Excel
-
Wally Nasser posted a comment in How to group and sort emails by month in Outlook?If you want to automate further, assign a button to the macro. There are 2 issues with the macro. 1. You have to select all. 2. The months don't sort correctly because there is no leading 0 for ...6 hours agocrystal posted a comment in How to insert a date picker in emails in Outlook?Hi, I'm very sorry, this issue occurred because macros were disabled after restarting Outlook. Please follow these steps to re-enable macros: Click on File > Options to enter the Outlook Options wind...21 hours agoSparkles posted a comment in Kutools for Excel: Powerful Excel ToolboxIs it possible to save complex formulas I use often somewhere in KuTools? i.e.: I have several instances where multiple formulas with nested functions (both built-in & KuTools), that I use in multiple...1 day agoILLA posted a comment in How to Select All Tables in Word document?How do i only select the tables and figure captions. All my captions have reverted back to normal style. I had captioned all of them but now they are all not linked to the caption1 day agoMike Bond posted a comment in Switch first & last names in Excel: An easy complete guideOutstanding help guide. I actually spetn 15 minutes before finally going into excel and asking the help there. 5 seconds. Great help guys. Not!about 2 days agoMike Bond posted a comment in Switch first & last names in Excel: An easy complete guideI have no clue what to do in any of the options. You might want to give exampls and type it in english rather than computer codeabout 2 days agoKatherine posted a comment in Split data into multiple worksheets by rows count in ExcelThanks a lot, you save my life :)about 2 days agoTheZupZup posted a comment in How to change the default browser in Outlook?thanks you you just save me from edge 😅. i just dont like edgeabout 2 days agoskyyang posted a comment in Quickly remove the prefixes such as FW / RE from selected email subjects in OutlookHello, Frost, This issue might be related to the Exchange account you are using. If you are using an Exchange account, please check the following option: Please have try, and if the problem persists,...about 2 days agoskyyang posted a comment in Excel Tips: Split data into multiple worksheets / workbooks based on column valueHello, Emily, To split data into multiple files, please apply the code in the second header of this article. https://www.extendoffice.com/documents/excel/1174-excel-split-data-into-multiple-worksheets...about 2 days ago