# Developerpublish.com how to use exel, tips & tricks excel

### Excel Ribbon and its Functions

**Details: **First, prepare an **excel** sheet with the required details in it. Now click on the Ribbon Display Options icon on the top-right corner of your **excel** sheet, which is beside the Minimize icon. Click on Auto-hide Ribbon option to hide all tabs and commands in the **excel** sheet. Click on the Show Tabs option to display the Ribbon tabs without the commands.

› Verified *Just Now*

› Url: https://developerpublish.com/excel-ribbon-and-its-functions/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Get and Set Cell Value in Microsoft Excel VBA

**Details: **To get and set cell value in **excel** VBA, we can use the Value property of the Range or Cells object. Set Cell Value. Using the Value property of the Range or Cells object, we can set cell value. Set Cell Value using Range.Value. To set a cell value using Range.Value, Code: Range("A2").Value = 1.

› Verified *5 days ago*

› Url: https://developerpublish.com/get-and-set-cell-value-in-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Task Panes in Excel

**Details: **First, prepare an **excel** sheet with the required details in it. To access Task panes , insert a picture > click on Picture Tools Format > then on Format Picture. The Format Picture Task pane opens up. In the below picture, you can see the options available in Format Picture Task Pane. Choose an option from Format Picture Task Pane to format your

› Verified *9 days ago*

› Url: https://developerpublish.com/task-panes-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Find Cell that Contains Specific Text in Excel

**Details: **The following steps will explain the work of Cell contains Specific Text in **Excel**: First, prepare an **excel** sheet with the required details in it. To find the position of a substring in a text string, use the SEARCH function. You can use the following formula: =SEARCH (B2,A2). Add the ISNUMBER function with the SEARCH function, to check the

› Verified *3 days ago*

› Url: https://developerpublish.com/how-to-find-cell-that-contains-specific-text-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Active Sheet & Select Sheet in Excel VBA

**Details: **Selected Sheets vs ActiveSheet in **Excel** VBA. At any point in time, only one Sheet can be the ActiveSheet in **Excel** VBA.But, multiple Worksheets can be selected at once. If multiple Worksheets are selected, then the Worksheet with top most priority is considered as active sheet. Select Worksheet

› Verified *8 days ago*

› Url: https://developerpublish.com/active-sheet-select-sheet-in-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use DELTA function in Excel Worksheet

**Details: **Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar. Take a look at the given example. To find the DELTA value between two numbers, Enter the given numbers in column A and column B, enter the following formula in column C, Formula: =DELTA (A1, B1) Here, A1 and B1 refer to

› Verified *3 days ago*

› Url: https://developerpublish.com/delta-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Get the File Path and File Name using Excel VBA

**Details: **1. 1. MsgBox ActiveWorkbook.FullName. This line returns the complete path, including the name of the active workbook. You need to enter the exact file name to find its path. Tags: **Excel** Automation **excel** tips File Path VBA. Gogul Raju April 11, 2021.

› Verified *4 days ago*

› Url: https://developerpublish.com/how-to-get-the-file-path-and-file-name-using-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to list files of a directory in Excel worksheet

**Details: **Open one of the web browsers and paste the path in the address bar and press enter to get the list of all files displayed in the browser. 3. Use the shortcut key “Ctrl + A” to select all the contents from the web browser and press “Ctrl +C” to copy. 4. Open **excel** workbook in Microsoft **Excel** 2016 and press “Ctrl + V” shortcut key.

› Verified *1 days ago*

› Url: https://developerpublish.com/how-to-list-files-of-a-directory-in-excel-worksheet/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Insert Headers and Footers in Microsoft Excel

**Details: **In this article, you’ll get to know about Headers and Footers and how to insert them in your spreadsheets in Microsoft **Excel**.. Headers are added to the top of the page and Footers to the bottom. These are kinds of extras such as date, page numbers, or the name of the file, etc to the worksheet.

› Verified *8 days ago*

› Url: https://developerpublish.com/headers-and-footers-in-microsoft-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use the DDB function in Excel

**Details: ****Excel** recognizes “=’ as the start of a formula, if not included, **excel** will not accept and evade the execution of the function. With the parenthesis open, select the arguments in the order of syntax. The position of the cell will be visible in the formula. According to the order of the syntax, the value of the argument must be selected

› Verified *1 days ago*

› Url: https://developerpublish.com/ddb-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Create Drop-down Calendar in Excel

**Details: **First, prepare a **excel** sheet with the required details in it. To create a drop-down, select the cells. Go to data tab > data validation. A data validation dialog box opens up, select setting > then in allow just select the value that you want to be validated > data. Now go to Input Message > enter the Title > enter the message.

› Verified *1 days ago*

› Url: https://developerpublish.com/how-to-create-drop-down-calendar-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Find Blank Cells in Microsoft Excel

