To disable Filter, you just need to again click on the Filter in Ribbon in MS Excel.

You will see the name of the consumers who have taken Business Growth Loan.

Now, if we want to see the name of consumers who have taken Business Growth Loan, we can select Business Growth Loan in the filter drop-down and then click on OK as shown below:.

Once we click the Filter tab on the ribbon, we will see that filter is applied to the data, that is, on all the columns.

We have to first click on the Data tab and then click on Filter, as shown below.

TEXT and String Functions in Excel (26+).

Lookup and Reference Functions in Excel (35+).

Excel Conditional Formatting Based on Another Cell Value.

SUMPRODUCT Function with Multiple Criteria.

Compare Two Columns in Excel for Matches.

To use this method, all you need to do is select the number of rows you want to add, right-click on the selection, and select Insert.

How to Insert Multiple Rows Using the Insert Option Control + Plus (plus sign must be from the numeric keypad).You could also use the following shortcuts instead of Alt + I + E (the process is the same regardless of which shortcut you use): Press Alt + I + E and choose Shift cells down.Select the row above which you want to paste the rows by pressing the row number at the left.If you want to copy or cut multiple rows instead of adding blank rows, use the Alt + I + E shortcut. How to Insert Multiple Copied Rows Using Keyboard Shortcuts You could use one of the above shortcuts to add, for instance, 10 rows and subsequently press F4 10 times to add 100 blank rows. Pressing F4 on an Excel sheet repeats the previous action. If you want to use the plus sign on the main keypad, use Ctrl + Shift + Plus. Ctrl + Plus: You need to use the plus sign on the numeric pad.Alt + I and Alt + R: Press Alt + I, keep holding the Alt key, and press R.

Excel shortcut keys insert row