Zoho Sheet (Windows)

Formula related shortcuts

Show Function Dialog Box

Shift + F3

All hotkeys for Zoho Sheet (Windows)

File Operations
New File

Ctrl + N ( not supported in chrome and safari )

File Operations
Open file

Ctrl + O

File Operations
Save As File

Ctrl + Shift + S

File Operations
Print File

Ctrl + P

Actions
Undo last action

Ctrl + Z

Actions
Redo last action

Ctrl + Y

Actions
Repeat last action

F4 (or) Ctrl + Y (or) Alt + Enter

Actions
Filter

Ctrl + Shift + L

Actions
Fill to The Right

Ctrl + R

Actions
Fill Down

Ctrl + D

Actions
Add / Edit cell note

Shift + F2

Actions
Add / Edit Hyperlink

Ctrl + K

Actions
Open VBA Editor

Alt + F11

Actions
Run Macros / View Macros List

Alt + F8

Actions
Insert a new worksheet

Shift + F11

Actions
Insert Columns

Ctrl + Shift + Plus

Actions
Insert Rows

Ctrl + Alt + Plus

Actions
Cut

Ctrl + X

Actions
Copy

Ctrl + C

Actions
Paste

Ctrl + V

Actions
Format Cells

Ctrl + Shift + 1

Actions
Find within spreadsheet

Ctrl + F or F3

Actions
Replace

Ctrl + H

Actions
Names Ranges

Ctrl + F3

Actions
Toggle Auto Completion On / Off

Ctrl + Shift + Q

Actions
Display the auto suggest list (Pick from List)

Alt + Arrow Down

Actions
Insert the current time in cell

Ctrl + Shift + ;

Actions
Insert the current date in cell

Ctrl + ;

Editing
Insert Line Break in Cell

Ctrl + Enter

Editing
Delete one character to left while typing in a cell

Backspace

Editing
Delete one character to right/left while typing in a cell

Delete

Editing
Focus Formula Field

Ctrl + Shift + F

Editing
Cancel cell entry

Esc key

Editing
Edit active cell

F2

Formatting
Bold toggle for selection

Ctrl + B (or) Ctrl + Shift + 2

Formatting
Italic toggle for selection

Ctrl + I (or) Ctrl + Shift + 3

Formatting
Strikethrough toggle for selection

Ctrl + Shift + 5

Formatting
Underline toggle for selection

Ctrl + U (or) Ctrl + Shift + 4

Navigate
Data Region Down

Ctrl + Arrow Down

Navigate
Data Region Up

Ctrl + Arrow Up

Navigate
Focus Name Box

Ctrl + Shift + N

Navigate
Move to next worksheet in a spreadsheet

Alt + Arrow Right

Navigate
Move to previous worksheet in a spreadsheet

Alt + Arrow Left

Navigate
Go to cell command

Ctrl + G

Navigate
Go to last cell in data region

Ctrl + End

Navigate
Go to first cell in data region

Ctrl + Home

Navigate
Down one screen

Page Down

Navigate
Up one screen

Page Up

Navigate
Move to next cell in row

Tab

Navigate
Move to previous cell in row

Shift + Tab

Navigate
Select Data Region to the Left / to the Right

Ctrl + Arrow Left / Ctrl + Arrow Right

Shortcuts for Objects (Images,charts,buttons etc)
Navigate to the next object

Tab

Shortcuts for Objects (Images,charts,buttons etc)
Navigate to the previous object

Shift + Tab

Shortcuts for Objects (Images,charts,buttons etc)
Edit mode

F2

Shortcuts for Objects (Images,charts,buttons etc)
Return the focus to the active cell

Esc

Shortcuts for Objects (Images,charts,buttons etc)
Cancel dragging the object

Esc

Shortcuts for Objects (Images,charts,buttons etc)
Select/Focus the object

Ctrl + Click

Shortcuts for Objects (Images,charts,buttons etc)
Move the selected object in the desired direction

Arrow Keys

Shortcuts for Objects (Images,charts,buttons etc)
Snap the the object's left/top with the adjacent cell

Ctrl + Arrow Keys

Shortcuts for Objects (Images,charts,buttons etc)
Snap the the object's right/bottom with the adjacent cell

