A worksheet is a collection of cells within an Excel file. Worksheets allow you to organise and manipulate different sets of data. Each Excel workbook can contain multiple worksheets. For example, you could have a worksheet showing data for each month of the year all within the same Excel file.
When you create an Excel workbook, there is just one worksheet called Sheet1. The name of the worksheet appears on its sheet tab at the bottom of the Excel window.
To create a new worksheet, press Shift + F11.
To move between worksheets, press Control + PageUp/PageDown.
Note: the position of your PageUp and PageDown keys may vary depending on your keyboard. On a standard desktop keyboard they are in the set of six keys above the Arrow keys, on the right hand side.
Create and Move Between Worksheets in Excel
posted in: Shortcut of the Week
0
Leave a Reply