HYPERLINK function
Description HYPERLINK function Creates a shortcut or jump that opens a document stored on the Internet. When you click the cell that […]
Excel VBA: Change Calculation Mode To Manual
Sub WorkbookCalculationManual() With Application 'Workbook calculation settings .Calculation = xlCalculationManual 'Change calculation mode to manual '.CalculateBeforeSave = True 'Recalculate workbook before saving, […]
How To Count Unique Values In Excel Using Formula
Sometimes you may want to count unique values exist in a range that contains duplicate values. You can count the number of […]
How To Find The First Number In A Text String Use Excel Formula
Sometimes you may want to find the first number in a text string, and deal with the numbers. In this Case, we […]
How To Select Cells In Excel
You may want to select multiple cells, ranges, rows, or columns in a worksheet in order to format the data in the selection, or to […]
Complete List of Excel 2010 Keyboard Shortcuts
Note: The complete list of Excel 2010 keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. Click Here to download […]
How To Get Last Value in a Column Use Excel Formula
Sometimes you may want to get last value of a Column or a Row with Excel Formula, Here is an example for […]
How To Use Excel Solver
What is Excel Solver Excel Solver is a what-if analysis tool for optimization in Microsoft Office Excel. It is an add-in with […]