Excel Shortcut KeyDescription Navigation Ctrl + F6Switches between workbooks. This is very useful when you have multiple workbooks open. Ctrl + Page UpSelect the previous sheet in the workbook. Ctrl + Page DownSelect the next sheet in the workbook. ...
Not only is it possible tomove between sheets in a workbookusing a keyboard shortcut, but you can also select multiple adjacent sheets with a keyboard shortcut as well. Simply add theShiftkey to the key combinations above. To select pages to the left: Ctrl+Shift+PgUp To select pages to t...
The keyboard shortcut to select the next sheet is: Ctrl+Page Down The keyboard shortcut to select the previous sheet is: Ctrl+Page Up These are great if you are toggling back and forth between two sheets. Just move the sheets next to each other. You can then copy/paste or audit the ...
Learn 50 most important excel shortcut keys that streamline data entry, formatting, and navigation, saving you time and boosting your productivity.
Find and Replace Shortcuts What it Does?Windows Shortcut Display Find and Replace Dialog Box (Find Selected)Ctrl + F Display Find and Replace Dialog Box (Replace Selected)Ctrl + H Find Next MatchShift + F4 Find the Previous MatchCtrl + Shift + F4 ...
Application.MacroOptionsMacro:="",HasShortcutKey:=True,ShortcutKey:="A"2．菜单通过在系统菜单上增加菜单项可以将操作提供给使用者，加载宏是对EXCEL基本功能的扩充，一般不提倡使用自定义菜单来代替系统菜单。3．工具栏可以使用EXCEL现有的工具栏上增加按钮也可以通过新建工具栏来完成。下面代码将前面的过程关联到...
ShortcutWindowsMacWeb Insert new worksheet Shift+F11 Fn+Shift+F11 Shift+F11 Delete selected worksheets Alt,E,L Alt,H,D,S Rename current worksheet Alt,O,H,R Go to next worksheet Ctrl+PgDn Fn+Ctrl+↓ Ctrl+Alt+PgDn Go to previous worksheet Ctrl+PgUp Fn+Ctrl+↑ Ctrl+Alt+PgUp Select adja...
(Shortcut) menu for the selected item Shift + F11 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) Shift + F12 Saves, Displays the (File > Save As) dialog box if a new workbook Ctrl + F1 Closes and reopens the current ...
While this is not one of the easy keyboard shortcuts, once you get used to it, you may find it a better way to rename sheets in Excel. Pro Tip: In case you want to move to the next sheet, you can use the keyboard shortcut Control + PageUp/PageDown (hold the Control key and ...
To add a tab with your mouse, go to the bottom of the page. In the left corner, you can see all the sheets in your workbook. Click on theplus button(New sheet), which is right next to Sheet1. A new tab is added and automatically named “Sheet” followed by a number. ...