Easy-XL - Excel Data Analytics Made Simple

File: CabArc.Exe - Microsoft Cab File Archive Utility

file.png
Uploaded:
28.12.09
Modified:
28.12.09
File Size:
63 KB
Downloads:
21926
Version
5.2.3790.0

Site Login

Shopping Cart

MrExcel Podcasts

Learn Excel from MrExcel
New Excel Tips & Tricks Every Weekday!
  • Excel Search Entire Workbook
    You need to find something, but you don’t know what worksheet it is on.   Display Find with Ctrl+F Click the Options > > button. Open the Search dropdown and change from Sheet to Workbook.
  • 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(...)