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.
-
- Excel slicers: Filter data in PivotTable or Excel Table
- The Ultimate Guide to Excel's Format Painter (3 Examples)
- How to use Excel advanced filter - A full guide with examples
- 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
-
- 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 specify date or datetime format in header or footer?Hello, Estefania To make the month in the date appear in uppercase, you can use the UCase function in VBA to convert the month to uppercase. Hereβs how you can modify your code: Sub add_date_header() ...2 hours agoskyyang posted a comment in Revolutionize Data Analysis: Integrate ChatGPT to Excel for Smarter InsightsHello, Anand The error message may have appeared because the $5 free credit in your account has been exhausted, leading to the system no longer supporting the 4.0 model. It is advisable to switch to...2 hours agocrystal posted a comment in How to insert a date picker in emails in Outlook?Hi Dave, To solve this problem, please follow the instruction of step 3 and 4 to enable the Microsoft Word 16.0 Object Library option in the Microsoft Visual Basic for Applications window. ...5 hours agocrystal posted a comment in Kutools for Excel: Powerful Excel ToolboxHi TuKools, Your comment wasn't deleted. Due to a delay in our commenting system, your message might not appear immediately. I've reported your issue to the relevant department again, and we will of...5 hours agocrystal posted a comment in Easily find all combinations that equal a given sum in ExcelHi Giuseppe, Sorry for the inconvenience. If your original data doesn't contain any duplicates, then duplicate values cannot be generated from it. Creating duplicate values for the same number would ...23 hours agoJordan Z posted a comment in How to change chart axis labels' font color and size in Excel?If the chart isn't dynamic, by which I mean, if the data set isn't going to change in the future, then you might try changing the line's fill colour to a vertical gradient. Set one side to green, and ...about 2 days agoRidwan posted a comment in How to save each page as separate pdf files in a Word document?How to set output File Name base on footer each page?about 2 days agoMUHAMMAD erfan posted a comment in Insert Emojis / Smiley Face in Outlook (Desktop, Web & Mobile)Bravo !!!ππabout 2 days agoEstefania posted a comment in How to specify date or datetime format in header or footer?Hi, how can I change to upper case the month? I tried a few things but doesn't work :(about 3 days agoJohn W Sandman posted a comment in How to rename multiple worksheets in Excel?Hi, I am trying to rename tabs but the rename function in the dropdown list is grey and I have no idea how to activte it. Please help. Regards Johnabout 4 days ago