Excel For Mac Switch Between Worksheets Keyboard Shortcut

admin
Excel For Mac Switch Between Worksheets Keyboard Shortcut Average ratng: 9,5/10 9512 reviews

Oct 28, 2015  While i have been using excel for over 25 years, only within the last two months have I been using it on a Mac. Clearly, excel is a much more robust program on a PC then a Mac. Since using MSFT office (excel) on the Mac, the only way I found to switch between work books was CTRL +. Ctrl + Tab = to switch between windows/files within a program Ctrl + Shift + Tab = to switch in reverse or Alt + Tab = to switch between open programs Alt + Shift + Tab = to switch in reverse Depending on how you have your system setup and which version of Excel you are using one of these should work.

When working with one Excel file (called a workbook) at a time, it is pretty easy to stay organized and move around easily. Opening a second Excel file can complicate things a little bit. Trying to move between multiple Excel worksheets can get even more problematic, especially if you need to look back and forth quickly. Then, make it more difficult by moving within the worksheets within the different files.

An example of this is when you are working on your budget from the last year or two to create your upcoming budget. If you have worksheets from several departments within each budget file, it can get really confusing. You can have all of the workbooks open but just look at one at a time. Or, you are able to view the workbooks side by side, tiled, cascaded, etc. There are several different ways to move around and switch between files.

Between

The great thing about many of these methods is that they can also be used to move between any of the open files on your computer. I have highlighted the most popular ways below. Switch Windows One option to switch between the open Excel files is to use the View tab on the ribbon. Go to the View tab and click on the Switch Windows button.

Pick the workbook you would like to move to from the list of available open files. There will be a check next to the file that you are currently viewing for easy reference. See Figure 1.

Figure 1 Personally, I don’t like having to click on the View tab and then a button and then a file from the list. I really wanted a faster way. By adding the Switch Windows button on the Quick Access toolbar, I was able to cut down on my clicks. I cover how to do that next. Switch Commands – Quick Access toolbar The Quick Access toolbar is located at the top left of the window by default.

It usually has the save, undo, and redo buttons. You can right-click it or right-click anywhere on the ribbon or any of the tabs to get a pop-up menu. Choose “Customize Quick Access Toolbar” from that pop-up menu. See Figure 2. Figure 2 The following dialog box will appear.

See Figure 3. Figure 3 Click the “Choose commands from” drop-down list (near the top center) and select “View Tab”. This will have all of the buttons and more from the View tab that you can add to your Quick Access Toolbar. In the list, scroll down and find “Switch Windows”. Then click the “Add>>” button in the middle to move that command to the right-hand list.

This list (on the right) is what you want to show on the Quick Access Toolbar. If you want to change the location of the button on the toolbar, you can move it up and down. (While you are here, you might want to explore to see if there are other commands you’d like to include.) Click OK when you are done.

See Figure 4. See Figure 5 to see what the Quick Access toolbar will now look like. Figure 4 Figure 5 Switch Windows – Keyboard Shortcut To move back and forth between any open windows (of all file types and browsers), you can use the combination ALT + TAB. You can hold the ALT key down and press TAB to cycle through all of the files until you get to the one you want. Side by Side (Synchronous scrolling) If you have two Excel files open at the same time, you can view them in Side by Side mode.

Xee can also display huge amounts of metadata from image files. Free quick fixes for mac osx windows 10.