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.
-
- Google AI Studio API key: Creating, Pricing and Limits
- How to Calculate Z Scores in Excel: A Comprehensive Guide
- Mastering Excel print area: how to set, adjust, clear and more
- Remove Excel Password from Excel file/Worksheets/Workbook Structure
- Easily remove blank cells in Excel – Full tutorial
- Mastering Nested IF Statements in Excel – A Step-by-Step Guide
- Excel Variance Calculation: A Guide with Examples
- Descriptive statistics in Excel (Quick and easy guide)
- Data table in Excel: Create one-variable and two-variable data tables
- What does the & Sign Mean in Excel formula? (Examples)
-
- 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 How to force text string to uppercase / lowercase / proper case in Excel?Hello, DS, To apply the code to a specified range instead of entire worksheet, please apply the following code: VBA code: Force text string to uppercase Private Sub Worksheet_Change(ByVal Target As Ra...about 3 days agocrystal posted a comment in How to automatically send email based on cell value in Excel?Hi Ernesto, The following VBA code may help. Please give it a try. Thank you. Note: If a change is detected and the new value in an "E" row cell is less than its corresponding "D" row cell, it trigge...about 3 days agocrystal posted a comment in How to send a specific chart in an email with vba in Excel?Hi Jyoti, Can you tell me what version of Excel you are using? The code works fine whether I change .Display to .Send or not.about 4 days agoMatthew Reynolds posted a comment in How to select a column based on the column header in Excel?Good job, works great!about 4 days agoMichael Lacroix posted a comment in How to insert color coded drop down list in Word table?hello . i tried but it not go.about 4 days agoTukools posted a comment in Kutools for Excel: Powerful Excel ToolboxHow do I change the location of the automatically created C:\Users\YOUR-USER-NAME\Documents\Kutools for Excel folder? Or how do I prevent Kutools from ever creating it? I keep deleting that folder...about 4 days agoOFFshacom posted a comment in How to recover the table auto-expand feature in Excel?I have applied the steps but still don't work. Someone please help me thxabout 4 days agoKAne posted a comment in How to combine date and time columns into one column in Google sheets?Work like a charm. . .. Basic always win Thanksabout 4 days agoVictor John Augustin posted a comment in How to swap or switch text around within one cell in Excel?Very good..about 5 days agoDS posted a comment in How to force text string to uppercase / lowercase / proper case in Excel?Please suggest modifications in the VBA code to force the text strings to change to the desired format (Upper/Lower/Proper case) in selected/specified cells only rather than changing the Case of the t...about 5 days ago