Know all the spreadsheet keyboard shortcuts | Zoho Sheet Help Guide

Know all the keyboard shortcuts for sheet

Here's the list of Zoho Sheet's keyboard shortcuts for Mac and Windows:

Shortcuts for file operations

Description
Mac
Windows
Open file
Cmd + O
Ctrl + O
Save as file
Cmd + Shift + S
Ctrl + Shift + S
Print file
Cmd + P
Ctrl + P

Shortcuts for edit actions

Description
Mac
Windows
Undo last action
Cmd + Z
Ctrl + Z
*Redo last action
Cmd + Option + Y
Cmd + Y
Ctrl + Alt + Y
Ctrl + Y
Repeat last action
Alt + Enter
Alt + Enter
Cut
Cmd + X
Ctrl + X
Copy
Cmd + C
Ctrl + C
Paste
Cmd + V
Ctrl + V
Insert rows
Cmd + Shift + =
Ctrl + Shift + =
Insert columns
Cmd + Shift + =
Ctrl + Shift + =
Delete rows
Cmd + Alt + -
Ctrl + Alt + -
Delete columns
Cmd + Alt + -
Ctrl + Alt + -
Insert a new worksheet
Shift + F11
Shift + F11
Hide rows
Cmd + Alt + 9
Ctrl + Alt + 9
Hide columns
Cmd + Alt + 0
Ctrl + Shift + 0
Unhide rows
Cmd + Shift + 9
Ctrl + Shift + 9
Unhide columns
Cmd + Shift + 0
Ctrl + Shift + 0
Run macros/ View macro list
Alt + F8
Alt + F8
Open VBA editor
Alt + F11
Alt + F11
*Add/ Edit hyperlink
Cmd + Option + K
Cmd + K
Ctrl + Alt + K
Ctrl + K
Add/ Edit cell note
Shift + F2
Shift + F2
Add comment
Cmd + Alt + M
Ctrl + Alt + M
*Fill down
Cmd + Option + D
Cmd + D
Ctrl + Alt + D
Ctrl + D
*Fill to the right
Cmd + Option + R
Cmd + R
Ctrl + Alt + R
Ctrl + R
Filter
Cmd + Shift + L
Ctrl + Shift + L
Reapply filter
Cmd + Alt + L
Ctrl + Alt + L
Find within spreadsheet 
Cmd + F
Ctrl + F
*Replace
Cmd + Shift + H
Ctrl + H
Ctrl + Shift + H
Ctrl + H
Named ranges
Cmd + F3
Ctrl + F3
Insert the current date in the cell
Cmd + ;
Ctrl + ;
Insert the current time in the cell
Cmd + Shift + ;
Ctrl + Shift + ;
Insert current date and time in the cell
Cmd + Alt + ;
Ctrl + Alt + ;
Display the auto suggest list (Pick from list)
Alt + Down
Alt + Down
Group rows/columns
Alt + Shift + Right
Alt + Shift + Right
Ungroup rows/columns
Alt + Shift + Left
Alt + Shift + Left
Toggle auto completion on/off
Ctrl + Shift + Q
Ctrl + Shift + Q
Convert selected range into a table
Cmd + Alt + T
Ctrl + Alt + T
Edit active cell
F2
F2
Cancel cell entry
Esc
Esc
Focus formula field
Cmd + Shift + F
Ctrl + Shift + F
Delete content of selected cell/ cell range
Delete
Backspace
Delete format of selected cell/ cell range
Shift + Delete
Shift + Backspace
Delete content and format of selected
cell/ cell range
Cmd + Delete
Ctrl + Backspace
Delete one character to right while typing
in a cell
Fn + Delete
Delete
Delete one character to left while typing
in a cell
Delete
Backspace
Insert line break in cell
Alt + Enter
Alt + Enter

Shortcuts for menus

Description
Mac
Windows
File
Ctrl + Option + F
Ctrl + Alt + F
Edit
Ctrl + Option + E
Ctrl + Alt + E
View
Ctrl + Option + V
Ctrl + Alt + V
Insert
Ctrl + Option + I
Ctrl + Alt + I
Format
Ctrl + Option + O
Ctrl + Alt + O
Data
Ctrl + Option + A
Ctrl + Alt + A
Tools
Ctrl + Option + S
Ctrl + Alt + S
Help
Ctrl + Option + H
Ctrl + Alt + H


Shortcuts for navigation

Description
Mac
Windows
Move to next cell in row 
Tab
Tab
Move to previous cell in rowShift + Tab
Shift + Tab
Up one screen
Page Up
Page Up
Down one screen
Page Down
Page Down
Go to first cell in the data region
Cmd + Home
Ctrl + Home
Go to last cell in the data region
Cmd + End
Ctrl + End
Go to cell command
Cmd + G
Ctrl + G
Data region left
Cmd + L
Ctrl + L
Data region right
Cmd + R
Ctrl + R
Data region down
Cmd + Down
Ctrl + Down
Data region up
Cmd + Up
Ctrl + Up
Focus name box
Ctrl + Shift + N
Ctrl + Shift + N
Move to a next worksheet in a spreadsheet
Alt + Right
Alt + Right
Move to a previous worksheet in a spreadsheet
Alt + Left
Alt + Left
Feature Finder
Cmd + Shift + Space
Ctrl + Shift + Space


Shortcuts for formatting

