To view the whole worksheet, press (Ctrl + End), Hold down Shift and select (Ctrl + Home). Select (View > Zoom) and choose the required percentage from the available options. You can also change the Zoom percentage by displaying the Zoom dialog box. The default percentage for all new worksheets is 100%. To change the worksheet zoom percentage select a different percentage from the drop-down list. The quickest way to change the view percentage it to use the view drop-down list on the Standard toolbar. You can magnify a worksheet to read small data or shrink a worksheet to view more of your data. You can enlarge and reduce the current font size of the worksheet by adjusting the view percentage. Always use the underscore instead of a space. It is a lot simpler when using sheet names in formulas and range names if you do not use spaces in your worksheet names. Last - Selects the last worksheet in the active workbook. Right - Selects the worksheet to the right of the active worksheet. Left - Selects the worksheet to the left of the left of the active worksheet.

There are four navigation arrows provided and they allow you to quickly move around between multiple worksheets.ДЇirst - Selects the first worksheet in the active workbook. You can alternatively use the navigation arrow keys to the left of the sheet tabs. You can select a sheet tab to make that particular sheet active. These are located at the bottom left of the workbook, next to the horizontal scroll bar.

To move between worksheets just select a different sheet tab at the bottom. The active cell is the cell that is currently selected.ДЄt any one time there can only ever be one Active Worksheet and one Active Cell. The following are all examples of cell addresses: A1, B2, D200, CC56, IV6000. The Name box in the top left corner always displays the address of the active cell. The exact number of cells displayed at any one time depends on the size of the screen, screen resolution and video driver.Д®ach intersection of a row and a column defines a cell and this cell can be identified by its unique address.ДЄ cell address is made up of the column letter followed by the row number.ДЇor example the cell that is the intersection of column 'B' with row '2' has a unique cell address of 'B2'.Д®very cell on a worksheet has a unique address. This means that every worksheet contains 16,777,216 individual cells. Worksheets are where you store your data and you will typically have more than one worksheet in a workbook.Д®very worksheet has 16,384 columns (A - XFD) and 1,048,576 rows. A worksheet is the name given to the large grid where you actually perform your calculations.ДЄ worksheet can be thought of as a single sheet of paper.

Free excel worksheets practice