About Bill Jelen

http://www.mrexcel.com

Posts by Bill Jelen:

Copy Excel Worksheet – Easy and Fast

               

You’ve created the perfect report for January. Now you need to make 11 copies for the other months. Hold down the Ctrl key. While holding down the Ctrl key, click on the sheet tab and drag to the right. You should see the mouse pointer change to an arrow pointing to a sheet with a(…)

Use Wheel Mouse to Scroll Left & Right in Excel

               

Sure… you can roll the mouse wheel to scroll up and down… What about left and right? Your mouse wheel can be pushed in, like you are clicking a button on the mouse, but you are “clicking” the mouse wheel. While you hold the mouse wheel down, move the mouse left or right to scroll!(…)

Move to Top of Selection in Excel

               

You start at the top of the data set. You press Ctrl+Shift+DownArrow and Ctrl+Shift+RightArrow. This is great… you’ve selected the whole data set, but now how do you get back to see the top of the selection? Press Ctrl+Period twice. Each press of Ctrl+Period keeps the current selection but moves to the next corner (in(…)

Easy Territories in Excel Pivot Tables

               

You pivot table has a list of cities, but no Territory field: There is an easy way to create a virtual Territory field: 1) Select the cities in the first territory (Click on first city, Ctrl+Click on others) 2) In the Pivot Table Tools ribbon, click Group Selection. 3) By default, they call the territory(…)

View 2 Excel Workbooks Side by Side where both Scroll!

               

Need to see two workbooks side by side?   With both workbooks open, go to the View tab and click View Side by Side. This column of 3 icons are the first to shrink on this ribbon tab, so most of the time it is a tiny unlabeled column as you see on the right.(…)

Learn Excel from MrExcel