In this article, we will learn the MsgBox function in Excel VBA, Following are the buttons argument settings of msgbox vba: Constant Value De...
In Microsoft Excel,we can sort the data by using the AutoFilter sort’s data according to specific sort order rules. We can sort the number data a...
In this article, we will learn how we can allow multiple users to edit the ranges in Microsoft Excel. From the Tools menu, select Protection, and t...
In this article we will learn how to find the duplicate items in combined columns. To find duplicate items we use the “COUNTIF” and “IF” form...
File Menu: * Excel 2002: Search, and a new Search icon on the regular Standard toolbar. * Excel 2003: File Search. The File Search icon does not app...
To let Excel read text for you: 1. Select a range of cells. 2. From the Tools menu, select Speech and then Show Text To Speech Toolbar. 3. Click the l...
In this article, we have created a macro to highlight duplicate values. Raw data consists of different car names. We want to highlight duplicate entr...
Selecting special cells in a sheet, for example, cells containing Constants, Formulas, blank cells, and more, enables you to copy, move, delete, color...
New menu items, cell shortcut menu items and keyboard shortcuts: * In the File menu: File Search and Permission * In the View menu: Keyboard short...
In this article, we are going to learn how to calculate the sum across the multiple sheets in Microsoft Excel. Let’s take an example and understand...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
