When rearranging worksheets, the currently selected worksheet is inserted before the sheet you choose in the Move or Copy dialog box.You may also use the JAWS keystroke CTRL+SHIFT+S to open a list of worksheet names and move to a specific worksheet. Press CTRL+PGUP or CTRL+PGDN to find the worksheet called Restaurant Supplies. Make sure the sheet you want to move is the current sheet.To rearrange worksheets do the following: Let us move the worksheet Restaurant Supplies back to position one as the first sheet in the workbook. NOTE: New worksheets are inserted before the current sheet. Go ahead and insert a new worksheet now.

NOTE: If you need to find out the physical number of a worksheet that has been renamed, use the JAWS keystroke INSERT+F1. NOTE: At the present time you can hear the characters of text as you enter them into the field to name worksheets, but you will not be able to hear when reading by character, word, etc.

Press ENTER to close the edit field when finished.

Go ahead and rename sheet 1 to 'Restaurant supplies.'.

Location: Cells group of the lower ribbon.

Using the keyboard the steps to rename a worksheet are as follows: Worksheets can be named to something more meaningful than the default, which is Sheet1, Sheet2, and so on. More worksheets can be created and they can also be deleted. The rows are numbered from 1 to 1,048,576. Column headers are labeled A through Z, then AA through AZ, BA through BZ, and so on up to XFD (that is 16,384 columns). The worksheet consists of a grid of columns and rows. The default Excel 2016 workbook is made up of a single worksheet. There is a title bar at the top of the screen, the ribbon which contains an upper group of tabs and a lower part that contains groups of controls that are relevant to the currently selected tab, a Quick Access Toolbar, the main portion of the window where the current worksheet is shown, and a task bar at the bottom of the page.

To close this screen and get to a blank workbook, just press ESC. This startup screen contains a number of templates you can use in Excel. Initially, the program opens to a startup screen in the backstage view. Microsoft Excel 2016 is similar to the other Office 2016 products in overall layout. NOTE: For those of you participating in the live webinar, the following link will open the documentation in a new browser window Opens in a new window.ĮXERCISE: Open the file RestaurantSupplySampleSpreadsheetExcel2016-Unfinished Opens an Excel workbook to use with the following exercises. Excel 2016, Lesson One Excel 2016, Lesson One

How to modify headers in excel 2016