Context English Estonian
01020000.xhp
tit
help.text
Shortcut Keys for Spreadsheets Kiirklahvid arvutustabelites
01020000.xhp
bm_id3145801
help.text
<bookmark_value>spreadsheets; shortcut keys in</bookmark_value><bookmark_value>shortcut keys; spreadsheets</bookmark_value><bookmark_value>sheet ranges; filling</bookmark_value> <bookmark_value>arvutustabelid; kiirklahvid</bookmark_value> <bookmark_value>kiirklahvid; arvutustabelid</bookmark_value> <bookmark_value>lehtede vahemikud; täitmine</bookmark_value>
01020000.xhp
hd_id3145801
help.text
<variable id="calc_keys"><link href="text/scalc/04/01020000.xhp" name="Shortcut Keys for Spreadsheets">Shortcut Keys for Spreadsheets</link></variable> <variable id="calc_keys"><link href="text/scalc/04/01020000.xhp" name="Shortcut Keys for Spreadsheets">Kiirklahvid arvutustabelites</link></variable>
01020000.xhp
par_id3155067
help.text
To fill a selected cell range with the formula that you entered on the <emph>Input line</emph>, press <switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter. Hold down <switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter+Shift to apply the cell format of the input cell to the entire cell range. Valitud lahtrivahemiku täitmiseks <emph>sisestusreale</emph> kirjutatud valemiga vajuta <switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Enter. Sisestuslahtri vorminduse rakendamiseks kogu lahtrivahemikule vajuta <switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline>+Shift+Enter.
01020000.xhp
par_id3153967
help.text
To create a matrix in which all the cells contain the same information as what you entered on the <emph>Input line</emph>, press Shift+<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter. You cannot edit the components of the matrix. Maatriksi loomiseks, mille kõik lahtrid sisaldavad sama teavet, mis on kirjutatud <emph>sisestusreale</emph>, vajuta <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Shift+Enter. Maatriksi üksikuid lahtreid ei saa redigeerida.
01020000.xhp
par_id3166426
help.text
To select multiple cells in different areas of a sheet, hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> and drag in the different areas. Mitme lahtri valimiseks ühe lehe eri osades hoia all <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-klahvi ja lohista valik üle soovitud alade.
01020000.xhp
par_id3150207
help.text
To select multiple sheets in a spreadsheet, hold down <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>, and then click the name tabs at the lower edge of the workspace. To select only one sheet in a selection, hold down Shift, and then click the name tab of the sheet. Mitme arvutustabeli lehe valimiseks hoia all <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>-klahvi ja klõpsa tööala alumisel serval olevatele lehtede nimedega sakkidele. Ühe lehe valimiseks valitud lehtede hulgast hoia all Shift-klahvi ja klõpsa lehe nimega sakil.
01020000.xhp
par_id3166432
help.text
To insert a manual line break in a cell, click in the cell, and then press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter. Manuaalse reavahetuse lisamiseks lahtrisse klõpsa lahtril ja seejärel vajuta <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Enter.
01020000.xhp
par_id3146978
help.text
To delete the contents of selected cells, press Backspace. This opens the <link href="text/scalc/01/02150000.xhp" name="Delete Contents">Delete Contents</link> dialog, where you choose which contents of the cell you want to delete. To delete the contents of selected cells without a dialog, press the Delete key. Valitud lahtrite sisu kustutamiseks vajuta klahvi Backspace. See avab <link href="text/scalc/01/02150000.xhp" name="Sisu kustutamine">sisu kustutamise</link> dialoogi, kus saab valida, mida täpselt kustutada soovid. Valitud lahtrite sisu kustutamiseks ilma dialoogita vajuta Delete-klahvi.
01020000.xhp
hd_id3145386
help.text
Navigating in Spreadsheets Liikumine arvutustabelites
01020000.xhp
hd_id3149407
help.text
Shortcut Keys Kiirklahvid
01020000.xhp
par_id3153815
help.text
<emph>Effect</emph> <emph>Efekt</emph>
01020000.xhp
hd_id3146871
help.text
<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Home <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Home
01020000.xhp
par_id3159093
help.text
Moves the cursor to the first cell in the sheet (A1). Viib kursori lehe esimesse lahtrisse (A1).
01020000.xhp
hd_id3145073
help.text
<switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+End <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+End
01020000.xhp
par_id3153283
help.text
Moves the cursor to the last cell on the sheet that contains data. Viib kursori lehe viimasesse andmeid sisaldavasse lahtrisse.
01020000.xhp
hd_id3149127
help.text
Home Home
01020000.xhp
par_id3159205
help.text
Moves the cursor to the first cell of the current row. Viib kursori aktiivse rea esimesse lahtrisse.
01020000.xhp
hd_id3149897
help.text
End End
01020000.xhp
par_id3155095
help.text
Moves the cursor to the last cell of the current row. Viib kursori aktiivse rea viimasesse lahtrisse.