How identify the elements of a spreadsheet in Excel

A spreadsheet information is presented in a graphical interface made up of lines si columns. columns Attached are letters and lines are numbered with. A spreadsheet contains 256 65536 columns and lines. The columns have labels placed on top of the document window and are denoted by letters (A, B, ..., Z), and combinations of two letters (AA, AB to IV). Lines are numbered 1 65536 to the left of the document window.

Excel Lines and Columns

At the intersection of a column and a line is found a cell. The cell is the fundamental unit of data storage. It can be referenced using the column letter and number line which is at the junction (eg A5, B7).

In a cell can enter several types of information:

· texts - Ends of the table, tags, notes, texts;

· values - Numbers, dates and times, logical values;

· Formulas - Formula with which a new value is calculated based on information from other cells.

Active cell is the cell that is marked. Information that you type appear in the active cell. To enter data in another cell is activated first cell. After exiting the input cell <Enter>, otherwise there is the possibility that these orders can not be applied. Spreadsheets can be sometimes very large. In these situations to find or enter information specific travel methods should be used by spreadsheets. Movement can be made with the mouse or keyboard. To make travel (by road) mouse using vertical and horizontal scroll bars found in the right and bottom of each spreadsheet.

Horizontal and Vertical Bar Excel

Each bar contains two arrows. By running a click on an arrow can do the following operations:

▲ - Scroll one line up

▼ - Scroll one line down

◄ - Scroll one column left

► - Scroll right one column

To move faster through the sheet you can use the scroll boxes (by dragging the scroll bar). Place of the scroll box in the scroll bar indicates the relative position of the window to the entire area of ​​the spreadsheet. A cell can be activated quickly by placing the cursor mouseOn the cell site and by clicking on the left button mouseacquis.

Moving through the spreadsheet with the keyboard can be done with the following keys:

Key

Action

Move one cell to the left

Move one cell to the right

Move one cell up

Move one cell down

<Tab>

Move one cell to the right

<Home>

Move the leftmost cell of a row

<Ctrl> + <Home>

Travel in a spreadsheet cell A1

<Ctrl> + <End>

Move the last used cell in the spreadsheet (bottom right)

<Page Up>

Move up one screen

<Page Down>

Move down one screen

<Ctrl> + <Page Up>

Move right one screen

<Ctrl> + <Page Down>

Move left one screen

How identify the elements of a spreadsheet in Excel

About the author

Stealth

Passionate about everything that means gadgets and IT, I write with pleasure stealthsettings.com from 2006 and I like to discover with you new things about computers and operating systems macOS, Linux, Windows, iOS and Android.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment is processed.