When you do this with the Touch keyboard on a touchscreen device, you tap the Ctrl key and then the arrow key sequentially.

Just keep in mind that when youre unsure of the purpose of a particular command button displayed in the Excel worksheet window, all you have to do is to position the mouse pointer on that buttons icon to have Excel display the buttons name, its shortcut keys (if it has them), and, often, a short description of the buttons function.

You can customize this toolbar to contain other commands that you frequently use.

Press the Esc key to close the Backstage view and switch back into the regular worksheet view.

Like the Quick Access toolbar, you can customize the Ribbon to modify the display of the tabs and add tabs for other Excel commands that you frequently use.

This is followed by the Share button used to share a workbook file saved on your OneDrive or SharePoint site with clients and coworkers.

If the current cell is part of a range to which you have assigned a range name, that name appears in the Name Box instead of the cell address.

The long text box to the immediate right of the Insert Function button is the Formula bar, which displays the contents of the entry youre in the process of making or previously have made in the current cell.

This area takes up the major portion of the Excel worksheet window.

It uses light gray gridlines to mark the boundaries of cells of the worksheet and is bordered at the top by a row of letters identifying the columns and on the left by a column of numbers identifying the rows.

You can use the vertical scroll bar located along the right border of the worksheet area and the horizontal scroll bar located in the lower-right along the bottom of the worksheet area to bring other unseen parts of the worksheet into view.

To the left of this button, Excel displays tabs with the name of each worksheet in the current file (Sheet1).

To the left of the first sheet tab, you find the Next Sheet and Previous Sheet buttons.

If your Excel workbook contains so many worksheets that not all of its sheet tabs can be displayed, Excel adds scroll buttons (with...), which appear before the first and last sheet tab.

The current mode (Ready, Enter, Edit, and the like) is displayed on the far left.

If you record a macro, Excel adds a Record Macro command button that appears to the immediate right of the Mode indicator.

If you select a bunch of cells in the worksheet area that contains values, Excel displays the average, count, and sum of those values near the center of the Status bar.

On the right side of the Status bar, you find three workbook views buttons Normal, Page Layout, and Page Break Preview followed by the Zoom control with Zoom Out (-) and Zoom In () buttons and Zoom slider to decrease or increase the magnification of the cells displayed in the worksheet area indicated as a percentage.

When you use one of these keystrokes, the program automatically scrolls another part of the worksheet into view, if required by the size of your devices screen and its resolution.

If no cell is occupied, the pointer goes to the cell at the very end of the row.

If no cell is occupied, the pointer goes to the cell at the very beginning of the row.

If no cell is occupied, the pointer goes to the cell at the very top of the column.

If no cell is occupied, the pointer goes to the cell at the very bottom of the column.

Excel For Mac Opening Random Worksheets