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.
-
- Add line numbers in Word – A step-by-step guide
- 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 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)
-
- 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
-
skyyang 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,...19 hours 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...19 hours agoskyyang posted a comment in How to list all files in folder and subfolders into a worksheet?Hello, Johnny, To list all filenames in a folder and subfolders, and create hyperlinks to these files in an Excel worksheet, please apply the following code: Sub ListFilesAndCreateHyperlinks() Dim...19 hours agoskyyang posted a comment in How to duplicate rows based on cell value in a column?Hello, Charies, Yes, as you said, the code will not work if there are blank rows in the data range. To solve this issue, please apply the below modified code: Sub CopyData() ' Update by Extendoffi...19 hours agoThang posted a comment in How to protect cells based on date in Excel?i want to automatically move data (file A) on a column or a row to another file(file B), but when B file is in closed state, code can't work. how can i do it without open B file please help meabout 3 days agobambi douglas posted a comment in Release Notes – Kutools for Excel 30.00having issues with the delete web controls - its not functioning anymore another issue since upgraded version (proper term?) is that this version is extremely sluggish..What has happened?...about 3 days agoREGINA TAKEKO YABIKU TAVONE posted a comment in How to add daily/weekly/monthly/yearly reminder in Outlook?Thank you very much for the tip! I followed your instructions and it was very quick to remember! Helpful and instructive!about 3 days agoPaltiel Agbaji posted a comment in How to sort rows to put the blank cells on top in Excel?Great Post thanks so muchabout 3 days agoEmily posted a comment in Excel Tips: Split data into multiple worksheets / workbooks based on column valueHi, is it possible to use a VBA code to split data into multiple files - not just tabs?about 4 days agoJohnny posted a comment in How to list all files in folder and subfolders into a worksheet?Is it possible to combine this with your other VBA to include hyperlinks? e.g. hyperlinks to all files in a folder including subfolders?about 4 days ago