Ctrl + Shift + Arrow Keys

Selection
Select Data Region to the Left/ to the Right

Ctrl + Shift + Arrow Left / Ctrl + Shift + Arrow Right

Selection
Select Data Region Up/down

Ctrl + Shift + Arrow Up / Ctrl + Shift + Arrow Down

Selection
Select from current cell to the first cell A1

Ctrl + Shift + Home

Selection
Select from current cell to the last cell in the data region

Ctrl + Shift + End

Selection
Select from current cell to the first cell in the same row

Shift + Home

Selection
Select from current cell to the last cell in the same row

Shift + End

Selection
Select whole spreadsheet

Ctrl + A

Selection
Select column

Ctrl + Space

Selection
Select row

Shift + Space

Formula related shortcuts
Toggle Expand and Collapse of Formula Bar

Ctrl + Shift + U

Formula related shortcuts
Insert Array Formula on a range of cells

Ctrl + Shift + Enter

Formula related shortcuts
Select the range of array formula cells surrounding a cell

Ctrl + /

Formula related shortcuts
Start a formula

=

Formula related shortcuts
Recalculate Formulas

F9

Formula related shortcuts
Toggle absolute and relative references

F4

Formula related shortcuts
Auto Sum

Alt + =

Formula related shortcuts
Show Function Dialog Box

Shift + F3

Similar combinations for other applications


Adobe Reader 9 (Linux)
Find next / find previous (alternative is Ctrl+g / Ctrl+Shift+g)
Find and Select

F3 / Shift + F3


Adobe Reader X (Windows)
Find next / find previous (alternative is ctrl+g / ctrl+shift+g)
Find and Select

F3 / Shift + F3


Visual Studio 2015 (Windows)
Find next / find previous
Code Editor - Find, Replace, and Goto

F3 / Shift + F3


Microsoft Outlook 2010 (Windows)
Switch case between all upper, all lower, and first letter upper.
Messages in Main View - Format Message Body

Shift + F3


Thunderbird (Windows)
Find text again previous in Current Message
Find Messages

Ctrl + Shift + G / Shift + F3


Thunderbird (MacOS)
Find text again previous in Current Message
Find Messages

Command + Shift + G / Shift + F3


Thunderbird (Linux)
Find text again previous in Current Message
Find Messages

Ctrl + Shift + G / Shift + F3


Firefox (Linux)
Find previous occurrence of search term.
Search

Ctrl + Shift + G / Shift + F3


Microsoft Excel 2010 (Windows)
Display the Insert Function dialog box.
Work with Data Selections - Formulas

Shift + F3


Firefox (Windows)
Find previous occurrence of search term.
Search

Ctrl + Shift + G / Shift + F3


Microsoft Excel 2010 (Windows)
Insert a function into a formula .
Work with Data Selections - Formulas

Shift + F3


Microsoft Excel 2003 (Windows)
Insert a function
Unusual

Shift + F3


Visual Studio 2015 (Windows)
Find next / find previous
Coding - Find, Replace, and Goto

F3 / Shift + F3


Microsoft OneNote 2010 (Windows)
While searching the current page, move to the previous result.
Searching Notes

shift + f3


Microsoft Outlook 2010 (Windows)
Switch case between all upper, all lower, and first letter upper.
Messages in Compose View - Format Message Body

Shift + F3


Microsoft Excel 2011 (MacOS)
Open the Formula Builder
Function keys

Shift + F3


Total Commander 8 (Windows)
List only file under cursor, when multiple files selected
Main Shortcuts

Shift + F3


Inpage (Windows)
To select title text boox tool
For Tools Selection

Shift + F3


Notepad++ 5 (Windows)
Find previous
Search

Shift + F3


Open Office Impress (Linux)
Duplicate
Function Keys

Shift + F3


Microsoft Word 2007 (Windows)
Change the case of letters.
Character and paragraph formatting Apply character formats

Shift + F3


