Use flash fill in Excel 2013 or later to automatically extract or combine data. Extract 1. For example, use flash fill to extract the numbers in column A below. 2. First, tell Excel what you want to do by entering the value 4645 into cell B1. 3. On the Data tab, in the Data Tools […]
This example illustrates how to use the union and intersect operator (borders below for illustration only) in Excel. 1. The union operator (comma) adds two ranges. Explanation: the SUM function reduces to =SUM(C4:D8) + SUM(D7:E11), 20. 2. The intersect operator (single space) returns the intersection of two ranges. Explanation: the SUM function reduces to =SUM(D7:D8), […]
Use the ‘Paste Special Skip Blanks’ option and Excel will not overwrite existing values with blanks. 1. Select the range B1:B12. 2. Right click, and then click Copy. 3. Select cell A1. 4. Right click, and then click Paste Special. 5. Check Skip Blanks. 6. Click OK. .
Sometimes it can be useful to hide columns or rows in Excel. Hide To hide a column, execute the following steps. 1. Select a column. 2. Right click, and then click Hide. Result: Note: to hide a row, select a row, right click, and then click Hide. UnhideTo unhide a column, execute the following steps. […]
You can insert a comment in Excel to give feedback about the content of a cell. Insert Comment To insert a comment, execute the following steps. 1. Select a cell. 2. Right click, and then click Insert Comment. 3. Type your comment. Excel displays a red triangle in the upper-right corner of the cell. 4. […]
It’s easy to create all sorts of sequences in Excel. For example, the Fibonacci sequence. 1. The first two numbers in the Fibonacci sequence are 0 and 1. 2. Each subsequent number can be found by adding up the two previous numbers. 3. Click on the lower right corner of cell A3 and drag it […]
Range in MS excel is called the collection of two or more selected cell in a row or in a column. Insert Row, Column To insert the rown select the entire row by clicking on desired number from left numbering linst as shown in the following Picture that number 3 (third row) has been selected. […]
Range in MS excel is called the collection of two or more selected cell in a row or in a column. Copy/Paste a Range To Copy the range, first select the area that you want to copy then right click to see the menu and select COPY as shown in the following Picture. now range […]
Range in MS excel is called the collection of two or more selected cell in a row or in a column. Move a Range To move the range, select it and mouse over the border of the selected area, as shown in the picture below. now drage the range where you want to. the result […]
Range in MS excel is called the collection of two or more selected cell in a row or in a column. Fill the rage To fill a range, do the following steps. Enter any value in B2. Select cell B2, click on the lower right corner of cell B2, you will see a dot at […]
Range in MS excel is called the collection of two or more selected cell in a row or in a column. How to Name the range Method 1Open Excel sheet and select the range to which you want to assign the specifit name.then click on FORMULA TAB and click DEFINE NAME optionsee the following figure […]
Some time we mistakenly typed complete list in colum in MS Excell but later it comes to know that it was to be written in row instead. So how can we change the complete legthy list. 1. Just copy the complete list 2. And for pasting right click on your desired cell and from menu […]
Some time in we feel something boring in our routine work, we need to type all those names that we use in daily life, like departments, members, class students name, clients cities and any personal numbers. User feel inconvenient while typing. Now you Dont need to type all the names every time you need. just […]
