As an Excel user, you might often find yourself working on a large worksheet with a lot of data. In such cases, it can be helpful to know keyboard shortcuts that allow you to navigate and select cells quickly, without having to use your mouse. One such useful shortcut is “Same selection in previous column,” which allows you to select the same cells in the previous column that you have selected in the current column. In this blog post, we will discuss how to use this keyboard shortcut in Excel.
Keyboard Shortcut to Same Selection in Previous Column In Excel
The Keyboard Shortcut to Same Selection in Previous Column In Excel is ⌥ + ⇧ + Tab for Mac.
Here’s how to use this shortcut:
- Select the cells you want to copy in the current column.
- Press and hold down the Option key (⌥) and the Shift key (⇧) at the same time.
- While holding down these keys, press the Tab key.
- Excel will select the same cells in the previous column that you have selected in the current column.
It’s as simple as that! Using this shortcut can save you a lot of time if you need to copy data across multiple columns.
Points to Remember
- This keyboard shortcut only works in Mac versions of Excel.
- The cells you want to copy must be selected before using the shortcut.
- This shortcut only works for adjacent cells; it cannot be used for non-adjacent cells.
- If you want to copy cells to the next column instead of the previous column, you can use the shortcut Option + Tab (⌥ + Tab) for Mac.