Handleiding Nokia E61 (pagina 60 van 100) (Engels)

36272

Verklein

Vergroot

Pagina terug

1/100

Pagina verder

To add a comment to the selected cell, select Options > Advanced options > Insert comment. Write a comment, and select OK.

The cell is marked with a small triangle in the upper right corner of the cell.

To keep rows visible when scrolling, select a cell below the area that you want to remain visible and Options > Advanced

options > Freeze panes. To keep columns visible, select a cell to the right of the area that you want to remain visible and

Options > Advanced options > Freeze panes.

To change the size of rows and columns, select Options > Cell size > Row height or Column width.

To sort rows from left to right, select the cells you want to sort and Options > Advanced options > Sort rows. You can select the

number of the row to use as a primary sorting criteria. You can change the direction of the sorting order and ignore or match

the case sensitivity.

To sort columns from top to bottom, select the cells you want to sort and Options > Advanced options > Sort columns. You can

select the column to use as a primary sorting criteria. You can change the direction of the sorting order and ignore or match

the case sensitivity.

To format a font style, select the cells whose font style you want to modify and Options > Format > Font. You can change the

font type, size, text color, and background color of the cell.

To change a font formatting, select the cells you want to format and Options > Format > Font formatting. You can bold, italicize,

underline, strikethrough, or position the text in superscript or subscript format within a cell.

To align cell contents, select the cells whose alignment you want to modify and Options > Format > Alignment. You can change

both the horizontal and vertical alignment and wrap text to adjust the row height of the selected cells to display the entire

content of a cell.

To format cell borders, select the cells whose borders you want to modify and Options > Format > Borders. You can modify all

or only vertical, horizontal, upper, lower, left or right borders. Select Options > Change to edit the style and color of the borders.

To change the number format, select the cells whose number format you want to modify and Options > Format > Numbers.

Select the number format from the list. If the format you select includes decimal values, enter a number from 0 to 12 to indicate

the decimal place.

Example: If you want to compare and calculate different loan rates, you can set the number format to Percentage.

Work with cells

To edit a cell, select a cell and Options > Show cell field > Edit cell field. An upper part editing field opens. Start entering the data,

and select Done when you finish editing.

To insert cells, select the area where you want to insert new cells and Options > Cells > Insert. You can insert cells above (Shift

cells down) or to the left (Shift cells right) of the selected range. If you select only one cell, only one new cell is inserted. If you

select a range of cells, a corresponding range of blank cells is inserted. You can also insert a new row or column.

To clear contents or format from cells, select the cells and Options > Cells > Clear. If you select Formats, the formatting of the

selected cells is removed, but the content remains. The default style is used. If you select Content, the content of the selected

cells is deleted, but the formatting stays the same. You can also remove both formatting and contents of the selected cells.

To delete cells, rows, or columns, select the items you want to delete and Options > Cells > Delete. You can delete an entire row

or column. If you select Shift cells left, the selected cells are deleted, and the cells right of the selected cells are shifted left. If

you select Shift cells up, the cells below the deleted cells are shifted up.

Tip: When you delete information on which a chart is based, the information is also removed from the chart.

Insert functions

Functions are used for automating calculations.

To insert a function into a cell, select a cell. Select Options > Insert > Function and a function from the list. For example, #MIN

finds the lowest value in the numeric contents of a selected range of cells, #AVERAGE calculates the average of the values, and

#SUM adds the values together. Once you have selected a function, press the joystick. The function is inserted into the selected

cell. On the worksheet, enter the cells you want to include in the function inside the brackets, and press the joystick.

Tip: Before inserting a function, verify that Options > Show cell field > Edit grid is active and that the selected cell is

empty or starts with =.

Example: You want to add up the numbers in cells C2 to C6 and have the results appear in cell C7. Select cell C7 and

Options > Insert > Function. Select #SUM, and press the joystick. Enter C2:C6 inside the brackets, and press the joystick.

The sum appears in cell C7.

O f f i c e a p p l i c a t i o n s

Spelregels forum

Om tot zinvolle vragen te komen hanteren wij de volgende spelregels:

lees eerst de handleiding door;
controleer of uw vraag al eerder door iemand anders is gesteld;
probeer uw vraag zo duidelijk mogelijk te stellen;
heeft u een probleem en al geprobeerd om dit op te lossen, vermeld dit erbij aub;
heeft u een oplossing gekregen van een bezoeker dan horen wij dat graag in dit forum;
wilt u een reactie geven op een vraag of antwoord, gebruik dan niet dit formulier maar klik op de knop 'reageer op deze vraag';
uw vraag wordt direct op de website gezet; vermijd daarom persoonlijke gegevens in te vullen;

Belangrijk! Als er een antwoord wordt gegeven op uw vraag, dan is het voor de gever van het antwoord nuttig om te weten als u er wel (of niet) mee geholpen bent! Wij vragen u dus ook te reageren op een antwoord.

Belangrijk! Antwoorden worden ook per e-mail naar abonnees gestuurd. Laat uw emailadres achter op deze site, zodat u op de hoogte blijft. U krijgt dan ook andere vragen en antwoorden te zien.

Nokia E61 Handleiding

Hulp nodig? Stel uw vraag in het forum

Misbruik melden

Product:

Spelregels forum

Abonneren

Ontvang uw handleiding per email

Stel vragen via chat aan uw handleiding

Andere handleiding(en) van Nokia E61

Uw handleiding is per email verstuurd. Controleer uw email

Er is een email naar u verstuurd om uw inschrijving definitief te maken.

U heeft geen emailadres opgegeven

Uw vraag is op deze pagina toegevoegd

Info