Each time you press these keys, the active cell moves to a different corner of the selected block. (period) to navigate around the corners of your selected data range. If you've selected a large range but want to go back to the beginning of that selection without deselecting the entry, you can show the active cell by typing Ctrl + Backspace. To select ONLY the cells that are currently visible, select the range you want and then hit Alt + to exclude those hidden entries.
You may have rows or columns hidden that you don't want selected when you are working with the surrounding data range. Mac equivalent: Group: Cmd + Shift + K | Ungroup: Cmd + Shift + J 3. Or, if you prefer to use your keyboard to expand and collapse, you can use the following shortcuts. Once the group is formed, you can expand or collapse the entries using the plus and minus buttons that Excel creates in the header section for the rows or columns. To ungroup the rows, use Shift + Alt + ←. To group two or more columns or rows together, select the entries you want to group and then type Shift + Alt + →. To clear all filters, use Alt, then A, then C. This creates a filter and excludes the item(s) you selected.
If you want one or more items to be filtered out of your pivot table, just select the item(s) you want filtered and type Ctrl +. If you are looking to up your Excel game and work faster using keyboard shortcuts, I recommend you give these 19 techniques a try. 19-Advanced-Excel-Shortcuts.xlsx Download Advanced Keyboard Shortcuts
0 kommentar(er)
