Excel Switch Between Worksheets How To Create A

Thanks again for all of your resources, classes, tips and advice.

So in this post I share a few quick tips and shortcuts to save time with navigating your workbook.

The quickest way to make a duplicate copy of a sheet is using the CtrlDrag method.

Its much faster than right-clicking the tab and going to the Move or Copy menu.

There were dedicated buttons to scroll to the first or last sheet in the workbook.

These actions were consolidated into the sheet navigation buttons in the bottom left corner of the application window.

You can see this tip by hovering your mouse over the buttons.

This is much faster than scrolling, then selecting the firstlast sheet with the mouse.

You can then copypaste or audit the sheets without having to navigate all over the workbook.

Checkout my post on Best Keyboards for Excel Keyboard Shortcuts to learn more.

You can continue to press this shortcut to select multiple sheets.

This is a great time saver if you want to modify the value, formula, or formatting of specific cells on multiple sheets at the same time.

I wish the application would turn a different color, or do a better job of warning us.

Sometimes you wont be able to undo the changes, and then have to pray that you saved the file.

Any edits you make to the active sheet will also be made on all of the other selected sheets.

When you right-click a tab and choose Unhide, you can only select one sheet from the list of hidden sheets in the Unhide window.

You can then double-click a sheet in the list to jump to it.

If youd like to learn more about macros VBA then checkout my free training webinar that is going on right now.

What are your favorite shortcuts for working with sheet tabs Please leave a comment below with your suggestions, or any questions.

I just copy paste each tab title into one sheet, but its time consuming.

Excel Switch Between Worksheets How To Create A

In my free webinar on macros VBA I actually explain how to create a list of all sheets in the workbook using a For Next Loop.

Click on a blank tab at the bottom of the worksheet then paste onto the blank worksheet.

Im a heavy keyboard user and so always look for ways to keyboard things vs.

Of course, you can do the same with mouse clicks, but keyboarding is almost always faster and more efficient, once you train your brain and fingers with the procedure.

Excel For Mac Switch Between Worksheets