![]() This cell below the list is where the largest number will appear. Make sure the cell below the list of numbers you selected has a blank cell below it. To select a range of cells, click on the first cell in the range and then hold down the Shift key while clicking on the last cell in the range.Highlight the cells you want to find the largest number from.Repeat the previous step until you have selected all the required cells. Hold down CONTROL, click the selected cells, then on the pop-up menu, click Insert. For example, to insert five blank cells, select five cells. Tip: Select the same number of cells as you want to insert. You can scroll to make the last cell visible. Select the cell, or the range of cells, to the right or above where you want to insert additional cells. if you press and hold your control key (CTRL) down and then press your Down Arrow, you will immediately move your active cell to cell D6. Hit enter and the largest number from your selection will populate in the cell. If you wish to select more cells, press SHIFT + F8 and select the next range of cells. To select a larger range, it's easier to click the first cell and hold down the Shift key while you click the last cell in the range.Close the formula with an ending parentheses.Select the cells you want to find the largest number from.There are two ways to determine the highest number on an Excel spreadsheet. Excel is an amazing program to store and analyze hundreds (if not thousands!) of numbers, but sorting through all of that data to find something specific can be painful. If you need to quickly find the most expensive item in your 2016 budget, for example, you can use the MAX formula or AutoSum to uncover that value in seconds.Ĭheck out the video above or steps below to learn how.
0 Comments
Leave a Reply. |