Excel 2016 – How to select smallest of multiple dates
Learn how to use Excel formulas to select the smallest date from a table in Excel 2016. Discover three methods to find the first date by name or in the…
Office 2016
Excel wont allow insert new rows
In an Excel document, learn how to troubleshoot and solve the issue when Excel won't allow inserting new rows due to either protected documents or table formatting. Find step-by-step solutions…
Excel 2016 – How to force a value in a formula
Learn how to prevent Excel from changing a cell's format, causing issues in your formulas. Discover the easy solution using the VALUE function to force a cell's value, no matter…
How to calculate percent of total using Microsoft Excel
Learn how to use Microsoft Excel to easily calculate the percentage of a total using simple formulas, whether you have the total in the same row or not. Discover step-by-step…
Word 2016 – Merge field codes always displayed
Learn how to fix the issue in Microsoft Word 2016 where merge fields are always displayed with their full code format. Find the solution by unticking "Show field codes instead…
Excel 2016 – How to edit worksheet header/footer
This article explains step by step process to edit worksheet header/footer in Excel 2016. It covers clicking on 'View' in the ribbon, selecting 'Page Layout', adding smart parts using 'Header…
Word 2016 – How to restrict/un-restrict formatting changes
Learn how to restrict or un-restrict formatting changes in Microsoft Word 2016 by enabling or disabling the "Restrict Editing" feature, setting a password, and adjusting the Formatting Restrictions settings.Meta Keywords:…
Excel – How to calculate the difference between two dates
Learn how to calculate the difference between two dates in Excel using the DATEDIF formula with different units such as days, months, years, days-ignoring years, days-ignoring months and years, months-ignoring…
Word 2016 – How to change text case
Learn how to easily change the text case in Microsoft Word 2016 using the keyboard shortcut Shift + F3. This will allow you to convert selected text from uppercase, lowercase…