Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]

Posted on December 30th, 2008 in Learn Excel - 0 comments

select-all-cells-in-a-direction-excelHere is a very quick spreadcheat for the new year.

If you need to select all the cells in a series (either row-wise or or in columns) you can use one of these 2 shortcuts (and avoid unnecessary scrolling)

1. Select the first cell in the series

2. Press Shift + Ctrl + Down arrow

Or

1. Select the first cell in the series

2. Hold down SHIFT and Double click on the edge of cell in the direction you want to select

for eg. double click on the think black line (that you see when you select a cell) and excel selects all the cells in that direction

Written by Chandoo
Tags: , , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

No Responses to “Selecting all the cells in a series – keyboard and mouse shortcuts [spreadcheats]”

  1. Vishal says:

    Cool. Taking cue from this tip, to go to last cell

    (keyboard)
    1. Select the first cell in the series
    2. Press Ctrl + Down arrow

    (mouse)
    1. Select the first cell in the series
    2. Hold down Ctrl and Double click on the edge of cell in the direction you want to select

    Wish you all a very happy new year.

Leave a Reply