Shortcuts in MobiSheets on Windows

Every keyboard is designed to enhance your productivity with various shortcuts in Windows.

In this article, we’ll explore the essential keyboard shortcuts in MobiSheets, helping you streamline your workflow and navigate your spreadsheets more efficiently. 

KeysAction
Ctrl+F4Close Document
Ctrl+Shift+SSave As
F12File Print Menu
Ctrl+P
Ctrl+F2
Alt+FFile Menu
Ctrl+OOpen
Ctrl+ZUndo

Ctrl+Y

F4

Redo
Repeat
Repeat Redo
Ctrl+NNew
Ctrl+XCut
Ctrl+VPaste
Ctrl+CCopy
Ctrl+SSave
Ctrl+FFind and Replace → Find tab
Shift+F5
Ctrl+HFind and Replace → Replace tab
Ctrl+BBold
Ctrl+2
Ctrl+UUnderline
Ctrl+4
Ctrl+IItalic
Ctrl+3
Ctrl+5Strikethrough
Ctrl+GGo To
F5
DeleteClear Contents
F11Insert Chart In New Sheet
Ctrl+9Hide Rows
Ctrl+Shift+9Unhide Rows
Ctrl+0Hide Columns
Ctrl+Shift+0Unhide Columns
Ctrl+Shift+7Outside Borders
Ctrl+Shift+5Percentage Formatting
Alt+F1Insert Default Chart
Alt+Shift+F1Insert Sheet
Shift+F11
F9Recalculate
Ctrl+Alt+F9
Shift+F2Insert/Edit Comment
Ctrl+KInsert Hyperlink
Ctrl+Shift+PFormat Cells Dialog
Ctrl+1
Ctrl+Shift+F
Alt+Shift+RightGroup Data
Alt+Shift+LeftUngroup Data
UpMove Selection Up
Shift+EnterMove Selection On Shift Enter Key
DownMove Selection Down
Alt+DownOpen Dropdown
LeftMove Selection Left
RightMove Selection Right
Page UpMove Selection Page Up
Page DownMove Selection Page Down
Alt+Page UpMove Selection Page Left
Alt+Page DownMove Selection Page Right
Ctrl+Page UpPrevious Sheet
Ctrl+Page DownNext Sheet
Shift+UpExpand Selection Up
Shift+DownExpand Selection Down
Shift+LeftExpand Selection Left
Shift+RightExpand Selection Right
Shift+Page UpExpand Selection Page Up
Shift+Page DownExpand Selection Page Down
Alt+Shift+Page UpExpand Selection Page Left
Alt+Shift+Page DownExpand Selection Page Right
HomeMove Selection To Beginning Of Row
Shift+HomeExpand Selection To Beginning Of Row
Ctrl+HomeMove Selection to A1
Ctrl+Shift+HomeExpand Selection to A1
Ctrl+EndMove Selection to End of Sheet
Ctrl+Shift+EndExpand Selection to End of Sheet
Ctrl+SpaceSelect Entire Column
Shift+SpaceSelect Entire Row
Ctrl+Shift+SpaceSelect Entire Sheet
Ctrl+A
F2Edit Cell Mode
Ctrl+UpMove Selection to Top Data
Ctrl+Shift+UpExpand Selection to Top Data
Ctrl+DownMove Selection to Bottom Data
Ctrl+Shift+DownExpand Selection to Bottom Data
Ctrl+LeftMove Selection to Leftmost Data
Ctrl+Shift+LeftExpand Selection to Leftmost Data
Ctrl+RightMove Selection to Rightmost Data
Ctrl+Shift+RightExpand Selection to Rightmost Data
Ctrl+TInsert Table
Ctrl+Oem1Current Data Formula Box
Ctrl+Shift+Oem1Current Time Formula Box
Ctrl+Shift+Oem3General Format
Ctrl+Shift+OemMinusNo Border
Ctrl+Shift+OemQuotesCopy Value From Cell Above
Ctrl+OemQuotesCopy Formula From Cell Above
Ctrl+Shift+1Number Formatting with 2 Decimals Places
Ctrl+Shift+2Default Time Format
Ctrl+Shift+3Date Format DDMMYYYY
Ctrl+Shift+4Default Currency Format
Ctrl+Shift+5Default Percentage Format
Ctrl+Shift+6Default Scientific Format
Ctrl+Shift+8Select Cells with Data
Shift+F4Find Next
Ctrl+BackspaceGo to Selected Cell
Ctrl+Shift+LFilter

F4
(while referencing cells in inplace editor)

Switch between cell reference types
Ctrl+` (Accent Grave), the letter
 
à, è, ì, ò, ù; À, È, Ì, Ò, Ù
 
Ctrl+' (Apostrophe), the letterá, é, í, ó, ú, ý; Á, É, Í, Ó, Ú, Ý
Ctrl+Shift+^ (Caret), the letter

â, ê, î, ô, û; Â, Ê, Î, Ô, Û

 

Ctrl+Shift+~ (Tilde), the letter

ã, ñ, õ; Ã, Ñ, Õ

 

Ctrl+Shift+: (Colon), the letter

ä, ë, ï, ö, ü, ÿ; Ä, Ë, Ï, Ö, Ü, Ÿ

 

Ctrl+Shift+@, a or Aå, Å

Ctrl+Shift+&, a or A

æ, Æ

Ctrl+Shift+&, o or O

œ, Œ

Ctrl+, (Comma), c or C

ç, Ç

Ctrl + Shift + V

Paste Values

Ctrl + OemMinus

Delete selected Rows/Columns

Ctrl + OemPlus

Insert Rows/Columns

Ctrl + Drag

Copy Selection to the new place

Shift + Drag

Move and insert selection to the new place

Alt + Enter

When editing cell inserts new line

Tab

Move selected cell to next cell

Shift + Tab

Move active cell to previous cell

Enter

Move active cell to cell down

Shift + Enter

Move active cell to cell up

F9

When editing formula replace the selected expression with evaluated value

Ctrl + W

Close document

Ctrl + R

Fill right

Ctrl + D

Fill Down

Ctrl + D

Duplicate selected shape

Ctrl + Shift + U

Expand/Collapse Formula box

Ctrl + A

Select surrounding data or entire worksheet

Delete

Delete selected shape

Delete

Delete selected chart element

Ctrl + A

If shape is selected - select all shapes in the worksheet

Arrow keys

Move selected shape in corresponding direction

 

Was this article helpful?

1 out of 4 found this helpful