Important Formula

How To Add Gridlines In Excel. Click the view tab, then uncheck the box for gridlines. Gridlines are vertical and horizontal lines across the bac.

Gridlines do not print by default. By default gridlines in excel are visible. There are a few gridlines you can add:

Value Look.up In Excel. Then, drag the formula down to the rest of the cells in the column. This will help you insert a column to the left of the company column.

For example, the vlookup function below looks up the first name and returns the last name. The first argument is the lookup_value. Select the column range you want to look up value, and click data > filter.

Vlookup Function In Excel. The vlookup function is one of the most useful functions in excel, and is a fast way to look up a value when your information is arranged in rows and columns. The vlookup function has four arguments (values in the function separated by commas) and because of this people often think vlookup is complex.

Equal to the specified value). The formulas using these two functions can easily search for any specific values from any given dataset. If the fruit is not present, cell c11 will give “not present” as you can see for “watermelon.”.

How To Stop Excel Adding Rows. A workaround could be to add a second header row that, for the cells with long texts only displays the last 30 characters or so. Press alt + f11 to open a microsoft visual basic for application window.

Step 1, locate the excel file that you need to work on. Not the answer you're looking for? Hide the first header row and freeze row 2.

Excel If And Statement. If you need to create more elaborate logical tests for your data, you can include additional if statements in the value_if_true and value_if_false arguments of your excel if formulas. =if (and (b2>=40,c2>=40),”pass”,”fail”) in the above formula, if there is a value 40 or greater than in any of the cells (b2 & c2) and function will return true, and if will return the value “pass”.

If you need to create more elaborate logical tests for your data, you can include additional if statements in the value_if_true and value_if_false arguments of your excel if formulas. If a2 is greater than b2, return true, otherwise return false. These values can be numbers, text, or even dates.