HomeApplicationOffice information

Shortcut switch Sheet in Excel

Are you looking for a shortcut combination to quickly switch Sheet in Excel to make the process of working between sheets faster? Below the article shared to you the Sheet shortcut shortcut in Excel, please follow along.

Shortcut switch Sheet in Excel Picture 1

The shortcut combination switches Sheet in Excel

  1. Ctrl + Page Up moves to the sheet in front of the current sheet.
  2. Ctrl + Page Down moves to the next sheet.

Shortcut switch Sheet in Excel Picture 2

Note: Some computers if you can not press the above combination, you can press Ctrl + Fn + Page Down / Up.

On a Macbook , the shortcut to switch Sheet in Excel is to use the Option + arrow keys left (to right) to move back the sheet in front of the current sheet (move to the next sheet of the current sheet).

Shortcut switch Sheet in Excel Picture 3

If there are multiple sheets, right-click on the lower left corner and select to Sheet to move to.

Shortcut switch Sheet in Excel Picture 4

You can refer to the common keyboard shortcuts in Excel here http://TipsMake.vn/cac-phim-tat-trong-excel/

So you know the shortcut to switch Sheet in Excel, hope it will help you. Good luck!

4 ★ | 1 Vote

You should read it

May be interested

  • How to copy sheet from Excel file to another Excel fileHow to copy sheet from Excel file to another Excel file
    while working with excel, there are times when you want to copy the sheet from one excel file to another excel file to facilitate data processing. if you do not know how to copy sheet, please refer to how to copy sheet in excel to other excel file in this article.
  • How to Unprotect an Excel SheetHow to Unprotect an Excel Sheet
    this wikihow teaches you how to unprotect a sheet within a microsoft excel workbook in windows or macos. if the sheet is protected by a password and you're not sure what it is, you can use google sheets or a vba script (in earlier versions...
  • Instructions for copying or moving Worksheet in Excel 2013Instructions for copying or moving Worksheet in Excel 2013
    the move or copy command allows you to easily move or copy the entire worksheet, including all data and formats in excel, in case you create a new sheet or a new book that wants to copy data from excel. old to.
  • Tips with spreadsheets (sheet) in ExcelTips with spreadsheets (sheet) in Excel
    in excel spreadsheets to manage excel data using sheet tabs, you can easily add, delete, rename or customize the settings as you like for the worksheets in excel worksheet. here are some basic tips when working with sheets in e
  • Insert line shortcut in Excel - Shortcut insert ExcelInsert line shortcut in Excel - Shortcut insert Excel
    insert line shortcut in excel - shortcut insert excel. inserting lines into a table in excel is an extremely basic operation, but many users don't know the keyboard shortcuts to do this faster than just using the keyboard. the following dexterity software will introduce readers a number of ways to add lines quickly.
  • What can the shortcut Ctrl + E in Excel do?What can the shortcut Ctrl + E in Excel do?
    the shortcut ctrl + e in excel is a very familiar shortcut and you can do a lot with this shortcut such as merging data in excel tables, separating data in excel,...
  • How to convert speakers with a shortcut on Windows 10How to convert speakers with a shortcut on Windows 10
    usually to switch using audio devices, you need to click the speaker icon in the system tray. however, you can perform this operation with a shortcut key combination.
  • Part 4: Hide Sheet, Sheet tab, Scroll Bar, WorkbookPart 4: Hide Sheet, Sheet tab, Scroll Bar, Workbook
    types of data hiding in excel - part 4: hide sheet, sheet tab, scroll bar, workbook
  • How to create a two-screen switch mode shortcut on Windows 10How to create a two-screen switch mode shortcut on Windows 10
    display switch is used to change the display mode between the main screen and the screens connected to it. this article will show you how to create or download the display switch shortcut in windows 10.
  • How to Unprotect Excel SheetHow to Unprotect Excel Sheet
    tipsmake today will show you how to unprotect worksheets in microsoft excel workbooks on windows or macos. if the sheet is password protected and you don't know it, you can use google sheets or a vba script (on earlier versions of excel) to remove the protection.

Office information