Switch or Transpose Row And Column Data in MS Excel
Quickly interchange or swap data from row to column and Switch or Transpose Row And Column Data option in paste special and reference functions Excel.
Quickly interchange or swap data from row to column and Switch or Transpose Row And Column Data option in paste special and reference functions Excel.
Table of Contents is an important command which is used to add, delete and update one or more text which you want to display in TOC.
To stop spelling and grammar errors, autocorrect or fix the wrong words and punctuation mistakes with the enable Auto Correct option.
help of Data Validation Prepare Sheet Using Restrictions on Each Columns in Excel. You can make Restrictions on Columns by Data Validation.
You draw a line through a text from strikethrough text facility? Word will adds single or double horizontal lines through the middle of selected text
Use tips to quickly find your current age using DATEDIF function from the birth date till current date in Excel.
If you want to count white spaces in a text string then you must read this article-How to count total White Spaces in Text String.
Use Data Validation and VLookup Function in MS Excel to create drop-down list menus by Data Validation and search any specific value.
In this article you will be able to Highlight Current Month Birthdays in Excel you can send greeting messages to congratulate staff members.
Nested IF, AND, OR statements are very popular logical functions in MS Excel.. You can use Nested IF function with OR function in MS Excel