**Details: **Highlighting the Blank cells. To Highlight the Blank cells go to Find&Select drop down and then click on Go To Special. Now a Go To Special dialog box pops up, select the Blank option, and press Ok. The picture below is the result of the steps mentioned above. You can also change the highlight color by clicking on the paintbox drop-down.

› Verified *2 days ago*

› Url: https://developerpublish.com/how-to-find-blank-cells-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use Formulas in Microsoft Excel VBA

**Details: **In this post, you will be learning about formulas in **Excel** VBA – an in-depth explanation for beginners to learn **Excel** VBA. Formulas in **Excel**. Formulas are used to perform calculations. In **Excel**, a formula is an expression that operates on values in a range of cells or a cell. Let’s see about formulas in depth.

› Verified *9 days ago*

› Url: https://developerpublish.com/formulas-in-excel-vba-a-beginners-guide/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use Close & Open WorkBook in Excel VBA

**Details: **Close and Open WorkBook in **Excel** VBA. First, place a command button on your worksheet. Under the developer tab, click insert and choose your command button. Save the workbook as “close and open methods in VBA.xlsm”. In the code section, enter the following codes. This code line closes the close and open methods in VBA.xlsm file.

› Verified *2 days ago*

› Url: https://developerpublish.com/close-open-workbook-in-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use the PERCENTILE.EXC Function in Excel

**Details: **How to use the PERCENTILE.EXC Function in **Excel**? Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar. Take a look at the given example. Enter the data in the respective columns and enter the PERCENTILE.EXC formula. Formula: =PERCENTILE.EXC (A2:A11,0.75)

› Verified *2 days ago*

› Url: https://developerpublish.com/percentile-exc-function-in-excel/ Go Now ^{}

› Get more: How to useGo Now ^{}

### How to Sort By Color In Excel

**Details: ****Excel** provides us enormous ways to sort a particular data entered in it. This post will be providing pieces of information about how to sort the data by color in **Excel**. What is Sorting? Sorting is a way of arranging particular data.

› Verified *2 days ago*

› Url: https://developerpublish.com/sort-by-color-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Rename a File in Excel VBA

**Details: **In **Excel** VBA, to rename an existing file, you can use the Name Command. To rename a file using Name command, Firstly you need to locate the file in the local directory. Copy the location address of the file. “C:\**Excel** VBA\**Excel** VBA 2.xlsx”. Enter the following code in the Visual Basics editor,

› Verified *3 days ago*

› Url: https://developerpublish.com/how-to-rename-a-file-in-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Loop Through All Sheets in Workbook in Excel VBA

**Details: **In this post, you’ll be learning about loops in Worksheet and a quick tip showing how you can loop through all sheets in workbook in **Excel** VBA.. Loop through all sheets in Workbook in **Excel** VBA. Looping through all sheets in a Workbook in **Excel** VBA can be done using For each loop.

› Verified *8 days ago*

› Url: https://developerpublish.com/loop-through-all-sheets-in-workbook-in-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Cut, Copy and Paste using a Macro in Excel

**Details: **As you know, to run the macro code in **Excel**, Open the Visual Basic Editor (Alt + F11), Click on Insert a new module. Enter the code, save it and run it. There are different methods to copy or cut and paste the contents in **excel**. You can copy a cell, a row, a column and paste it into different columns, rows, cells, or even in different workbooks.

› Verified *1 days ago*

› Url: https://developerpublish.com/cut-copy-and-paste-using-a-macro-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use SUBSTITUTE function in Microsoft Excel

**Details: **First, prepare an **excel** sheet with the required details in it. To get started use the following formula: SUBSTITUTE(text, old_text, new_text, [instance_num]). The below picture is an example of a Substitute Function in an **excel** spreadsheet.; We hope that this article will be resourceful and understandable.

› Verified *8 days ago*

› Url: https://developerpublish.com/substitute-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use MINIFS Function in Excel

**Details: **MINIFS Function in **excel** is a statistical function. The MINIFS Function calculates and returns the smallest numeric value that meets one or more criteria in a given range. MINIFS can be used with criteria based on dates, numbers, text, and other conditions. MINIFS supports logical operators (>, <, <>, =) and wildcards (*, ?) for partial matching.

› Verified *4 days ago*

› Url: https://developerpublish.com/minifs-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use the RANK.EQ Function in Excel

**Details: **How to use the RANK.EQ Function in **Excel**? Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar. Take a look at the given example. Enter the data in the respective columns and enter the RANK.EQ function formula. Formula: = =RANK.EQ (A2,B2)

› Verified *5 days ago*

› Url: https://developerpublish.com/rank-eq-function-in-excel/ Go Now ^{}

› Get more: How to useGo Now ^{}

### How to use UNICODE Function in Excel

