Hotkey to switch tabs1/6/2024 In Excel 2010 and earlier versions, we right-click on the arrows in the status bar to display the sheets list and switch between worksheets from the context menu.We can also quickly switch between sheets by right-clicking on the arrows in the status bar and selecting the desired worksheet. Keyboard Shortcut to Switch Tabs Method 2. When we press Ctrl + Page Up shortcut keys we shift towards the left of the current sheet and repeat this till we locate the desired sheet.įigure 2.If we want to move towards the right of the current sheet then we press shortcut Ctrl + Page Down and keep on pressing until we reach the desired tab.Using shortcut keys of Ctrl + Page Up or Ctrl + Page Down keys we can quickly move towards left or right of the sheet. ![]() Therefore, we need to learn how to switch tabs by using shortcut techniques to quickly move between sheets. This makes it difficult to locate our targeted sheet out of many sheets. When our data set grows up we keep on adding the worksheets or tabs in the workbook. Switch Between Sheets How to Switch Between Tabs ![]() Using the shortcut to switch tabs is a more effective way instead of switching the sheets by clicking on the right and left arrow.įigure 1. How to Switch Between Tabs in Excel – ExcelchatĪn Excel Workbook may contain multiple sheets or tabs and while working on different parts of data we need to quickly switch between tabs in excel.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |