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.
-
- 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
- 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
-
- 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
-
crystal posted a comment in Use COUNTIF on a non-contiguous range in ExcelHi Miriam, Regarding the formula =SUM(COUNTIF(INDIRECT({"B5:B12","D5:D14","F7:F11"}),">80")) not working, the reason could be: INDIRECT and Arrays: The INDIRECT function is used to convert text stri...2 minutes agoskyyang posted a comment in Easily generate mutiple QR codes in bulk in ExcelHello, Jiri, Once you have inserted the QR codes, to remove them, you just need to click to select one, and then press the Delete key on the keyboard. Please have a try, thank you!15 minutes agoskyyang posted a comment in Revolutionize Data Analysis: Integrate ChatGPT to Excel for Smarter InsightsHello, Sam, This error message indicates that you hit your monthly [usage limit](/account/limits) for the API, or for prepaid credits customers that you've consumed all your credits. Please go to th...21 minutes agocrystal posted a comment in Easily vlookup values from bottom to top in ExcelHi Abdul Daim, Our feature does not support finding values across multiple workbooks. If you want to lookup values from different workbooks, the second method in this tutorial may do you a favor: Loo...22 minutes agocrystal posted a comment in Kutools for Excel: Powerful Excel ToolboxHi, Are these files located on a SharePoint server? Our feature currently does not support files on this network path. You can install the latest version of Kutools for Excel and copy the relevant fi...28 minutes agoEliz posted a comment in How to remove only text from cells that containing numbers and texts in Excel?The issue I encountered was the slowdown of my Excel upon opening.18 hours agoAlex posted a comment in How to combine date and time columns into one column in Google sheets?It doesn't work. Please try this =concatenate(text(A2;"mm/dd/yyyy")&" "&text(B2;"hh:mm:ss"))18 hours agoJiri posted a comment in Easily generate mutiple QR codes in bulk in ExcelHello, thank you very much, it works just fine. I just have not managed how to delete the QR code once inserted, can you tell me how to do that please?18 hours agoJackie Nierman posted a comment in Outlook: Show calendar as busy, free, tentative, and out of officeI would like to have default Show As: Free, not as Busy. Microsoft/Outlook/Calendar/Appointments1 day agoNatalie March posted a comment in How to insert page break every x rows in Excel?Hello, Why is it limited to number. If my spreadsheet has more than 1000 rows it will not complete the page breaks for all rows after that point. Thanks1 day ago