On a Mac, Command M minimizes the current worksheet into the dock. You can use Control + F10 to maximize it again. In windows, the shortcut minimizes the current worksheet. To minimize the current worksheet window, use Control + F9 in windows, and Command M on a Mac.
In Windows, this will toggle the windows inside the Excel application. On a Mac, this will toggle the window to full screen. To toggle the window size for the current worksheet, use Control + F10.
Add Shift to reverse direction.Īgain, on a Mac, add the function key this shortcut. When you have a worksheet that's split, use F6 to move to the next pane. If the active cell is in the middle somewhere, you'll get 4 panes. Move the active cell to row 1 to split vertically into two panes.Īnd, move the active cell to column A to split horizontally into two panes. Move the active cell to row 1 to split vertically into 2 panes.Īnd move the active cell to column A to split horizontally into 2 panes. There is no dedicated shortcut in Excel to split the screen, but you can use Alt + W + S in Windows to toggle a split screen on and off. Then type the number for the worksheet you want. In Windows, you can also switch workbooks by using the ribbon, with Alt + WW. When you have multiple workbooks open, you can move to the next workbook using control + tab. Any change you make will affect all worksheets! Multiple non-adjacent worksheets, use the control key in Windows and the Command key on a Mac.īe careful when you have multiple worksheets selected. To select multiple worksheets, you can hold down the shift key and click. To add a new worksheet to a workbook, use Shift + F11. To open a menu that lets you navigate through all worksheets on a workbook, right-click the worksheet navigation area, then select a sheet. On a Mac, you can also use Option plus right and left arrow keys to move through worksheets. To move to the previous worksheet, use Control + Page up on Windows, Fn + Control + up arrow on a Mac.
In a workbook that contains multiple worksheets, you can go to the next worksheet using Control + PgDn on Windows, Fn + Control + down arrow on a Mac. In this video, we'll look at shortcuts you can use the navigate through one or more workbooks.
0 kommentar(er)