Visual Studio 2015 (Windows)
Find next / find previous
Code Snippets (Visual C# Scheme) - Find, Replace, and Goto

F3 / Shift + F3


Microsoft Excel 2011 (MacOS)
Open the Formula Builder
Working in cells or the Formula bar

Shift + F3


Microsoft Excel 2010 (Windows)
Display the Insert Function dialog box.
Insert and Edit Data - Formulas

Shift + F3


Microsoft Excel 2010 (Windows)
Insert a function into a formula .
Insert and Edit Data - Formulas

Shift + F3


Microsoft Outlook 2010 (Windows)
Switch case between all upper, all lower, and first letter upper.
Calendar Shortcuts - Format Message Body

Shift + F3


Opera (Linux)
Find previous instance of text
Find

Ctrl + Shift + G / Shift + F3


Microsoft Word 2007 (Windows)
Change the case of letters.
Function key reference: SHIFT+Function key

Shift + F3


Sublime Text (Windows)
Find next/ previous
Find and Replace

F3 / Shift + F3


Oracle SQL Developer 4 (Windows)
Find Next/ Previous
Search

F3 / Shift + F3


CATIA V5 (Windows)
Structure tree activate around e.g. character size to modify (activate the graph if the model is active and inversely)
38 Shortcuts for CATIA V5 (Windows)

Shift + F3


NetBeans 8 (Windows)
Find next/previous in file
General Keyboard Shortcts

F3 / Shift + F3


Microsoft Excel 2010 (Windows)
Display the Insert Function dialog box.
Format Data - Formulas

Shift + F3


Microsoft Excel 2010 (Windows)
Insert a function into a formula .
Format Data - Formulas

Shift + F3


Microsoft PowerPoint 2010 (Windows)
Change the case of letters between sentence, lowercase, or uppercase.
Change Fonts and Formatting

Shift + F3


IntelliJ (Linux)
Find next / Find previous
Search/Replace

F3 / Shift + F3


IntelliJ (Windows)
Find next / Find previous
Search/Replace

F3 / Shift + F3


Adobe Reader X (Linux)
Find next / find previous (alternative is ctrl+g / ctrl+shift+g)
Find and Select

F3 / Shift + F3


Microsoft Excel 2010 (Windows)
Display the Insert Function dialog box.
Formulas and Names - Formulas

Shift + F3


Microsoft Excel 2010 (Windows)
Insert a function into a formula .
Formulas and Names - Formulas

Shift + F3


Beyond Compare (Windows)
Find previous
Search Menu

Shift + F3


Beyond Compare (Windows)
Find previous filename
Search Menu - Folder Compare

Shift + F3


Beyond Compare (Windows)
Find previous filename
Search Menu - Folder Sync

Shift + F3


Presonus Studio One (Windows)
Toggle size
Console

Shift + F3


Microsoft Word 2013 (Windows)
Change between all upper-, first letter upper- and all lower-case
Format Text and Paragraph

Shift + F3


Microsoft Excel 2013 (Windows)
Display the Insert Function dialog box
Formulas

Shift + F3


Microsoft Excel 2013 (Windows)
Insert a function into a formula
Formulas

Shift + F3


Adobe Acrobat Pro (Windows)
Move to previous search result and highlight it in the document
Navigation

Shift + F3 / Ctrl + Shift + G


Qt Creator (MacOS)
Find next / Find previous
Editor

F3 / Shift + F3


Qt Creator (Windows)
Find next / Find previous
Editor

F3 / Shift + F3


Atom (text editor) 1.0 (Linux)
Find previous
Find and Replace

Shift + F3


Atom (text editor) 1.0 (Windows)
Find previous
Find and Replace

Shift + F3


Notepad++ 6 (Windows)
Find Previous
Search menu

Shift + F3


Microsoft Excel 2010 (Windows)
Display the Insert Function dialog box.
The Rest - Formulas

Shift + F3


Microsoft Excel 2010 (Windows)
Insert a function into a formula .
The Rest - Formulas

Shift + F3


Sonar 2015 (Windows)
Open Metronome settings
Transport

Shift + F3


Microsoft Outlook 2016 (Windows)
Switch case (selected text)
Common Commands: Format Text and work with Editor

Shift + F3


Microsoft OneNote 2016 (Windows)
While searching current page, move to previous result
Search Notes

Shift + F3


Microsoft PowerPoint 2016 (Windows)
Toggle cases(UppseCase/LowerCase)
Edit and General Text Operations

Shift + F3


Microsoft PowerPoint 2016 (Windows)
Change cases
Edit and General Text Operations

Shift + F3


Adobe After Effects CC (Windows)
Toggle between Graph Editor and Layer bar Modes
Keyframes and Graph Editor

Shift + F3


Adobe After Effects CC (MacOS)
Toggle between Graph Editor and Layer bar Modes
Keyframes and Graph Editor

Shift + F3


FileMaker Pro (Windows)
Zoom document larger / smaller
Navigation and Window Display

F3 / Shift + F3


CINEMA 4D (Windows)
Timeline
Editor

Shift + F3


Microsoft Word 2016 (Windows)
Change cases(UppseCase/LowerCase)
Text Editing/Graphics editing Operations

Shift + F3


Dynamics NAV 2015 (Windows)
Select Show Results
Page View and Review

Shift + F3


Zoho Sheet (MacOS)
Show Function Dialog Box
Formula related shortcuts

Shift + F3


Microsoft Word 2016 (Windows)
Change the case of letters.
All Function Key Shortcuts

Shift + F3


Autodesk Inventor 2017 (Windows)
Zoom window
View

Shift + F3


AutoCAD 2016 (Windows)
Subobject selection is limited to edges (AutoCAD only)
General

Shift + F3


Act! CRM (Windows)
Work week user roles
View Shortcuts

Shift + F3


Microsoft Projects 2016 (Windows)
Reset sort order to ID order and turn off grouping.
Navigate Views and Windows

Shift + F3


Atom (text editor) 1.0 (MacOS)
Find previous
Find and Replace

Shift + F3


Final Cut Pro (MacOS)
Find previous (in Find results)
Finding items

Shift + F3


JetBrains RubyMine (Windows)
Find Previous
Find and Replace

Shift + F3


JetBrains RubyMine (Linux)
Find Previous
Find and Replace

Shift + F3


JetBrains PyCharm (Windows)
Find Previous
Find and Replace

Shift + F3


JetBrains RubyMine (MacOS)
Show Bookmarks
Navigation Shortcuts

Shift + F3


JetBrains AppCode (MacOS)
Show Bookmarks
Navigation Controls

Shift + F3


Adobe Dreamweaver (Windows)
Find Previous
Find and Replace

Shift + F3


JetBrains PhpStorm (Windows)
Find Previous
Find and Replace

Shift + F3


Microsoft Word 2016 (MacOS)
Change letters to uppercase, lowercase, or mixed case
Frequently Used Shortcuts

Shift + F3


JetBrains PhpStorm (Linux)
Find Previous
Find and Replace

Shift + F3


Microsoft Excel 2016 (MacOS)
Display the Formula Builder
Frequently used shortcuts

Shift + F3


Microsoft Excel 2016 (MacOS)
Open the Formula Builder
Work in cells or the Formula bar

Shift + F3


Microsoft Word 2016 (MacOS)
Change the case of letters
Format characters

Shift + F3


DAZ Studio (Windows)
Find next
Script Commands

Shift + F3


Corel Draw X8 (Windows)
Change case
Font Formatting

Shift + F3


DAZ Studio (MacOS)
Find next
Script Commands

Shift + F3


Corel Quattro Pro X8 (Windows)
Displays List of Macro commands
EditMode Shortcuts

Shift + F3


Corel Quattro Pro X8 (Windows)
Shows List of Available Macros
Function Keys

Shift + F3


Microsoft Excel 2016 (MacOS)
Open the Formula Builder
The following table provides the function key shortcuts for Excel 2016 for Mac*

Shift +F3


Microsoft Word 2016 (MacOS)
Change letters to uppercase, lowercase, or mixed case
Function key shortcuts

Shift + F3


InCopy CC (MacOS)
Replace selected text with Change To text and find next
Find and Replace

Shift + F3


InCopy CC (Windows)
Replace selected text with Change To text and find next
Find and Replace

Shift + F3


Chief Architect (Windows)
Import Tools - Import Drawing (DWG,DXF)
Other Shortcuts

Shift + F3


Chief Architect (MacOS)
Import Tools - Import Drawing (DWG,DXF)
Other Shortcuts

Shift + F3


Brackets (Windows)
Find Previous
99 Shortcuts for Brackets (Windows)

Shift + F3


Informix Genero 2.5.0 (Windows)
Find previous
Find and Replace

Shift + F3


XYplorer (Windows)
Repeat Last Search
Function key Shortcuts

Shift + F3


Jetbrains CLion (Windows)
Find next/Find previous
Find and Replace

F3 / Shift + F3


MPS 2017 (Windows)
Navigate to the next/previous occurrence of a selected word in the editor
Search

F3 / Shift + F3


Pegasus Mail (Web Application)
Quick lookup
Addresses

Shift + F3


Visual Studio Code (Windows)
Find next/previous
Search and Replace

F3 / Shift + F3


Soundforge (Windows)
Find previous instance of last-searched text
Script Editor

Shift + F3


RStudio (Windows)
Find previous
Source

Shift + F3


CodeLite 10 (Windows)
Find previous
Search

Shift + F3


HyperWorks (Windows)
Edges (for equivalence)
24 Shortcuts for HyperWorks (Windows)

Shift + F3


Ansys Mechanical (Windows)
Activate Extend to Connection Selection
Selection Filters

Shift + F3


Comodo IceDragon (Windows)
Find Previous
Search Options

Shift + F3


Evergreen (Linux)
Retrieve Record by TCN
Cataloging

Shift + F3


VariCAD (Windows)
Information
Hot Keys

Shift + F3


PSPad (Windows)
Find Previous - Find previous occurrence
Search

Shift + F3


Wordfast Pro (Windows)
Uppercase / Lowercase
100 Shortcuts for Wordfast Pro (Windows)

Shift + F3


Wordfast Pro (MacOS)
Uppercase / Lowercase
100 Shortcuts for Wordfast Pro (MacOS)

Shift + F3


Target 3001! (Windows)
SchematicPCB(Without Cross Probe)
Function key Shortcuts

Shift + F3


BricsCAD (Windows)
Turns the Status Bar on/off (STATBAR command)
Other Shortcuts

Shift + F3


BricsCAD (Linux)
Turns the Status Bar on/off (STATBAR Ctrl)
Other Shortcuts

Shift + F3


BricsCAD (MacOS)
Turns the Status Bar on/off (STATBAR command)
Other Shortcuts

Shift + F3


SuperMemo (Windows)
Search Leeches
129 Shortcuts for SuperMemo (Windows)

Shift + F3


Microsoft Projects 2007 (Windows)
Reset sort order to ID order.
Navigate views and windows

Shift + F3


Adobe Reader 9 (Windows)
Find next / find previous (alternative is Ctrl+g / Ctrl+Shift+g)
Find and Select

F3 / Shift + F3


Open Office Impress (Windows)
Duplicate
Function Keys

Shift + F3


Microsoft Word 2010 (Windows)
Change between all upper-, first letter upper- and all lower-case
Navigate within Documents - Format Text

Shift + F3


Microsoft Excel 2007 (Windows)
Displays the Insert Function dialog box.
Function keys in Excel 2007

Shift + F3


Microsoft Word 2010 (Windows)
Change between all upper-, first letter upper- and all lower-case
Edit Documents - Format Text

Shift + F3


Microsoft Outlook 2007 (Windows)
Switch case (with text selected).
Shortcuts for Formatting Text

Shift + F3


Adobe After Effects CS5 (MacOS)
Toggle between Graph Editor and layer bar modes
Keyframes and Graph Editor

Shift + F3


Adobe After Effects CS5 (Windows)
Toggle between Graph Editor and layer bar modes
Keyframes and Graph Editor

Shift + F3


Microsoft Word 2010 (Windows)
Change between all upper-, first letter upper- and all lower-case
Formats - Format Text

Shift + F3


Microsoft Word 2010 (Windows)
Change between all upper-, first letter upper- and all lower-case
Manage Word View - Format Text

Shift + F3


Microsoft Word 2010 (Windows)
Change between all upper-, first letter upper- and all lower-case
Tables - Format Text

Shift + F3