COUNTIF copy and pastevalue COUNTIF function can be used when calculating how many same date is exists or checking same data is no duplicated. However, this function makes your computer slow because it re-calculates every time the sheet is…

This macro filter for blanks or non-blanks by one click. I take "Split" function just I learned and array for this macro. You will see how to get the range of the AutoFilter, and this made my macro works on any Excel books

You can select cells from the the first to the end if press Ctrl + Shift + Arrow key. However, if there is a blank cell or cells are merged, you cannot reach to the end. This macro reaches the end cell even if there are hundreds of blank c…

You can adjust the row height or the column width by one click if you create the macros and add them to the Ribbon. Write the macro on the Personal Macro Book thus you can use them on any Excel files.

Adding a row or a columns is just one sentence of code. Set it to the ribbon and use them anytime.

Set your macros on the ribbon and you can use them anytime. That makes your work speeding up and reducing stress!