How-tos - Sharing Tips and Tutorials for Microsoft Office
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.
-
- Insert Emoji in Microsoft Word: A Comprehensive Guide
- Quickly insert current date and time in Word – (Easy tricks)
- How to insert a horizontal or vertical line in Word
- How to add a footnote and endnote in Word? (Full guide)
- Quickly add rows or columns to a table in Word document
- Delete a Page in Word: Remove Blank or Unwanted Pages efficiently
- Split and Extract Pages from Your Word Documents (4 Ways)
- Add a new blank page in Word document – 2 easy ways
- Excel borders: how to add, customize, remove and more
- Excel slicers: Filter data in PivotTable or Excel Table
-
- 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
-
Sunny posted a comment in Easily create mailing list and send emails in ExcelHello, I've tested and found that emails are sent successfully whether the theme is selected or not. Could you please send the specific details of your issue, along with relevant data and the environm...7 hours agoskyyang posted a comment in Easily generate mutiple QR codes in bulk in ExcelHello, If your version does not have the QR code feature, please download the latest version from the following link: https://www.extendoffice.com/download/kutools-for-excel.html Thank you!...12 hours agoArchana Navin posted a comment in How to vlookup and return matching value with cell comment?skyyang - Thank you, it worked for me. However, only my last comment gets pulled up. How do I get all the comments posted for the specific cell. Thanks, AN...1 day agoAqib posted a comment in Auto send recurring emails periodically in Outlook quickly and easily"I want to add bulk emails in to that list and they should automatically send, so I can focus on my other tasks."1 day agoKrisSKW posted a comment in How to run the same macro on multiple worksheets at same time in Excel?Hello, please help me how to apply this macro to multiple sheets, I can't figure it out Sub KropkaPrzecinek() Selection.Replace What:=".", Replacement:=".", LookAt:=xlPart, _ SearchOrder:...about 2 days agoSUSANTA DUTTA posted a comment in How to count the difference between letters in Excel?I JUST NEED ALPHABATE + NUMBER SERIAL WISEabout 2 days agoAbdussamet posted a comment in How to select cells with specific text in Excel?Thanks it helps a lotabout 2 days agoashique posted a comment in Quickly split or save each worksheet of one workbook as separate excel / txt / csv / pdf fileshow can i split workbook to Jpeg file?about 2 days agoseme4ka008 posted a comment in Quickly convert images to equations in Word"SimpleTex" is what you're looking forabout 2 days agoAmicus posted a comment in How to combine two or more tables into one in Word document?Unfortunately, it doesn't work for complex tables. In the case of the two tables with merged cells, it creates a mess. One table is placed over another.about 3 days ago