Select cells with unequal or unique values within the selection i.e. Within the selection, selects the cells in other rows with values that do not match the values in the row where active cell is Select the array containing the active cell. Having multiple cells selected, executing this combo will reduce the selection to active cell. Pressing the third time selects the entire worksheet. Pressing the second time selects the current region and its summary rows. Pressing once selects the current region. Selects an entire row in a worksheet.If worksheet has tableInside the table, toggles between selecting the table row and the entire row of worksheet If used inside a table, toggle between selecting the data, data and headers, and the entire column. Selects an entire column in a worksheet.If used outside a table, select entire column. Selects the current and previous sheet in the same workbook. Selects the current and the next work sheet in a workbook. Selects all the rows and columns between the active cell and the first cell A1 of worksheet
In the formula barselects text input in formula bar from the cursor position till the end without affecting height of formula barīy default, on pressing completes the input and move the selection to the cell below. Even if it is empty if it has been used selection will extend to that cell. It helps selecting nonadjacent cells and also range of cellsĮxtends the selection by one cell (row or column) in the direction of arrow keys pressedĮxtends the selection to next nonblank cell in the same row or column in the direction of arrow key pressed.Įxtends the selection of cells to the last bottom right cell used on the worksheet. When on (status bar notifies “Add to selection”) any cell, row or column highlighted or selected will be added to selection. Toggles “Add to selection” mode on or off. When on (status bar notifies “Extended Selection”) selection extends in the direction of arrow key pressed. Toggle extended selection mode on or off. Selects every cell that contains comment. Executing the combo second time selects whole worksheet.Just like pressing the select all button at the top left corner where the rows and columns meet. Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). Each and every shortcut key deserves a place among top excel shortcut keys which every accountant must know if he is after speed efficiency and productivity in his number crunching, analysis or any other task in Excel. In this mega collection which just relates to one thing and one thing only SELECTION we have made up an almost ultimate collection of selection shortcuts. However, life is much easier if you know selection tricks Excel has to offer and even better is they come in shape of shortcut keys which you can remember for daily usage. And even in Excel it is not easy when you making your way through thousands of cells. While working in Excel or any data related job selection is one job in itself.
0 kommentar(er)
