Step 2: Click on the Find & Select option then choose the “ Go To” Option. Step 1: Navigate to the Edit menu option. Therefore, it is advised to use this command only when you have an excel file with a large amount of data. It is not useful for the worksheets containing a very low volume of data. If you have an Excel sheet with loads of data, Go To command can help you to navigate to different cells. To move to the other sheet to the right press and release the PgDn key a second time.Īlso Read: What is an XLSX file & How to open XLSX File? Method 2: Go To Command to move around excel worksheets Press and release the PgDn key on the keyboard.ģ.

To move another sheet to the left press and release the PgUp key a second time.Ĭtrl + PgDn (page down) - Move one sheet to the right.Ģ. Press and release the PgUp key on the keyboard.ģ. Press and hold down the Ctrl key on the keyboard.Ģ. Quickly Switch Between Worksheets in Excel Method 1: Shortcut Keys to switch between Worksheets in ExcelĬtrl + PgUp (page up) - Move one sheet to the left.ġ. Therefore, Excel shortcuts are the most useful ways to speed up your work process. Sometimes, your touchpad or mouse stopped working and in that situation, keyboard shortcuts come very handy. Using shortcut keys does not make you lazy but it increases your productivity and saves you a lot of time that you can spend in other work. Let’s discuss the methods through which you can easily switch between different worksheets in one excel. And these shortcuts can be helpful in increasing your productivity. Therefore, having knowledge about shortcuts and short keys will be very useful. However, when it comes to managing plenty of worksheets in one excel, it is a very tedious task. The most common method of switching tabs is clicking on each tab. Sometimes switching between few worksheets seems easy. If you use Microsoft Excel frequently you might have noticed that switching between different worksheets in excel is quite difficult.

Excel page down shortcut