how to select data for graph in excel mac

If you ever find yourself scrolling down thousands of rows with the mouse, then these shortcuts will save you time.

You can clear that by deleting any of those previously used rows or columns and then saving your workbook.

Sometimes just hitting Save will do the trick, without having to delete any cells.).

However, there could be shapes (charts, slicers, etc.) on the sheet below or to the right of that cell.

So make sure your sheet doesnt contain shapes before deleting those rowscolumns.

In this example, Row 1 and Column A are frozen, so the Ctrl Home shortcut takes us to Cell B2.

For example, if you start at the top of a column and then press Ctrl you will jump to the last cell in that column before an empty cell.

Repeating this process will move you further down the column to just before the next blank cell.

And of course, holding Ctrl while using the left or right arrow key accomplishes the same action horizontally instead of vertically.

Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below).

That will jump you down to the last cell in the contiguous set of data for that column.

For example, if you start in any cell and press Shift, it highlights the original cell and the cell just below it.

And if you keep the Shift key held down, you can continue to move over multiple cells in multiple directions to select an entire range of data.

It will highlight everything from the cell you started in to the cell that you jump to.

To select large amounts of data containing many blanks, I recommend checking out this post for some alternatives.

Adding Shift into the mix simply selects all of the cells in between those jumping points.

Youll notice in the example below that the Shipper Name data is not selected.

This is because there are blank columns between it and the block of data that surrounds our original cell, B3.

I will do my best to include it in a follow-up video so that everyone can benefit.

Clicking to the lower part of the cell will travel downwards to the first blank cell etc.

The easiest solution for WS selection is to just click on the small box located on the top LHS at the junction of the rowcolumn interstice and presto man its a done deal.

How To Select Data For Graph In Excel Mac