![]() ![]() The currently active, or 'cursor' cell is displayed with a thick black border around it. To select a particular sheet to be displayed, either tap on the sheet name tab, or use the arrow buttons in the bottom left corner. The sheet names are displayed on tabs at the bottom of the screen. You can change these names by using the Format Sheet Rename menu option. When new sheets are added they are given default names such as Sheet1, Sheet2 etc. The sheets are referred to by their sheet names. For example the cell in the top left corner of a worksheet is referred to as cell A1, because it is in column A and row 1. etc all the way up to XFD, which is the 16384 th column.Īn individual row is referred to by its row number, an individual column is referred to by its column name, and an individual cell is referred to by the column name and row number that it is in. The rows are number from 1 to 1048576, and the columns are named after the letters of the alphabet, going from A to Z, then AA, AB. There are 1048576 rows and 16384 columns of these. There are different types of sheets: Worksheets - which are used for storing data and doing calculations, Chart sheets - which are used for displaying graphs and charts, and Macro sheets - which are used for storing the instructions that make up custom (user-defined) functions and commands.Ī worksheet consists of many boxes, called "cells", arranged in a grid. A spreadsheet file is made up of pages, called "sheets". ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |