summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorRafael Lima <rafael.palma.lima@gmail.com>2021-11-18 17:03:20 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2021-11-22 10:57:09 +0100
commit957baaaa79fc771842444d2fd5df6c9f9383f6d7 (patch)
tree10ecc99eeb2751af64870f538777f4df6f25e891
parenttdf#132643 Translate German section IDs (diff)
downloadhelp-957baaaa79fc771842444d2fd5df6c9f9383f6d7.tar.gz
help-957baaaa79fc771842444d2fd5df6c9f9383f6d7.zip
Document Duplicate/Rename sheet shortcuts in Calc
Based on Regina's comment on bug tdf#145745 there are quick ways to duplicate and rename Calc sheets. This patch documents these shortcuts. Change-Id: I887018cec48b829b73edd3c593d32f2044d60778 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/125450 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/04/01020000.xhp34
1 files changed, 34 insertions, 0 deletions
diff --git a/source/text/scalc/04/01020000.xhp b/source/text/scalc/04/01020000.xhp
index 500a7b37b2..2c5c6cf120 100644
--- a/source/text/scalc/04/01020000.xhp
+++ b/source/text/scalc/04/01020000.xhp
@@ -303,6 +303,40 @@
</tablerow>
</table>
<note id="par_id8070314">The ` key is located next to the "1" key on most English keyboards. If your keyboard does not show this key, you can assign another key: Choose Tools - Customize, click the Keyboard tab. Select the "View" category and the "Toggle Formula" function.</note>
+
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3143661">
+ <bookmark_value>spreadsheets; duplicate</bookmark_value>
+ <bookmark_value>spreadsheets; quick rename</bookmark_value>
+ </bookmark>
+ <h2 id="hd_id271637246984980">Copying and Renaming Sheets</h2>
+ <paragraph role="paragraph" id="par_id781637247029711">The sheet tabs used to navigate between sheets can be clicked in combination with keyboard keys to perform the following operations:</paragraph>
+ <table id="tab_id91637247123788">
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id741637247123788" role="tablehead">Shortcut Keys</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id731637247123788" role="tablehead">Effect</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id211637247123788" role="tablecontent"><switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + Drag sheet tab</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id981637247123788" role="tablecontent">Creates a copy of the sheet whose tab was clicked. The copied sheet is placed at the position where the mouse button was released.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id211637247123024" role="tablecontent"><switchinline select="sys"><caseinline select="MAC">Option</caseinline><defaultinline>Alt</defaultinline></switchinline> + Click sheet tab</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id981637247123114" role="tablecontent">Makes the sheet name editable. Edit the sheet name and press <keycode>Enter</keycode> when finished.</paragraph>
+ </tablecell>
+ </tablerow>
+ </table>
+
<h2 id="hd_id3148756">Function Keys Used in Spreadsheets</h2>
<table id="tbl_id5384685">
<tablerow>