what is the key stroke for an array formula in excel on a 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.

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.

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).

Then double-click.

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

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.

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.

What Is The Key Stroke For An Array Formula In Excel On A Mac