**Details: **First, prepare an **excel** sheet with the specified details in it, or open an existing file with data. Enter the syntax of the UNICODE function and fill its arguments in the cell, where you want to display the corresponding character of the text. In the Formulas ribbon, you can see the Functions command in it by choosing the Function command a

› Verified *5 days ago*

› Url: https://developerpublish.com/unicode-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use RANK Function in Excel

**Details: **The RANK function in **Excel** returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest as well as smallest to largest. Important: **Excel** has replaced this function with one or more new functions to improve accuracy along with the function names reflecting their usage.

› Verified *2 days ago*

› Url: https://developerpublish.com/rank-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use COUNTA Function in Excel

**Details: **STEP 1: Open the workbook in Microsoft **Excel**. STEP 2: Enter the data in the workbook. In the new cell, give the formula or the syntax. Always start with ‘ =’ for every functions, COUNTA function name, followed by the open parenthesis, the arguments of the syntax. The values are from A3 to A9.

› Verified *4 days ago*

› Url: https://developerpublish.com/counta-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use ACCRINT Function in Excel

**Details: **The **Excel** ACCRINT function will return the accrued interest for a security that pays repeatedly. Importantly this function helps to calculate the accrued interest on security such as a bond. As a result, a particular bond is sold or transferred to a new owner in a specific date other than the issued date or on a date that is an interest payment

› Verified *5 days ago*

› Url: https://developerpublish.com/accrint-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Record Macros in Absolute and Relative Mode in Excel

**Details: **Type Microsoft **Excel** and press enter. Type Record Macro and press enter. Type Using Relative mode and press enter. Click Stop Recording. Delete the contents of range A1:A3. Select any other cell (let us say, cell B2) and run the recorded macro. **Excel** places the words relative to the initial selected cell.

› Verified *9 days ago*

› Url: https://developerpublish.com/how-to-record-macros-in-absolute-and-relative-mode-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use the PERCENTRANK function in Excel

**Details: **The PERCENTRANK function in **Excel** returns the rank of a value in a data set as a percentage of the data set. This function can be used to evaluate the relative standing of a value within a data set. The percentile rank is commonly used as the key to interpreting the standing in standardized tests. Syntax

› Verified *9 days ago*

› Url: https://developerpublish.com/percentrank-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Check for Prime Number in Excel VBA

**Details: **To check for Prime numbers using **Excel** VBA, Code: Sub CheckForPrime (): Dim divisors As Integer, number As Long, i As Long divisors = 0 number = InputBox ("Enter a number") For i = 1 To number If number Mod i = 0 Then divisors = divisors + 1 End If Next i If divisors = 2 Then MsgBox number & " is a prime number" Else MsgBox number & " is not a

› Verified *2 days ago*

› Url: https://developerpublish.com/how-to-check-for-prime-number-in-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use COUNTBLANK Function in Excel

**Details: **The COUNTBLANK Function in **excel** is a statistical Function .COUNTBLANK Function will count the number of empty cell in a given range of cells. Ignore cells that contain text, number, and errors. In financial analysis, this function will be useful in highlighting counting the empty cells. Syntax

› Verified *8 days ago*

› Url: https://developerpublish.com/countblank-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use MAXIFS Function in Excel

**Details: **MAXIFS Function in **excel** is a statistical function. The MAXIFS Function calculates and returns the largest numeric value that meets one or more criteria in a given range. MAXIFS Function can also be used with criteria based on dates, numbers, text, and other conditions.

› Verified *4 days ago*

› Url: https://developerpublish.com/maxifs-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use the NOMINAL function in Excel

**Details: ****Excel** recognizes “=’ as the start of a formula, if not included, **excel** will not accept and evade the execution of the function. With the parenthesis open, select the first argument value. The position of the cell will be visible in the formula. According to the order of the syntax, the value of the argument must be selected followed by a comma.

› Verified *5 days ago*

› Url: https://developerpublish.com/nominal-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Disable Research Task Pane in Excel

**Details: **How to disable the research task pane in Microsoft **Excel** 2016 using VBA Code? 1. Press Alt + F11 shortcut key to open the VBA Editor. 2. Press Ctrl + G to open the Immediate Window and enter the following code and press the enter key. Application.CommandBars (“Research”).Enabled = False. 3. Now , close the VBA Editor and check the **excel**

› Verified *6 days ago*

› Url: https://developerpublish.com/how-to-disable-the-research-task-pane-in-microsoft-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Split Strings based on Delimiter in Excel VBA

**Details: **Split Function in **Excel** VBA. It helps in separating the component parts from within a standard text string where each component uses a specific delimiter character. It is easier to use than writing code to search for the delimiters in the string and then extracting the values. Split function can be used in reading a line from a Comma-Separated

› Verified *5 days ago*

