Office-common shortcut keys

Excel

CTRL+PGDN: Switch from left to right between worksheets tabs

Ctrl+pgup: Switch from right to left between sheet tabs

ctrl+shift+: Enter the current time 15:39

CTRL +; Enter Current date 2016/5/24

CTRL+F1 Show or hide the Ribbon

F2 edits the active cell and places the insertion point at the end of the cell content, and if you disable editing in the cell, it also moves the insertion point to the formula bar.

CTRL + ' same F2

Alt+enter can start a new row in the same cell

Word

CTRL+F1 collapse/Expand the Ribbon.

Shift+f3 selected text case toggle

Shift+f5 the insertion point back to the last edited position, Word can remember the first three edits, and when we have the IV insertion point, it will return to the current edit position.

This article is from the "01 Small Build" blog, please make sure to keep this source http://jetyi.blog.51cto.com/1460128/1782540

Office-common shortcut keys