|
|
1.
|
|
|
Shortcut Keys for Spreadsheets
|
| Context: |
|
01020000.xhp
tit
help.text
|
|
|
Y==D
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
2.
|
|
|
<bookmark_value>spreadsheets; shortcut keys in</bookmark_value><bookmark_value>shortcut keys; spreadsheets</bookmark_value><bookmark_value>sheet ranges; filling</bookmark_value>
|
| Context: |
|
01020000.xhp
bm_id3145801
help.text
|
|
|
.T52
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
3.
|
|
|
<variable id="calc_keys"><link href="text/scalc/04/01020000.xhp" name="Shortcut Keys for Spreadsheets">Shortcut Keys for Spreadsheets</link></variable>
|
| Context: |
|
01020000.xhp
hd_id3145801
1
help.text
|
|
|
K+FW
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
4.
|
|
|
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.
|
| Context: |
|
01020000.xhp
par_id3155067
3
help.text
|
|
|
H;U=
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
5.
|
|
|
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.
|
| Context: |
|
01020000.xhp
par_id3153967
84
help.text
|
|
|
fA[,
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
6.
|
|
|
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.
|
| Context: |
|
01020000.xhp
par_id3166426
4
help.text
|
|
|
_A=#
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
7.
|
|
|
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.
|
| Context: |
|
01020000.xhp
par_id3150207
127
help.text
|
|
|
IZ?i
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
8.
|
|
|
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.
|
| Context: |
|
01020000.xhp
par_id3166432
129
help.text
|
|
|
B3RT
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
9.
|
|
|
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.
|
| Context: |
|
01020000.xhp
par_id3146978
130
help.text
|
|
|
:/TL
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
|
|
10.
|
|
|
Navigating in Spreadsheets
|
| Context: |
|
01020000.xhp
hd_id3145386
85
help.text
|
|
|
g5h}
|
|
|
|
|
(no translation yet)
|
|
|
|
Located in
01020000.xhp
|
