selecting 4 more cells when selecting one

Copper Contributor

I need a way to auto-select 4 cells that are right to the one that i select (or a way to select all together the 5 cells that i need)i need it for a "Quick shortcut page" on my portfolio excel, to dont type every time the same data (you can suggest any other idea) thanks

1 Reply


To achieve the auto-selection of four cells to the right of the cell you select in Excel on Mac, you can use a combination of keyboard shortcuts and range selection techniques. Here's how:

  1. Click on the cell from which you want to select the data.
  2. Press and hold the "Shift" key on your keyboard.
  3. While holding the "Shift" key, press the right arrow key (→) four times to select the four cells to the right of the original cell.

Now, all five cells (the original cell and the four cells to its right) should be selected together.

If you need to copy or move this selection to another location, simply use the standard copy (Command+C) or cut (Command+X) shortcuts, move to the desired location, and then paste (Command+V) the data.

By using the "Shift" key along with the arrow keys, you can easily extend your selection to multiple cells in any direction without having to click each cell individually. This can be a time-saving technique when working with repetitive data entry or data manipulation tasks in Excel.


You can achieve the desired functionality using VBA (Visual Basic for Applications) too in Excel for mac.

vba code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim selectedCell As Range
    Dim selectedRange As Range

    ' Check if only one cell is selected
    If Target.Cells.Count = 1 Then
        ' Store the selected cell in a variable
        Set selectedCell = Target

        ' Use the Offset property to select the range to the right (adjust the column offset as needed)
        Set selectedRange = selectedCell.Resize(1, 5)

        ' Select the range
    End If
End Sub


Note: Macros can be powerful and have the potential to modify your data.

The text was created with the help of AI.


My answers are voluntary and without guarantee!


Hope this will help you.