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.

Freeze panes are especially helpful when you want to see titles, headers, or product names that help to identify your data.

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.

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

Then double-click.

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.

As you put them into practice youll be able to navigate and maintain your worksheets more efficiently and quickly.

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.

Excel For Mac Clear Error Cells