How to Same Selection in Previous Column in Excel

In Excel, if you want to select the same range in the previous column as the one you have currently selected, you can use the keyboard or mouse. Here are the steps:

Using the Keyboard:

1. Click on the cell within the current column that you want to start the selection from.
2. Hold down the Shift key.
3. Press the Left Arrow key to extend the selection to the same range in the previous column.
4. Release the Shift key when you’ve included the desired range.

Using the Mouse:

1. Click on the cell within the current column that you want to start the selection from.
2. Move your cursor to the top-left corner of the selected cell until it turns into a small square.
3. Click and drag to cover the range you want in the previous column.
4. Release the mouse button when you’ve included the desired range.

These methods allow you to extend your selection to the same range in the previous column. Choose the method that best suits your preference or workflow.