Description
Mac
Windows
Bold toggle for selection
Cmd + B
Ctrl + B
Italic toggle for selection
Cmd + I
Ctrl + I
Underline toggle for selection
Cmd + U
Ctrl + U
Strikethrough toggle for selection
Cmd + Shift + X
Ctrl + Shift + X
*Open format cells dialog
Cmd + Option + 1
Cmd + 1
Ctrl + Alt + 1
Ctrl + 1
Apply number format
Ctrl + Shift + 1
Ctrl + Shift + 1
Apply time format
Ctrl + Shift + 2
Ctrl + Shift + 2
Apply date format
Ctrl + Shift + 3
Ctrl + Shift + 3
Apply currency format
Ctrl + Shift + 4
Ctrl + Shift + 4
Apply percentage format
Ctrl + Shift + 5
Ctrl + Shift + 5
Apply scientific format
Ctrl + Shift + 6
Ctrl + Shift + 6
Cancel format painter
Esc
Esc
Increase indentation for selected cell/ cell range
Cmd + M
Ctrl + M
Decrease indentation for selected cell/ cell range
Cmd + Shift + M
Ctrl + Shift + M

Shortcuts for selection 

Description
Mac
Windows
Select whole spreadsheet
Cmd + A
Ctrl + A
Select column
Ctrl + Space
Ctrl + Space
Select row
Shift + Space
Shift + Space
Select from current cell to the first cell A1
Ctrl + Shift + Home
Ctrl + Shift + Home
Select from current cell to the last cell in the data region
Ctrl + Shift + End
Ctrl + Shift + End
Select from current cell to the first cell in the same row
Shift + Home
Shift + Home
Select from current cell to the last cell in the same row
Shift + End
Shift + End
Select data region to the left
Cmd + Shift + Left
Ctrl + Shift + Left
Select data region to the right
Cmd + Shift + Right
Ctrl + Shift + Right
Select data region to the up
Cmd + Shift + Up
Ctrl + Shift + Up
Select data region to the down
Cmd + Shift + Down
Ctrl + Shift + Down
Extend selection up one screen 
Shift + Page Up
Shift + Page Up
Extend selection down one screen 
Shift + Page Down
Shift + Page Down

Shortcuts for formula related actions

Description
Mac
Windows
Start a formula
=
=
Recalculate formulas
F9
F9
Toggle absolute and relative references
F4
F4
Auto sum
Alt + =
Alt + =
Show function dialog box
Shift + F3
Shift + F3
Toggle expand and collapse of formula bar
Cmd + Shift + U
Ctrl + Shift + U
Insert array formula on a range of cells
Cmd + Shift + Enter
Ctrl + Shift + Enter
Select the range of array formula cells surrounding a cell
Cmd + /
Ctrl + /

Shortcuts for objects 

Description
Mac
Windows
Select or focus the object
Cmd + Click
Ctrl + Click
Move the selected object in the desired direction 
Arrow
Arrow
Snap the object's left/ top with the adjacent cell
Cmd + Arrow
Ctrl + Arrow
Snap the object's right/ bottom with the adjacent cell
Cmd + Shift + Arrow
Ctrl + Shift + Arrow
Navigate to the next object
Tab
Tab
Navigate to the previous object
Shift + Tab
Shift + Tab
Edit mode
F2
F2
Return the focus to the active cell
Esc
Esc
Cancel dragging the object
Esc
Esc


The keyboard shortcuts marked with * denote those which are similar to the browser shortcuts. 

What are overriding keyboard shortcuts and how do they work?

Shortcut keys in Zoho Sheet that are similar to browser's shortcuts are called overriding keyboard shortcuts. By default, the Override browser shortcuts option will be enabled, allowing Zoho Sheet's shortcuts to work instead of your browser's shortcut. To use your browser's shortcuts, you can disable the Override browser shortcuts option. The below table contains the list of overriding keyboard shortcuts in Zoho Sheet.


Description
Mac
Windows
Redo last action
Cmd + Y
Ctrl + Y
Add/ Edit hyperlink
Cmd + K
Ctrl + K
Fill down
Cmd + D
Ctrl + D
Fill to the right
Cmd + R
Ctrl + R
Replace
Ctrl + H
Ctrl + H
Open format cells dialog
Cmd + 1
Ctrl + 1









    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • SHEET

                                                                                                                Returns the sheet number for a given cell reference.   Syntax   SHEET(cell_ref) cell_ref: The cell reference whose sheet number you want. If omitted, it returns the sheet number of the current cell containing the formula. E.g. SHEET.A1   Remarks The ...
                                                                                                              • Working with Zoho Sheet

                                                                                                                Here are a few things that we'd like for you to know about Zoho Sheet as you get started: Maximum file size allowed for import 25 MB Maximum number of rows 131072 Maximum number of columns 1024 Maximum number of cells 5 Million Maximum number of ...
                                                                                                              • Custom functions in Zoho Sheet

                                                                                                                Though Zoho Sheet supports around 400 functions by default, for simple and complex calculations, we understand that our users have their own business logic that requires personalized functions. Additionally, Zoho Sheet also allows you to bring in ...
                                                                                                              • Configure and enable OpenAI in Zoho Sheet

                                                                                                                ChatGPT by OpenAI is a generative artificial intelligence tool that processes the given queries and provides detailed responses. Zoho Sheet's integration with OpenAI will enhance the way you analyze your spreadsheet data with advanced AI features. ...
                                                                                                              • About Zoho Sheet

                                                                                                                Zoho Sheet is a cloud-based spreadsheet application. It allows you to create, share, and work together on spreadsheets online, in real time. You can analyze, visualize and publish data using Zoho Sheet across multiple devices and browsers. ​
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources