Sometimes you may want to find the first number in a text string, and deal with the numbers. In this Case, we only use excel formula to extract the first number. Complete formula This formula find the first number in a text string from the cell A1, if cell A1…
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 insert other cells, rows, or columns. You can also want to select all or a range of cells and turn on Editing mode so that you can modify the…
Note: The complete list of Excel 2010 keyboard shortcuts are for U.S. keyboard layout and Windows Operation system. Click Here to download PDF print version. Navigate Inside Worksheets Shortcut Key Action Arrow Keys Move one cell up, down, left, or right in a worksheet. Alt+Arrow Down Display the AutoComplete list…
Sometimes you may want to get last value of a Column or a Row with Excel Formula, Here is an example for you. In this example, Column A has mixed with text, number, symbol, error value, blank value, zero, formula, Chinese and Japanese, how to find the Right value? you…
What is Excel Solver Excel Solver is a what-if analysis tool for optimization in Microsoft Office Excel. It is an add-in with Excel since Excel 97. Excel Solver helps to find an optimal value in one cell, called the Objective Cell (target cell), on your worksheet. It works by changing…
Description IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. Syntax IF(logical_test, [value_if_true], [value_if_false]) Parameters logical_test: Required. Any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if…
We all know that making backups of your work is important. Now you can have a macro do it for you. This simple macro can backup your workbook with today’s date as part of the file name in the Same folder. Macro Code (VBA Code) Sub Backup() ‘Step 1: Create a…
Sometimes you may not want a user closing out a workbook without entering a specific piece of data. In these situations, you want Excel to prevent the user from closing or saving a file if certain cells are empty. you want to to make sure the user has entered all…