› Url: https://developerpublish.com/split-strings-based-on-delimiter-in-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use IPMT function in Excel

**Details: ****Excel** recognizes “=’ as the start of a formula, if not included, **excel** will not accept and evade the execution of the function. With the parenthesis open, select the arguments in the order of syntax. The position of the cell will be visible in the formula. According to the order of the syntax, the value of the argument must be selected

› Verified *2 days ago*

› Url: https://developerpublish.com/ipmt-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Show or Hide all Comments in Microsoft Excel

**Details: **1 – Navigate to the Review Tab in the **Excel** Ribbon and select the Toggle button “Show All Comments”. This would display all the comments in the **excel** sheet. 2 – To hide all the comments in the same **excel** worksheet click the same “Show All Comments” button again. Its a Toggle button and this will hide all the comments.

› Verified *6 days ago*

› Url: https://developerpublish.com/how-to-show-or-hide-all-comments-in-microsoft-excel-2016/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use Offset Range or Cell in Excel VBA

**Details: **The Offset property in **Excel** VBA is used to programatically return a cell or range which is relative to a specified cell. Syntax. Range.Offset(RowOffset, ColumnOffset) Range defines the cell or range of cells. RowOffset and ColumnOffset acceprt integers. When it is a positive integer, the offset moves towards the bottom and right.

› Verified *4 days ago*

› Url: https://developerpublish.com/how-to-use-offset-range-or-cell-in-excel-vba/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use the INTRATE function in Excel

**Details: ****Excel** recognizes “=’ as the start of a formula, if not included, **excel** will not accept and evade the execution of the function. With the parenthesis open, select the arguments in the order of syntax. The position of the cell will be visible in the formula. According to the order of the syntax, the value of the argument must be selected

› Verified *5 days ago*

› Url: https://developerpublish.com/intrate-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use AMORDEGRC function in Excel

**Details: **1) Open Microsoft **excel** and launch a workbook or create a new **Excel** sheet. 2) As said in the description, you need the values of all the above arguments to carry out the AMORDEGRC function and get the correct and desired value. 3) Enter the arguments in the same order of the syntax, one below the other, as shown in the picture below.

› Verified *7 days ago*

› Url: https://developerpublish.com/amordegrc-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use COUNTIF Function in Excel

**Details: **Open the workbook in your Microsoft **Excel**. Step 2: Enter the data, in the workbook. STEP 3: In the new cell, give the formula or the syntax. Start with ‘ =’ for every functions, COUNTIF to initiate functions name, followed by open parenthesis. In this example, the range is sales values. Hence the values are from C3:C12.

› Verified *5 days ago*

› Url: https://developerpublish.com/countif-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use COUNTIFS Function in Excel

**Details: **COUNTIFS Function in **Excel** calculates the counting of cells that meets multiple conditions and returns number of times met with the criteria. Arguments can be dates, numbers, text, cell references and other conditions. COUNTIFS Function supports logical operators (<, >, <>, =) and wildcards (*, ?) for partial matching.

› Verified *6 days ago*

› Url: https://developerpublish.com/countifs-function-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use Logical Operators in Excel VBA

**Details: **In this post, you’ll learn about logical operators in **Excel** VBA and how to use them for various operations with-in your **Excel** workbook.. Logical Operators in **Excel** VBA. Logical operators such as And, Or, Not are supported by **Excel** VBA. They are used to comparing values. They return values in a Boolean form that is either True or False.

› Verified *Just Now*

› Url: https://developerpublish.com/logical-operators-in-excel-vba/ Go Now ^{}

› Get more: How to useGo Now ^{}

### How to Add and Delete Multiple Checkboxes in Excel

**Details: **In **Excel**, a checkbox is an interactive tool that can be used to select or deselect an option. You can use a checkbox in **Excel** to create interactive checklists, dynamic charts, and dashboards. The following are the steps to use the checkboxes in **excel**:

› Verified *Just Now*

› Url: https://developerpublish.com/how-to-add-and-delete-multiple-checkboxes-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to use Floor.math function in Excel

**Details: **How to use Floor.math function in **Excel**? The Floor.math function rounds off a number towards the closest multiple of significance. This is a rounding function similar to the Ceiling function but, it rounds down the number towards zero, that is towards the number lesser than it, …

› Verified *8 days ago*

› Url: https://developerpublish.com/floor-math-function-in-excel/ Go Now ^{}

› Get more: How to useGo Now ^{}

### Top Categories

### Recently Searched

› Unprotected sheet command in excel

› Excel line feed in a formula

› Excel order of dates printable

› Mitsubishi el salvador excel

### Trending Searches

› How to use the sumif function

› How to use the countif function

› How to use the excel time function

› How to merge data tables in excel

› How to fix a circular reference error

› Mathematical formulas in excel