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.
Latest Articles
- How to create a drop-down list for subjects in Outlook?
- How to automatically fill email subject with attachment name in Outlook?
- How to get attachments from an email chain or thread in Outlook?
- How to mass mark all emails as read in one or all folders in Outlook?
- How to open an PST file without an email account in Outlook?
- How to change delimiter when saving Excel file as CSV?
- How to auto outline data in Excel?
- How to create nested column groups in Excel?
- How to count filtered cells with text in Excel?
- How to insert a line break in a cell after a specific character?
Most Read
- 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 print ranges in Excel?
- How to add text to the beginning or end of all cells in Excel?
- How to count and sum cells based on background color in Excel?
- How to combine multiple workbooks into one master workbook in Excel?
- How to quickly apply formula to an entire column or row with/without dragging in Excel?
- How to convert birthdate to age quickly in Excel?
- Merge and Combine Columns without Losing Data in Excel
- How to extract text before/after space or comma only in Excel?
Latest Comments
skyyang posted a comment in How to insert page breaks when value changes in Excel?
Hello, Lê Tuấn
To solve your problem, please apply the below VBA code:
Sub insertpagebreaks()
'updateby Extendoffice
Dim I As Long, J As Long
Dim xRg As Range
On Error Resume Next
J = ActiveSheet.Cel...
1 day ago
skyyang posted a comment in How to convert url text to clickable hyperlink in Excel?
Hello, Tosetti
To solve your problem, please apply the below code: (First, you should select the hyperlink texts)
Sub ConvertToHyperlinks()
'Updateby Extendoffice
Dim Rng As Range
Dim WorkRng As Ra...
1 day ago
crystal posted a comment in How to record changing values in a cell in Excel?
Hi Erdal matpay,
Sorry I misunderstood you in the first reply. The following code can help.
After removing some records, new records will start from the cells you cleared. Please give it a try.
Dim ...
1 day ago
skyyang posted a comment in How to send / email range of cells through outlook from Excel?
Hello, pawerl
To solve your problem, the below article may help you, please check it:
https://www.extendoffice.com/documents/excel/7178-send-each-sheet-to-different-email.html
Thank you!...
1 day ago
Sunny posted a comment in How to remove trailing zeros from number in Excel?
Hi, Gunnar Dahlmann, the formula provided in this tutorial is working at English Excel version, you need to change it to the local formula if you use it in non-English version. Thanks for your reminde...
1 day ago
Sunny posted a comment in Excel: How to expand cell to show all contents when click
Hi, do you want to show all contents of the selected cells to the textbox? Or just supports to select cells but show contents of the first one cell of the selection?
1 day ago
crystal posted a comment in How to record changing values in a cell in Excel?
Hi Erdal matpay,
The following VBA code can acheive: when clearing the value in C2, all the records you made before are also cleared together, and the new records will start from cell D2 again. Please...
1 day ago
crystal posted a comment in How to disable or do not allow Save & Save As options in Excel?
Hi Rochelley,
Thank you for your feedback. The VBA code has been updated as follow. You need to:
1. Press the Alt + F11 keys to open the Visual Basic editor.
2. In the Visual Basic editor, double clic...
1 day ago
Sunny posted a comment in How to look up a value and return the cell above or below in Excel?
Hi, Paulo, if all your data is in a row, and each of them in a single cell, you can try this formula: =INDIRECT(CELL("address",INDEX(A1:J1,MATCH(MIN(A1:J1),A1:J1,0)+1))), if your data is in to columns...
1 day ago
Sunny posted a comment in How to rename all images names in a folder according to a list of cells in Excel?
Hi, edvin.I G Lazar, I have tested the code, it can rename all pictures you list, if it only rename first 10 of the folder, please check what is the picture type, the suffix, in the first code, it jus...
1 day ago
