Excel can be a real know-it-all sometimes. Do you find yourself fighting with the software when it wants to auto correct certain letters or words that you type in...and that you know are correct? For example, I have a customer number that is WYA and Excel changes it to 'WAY' every time. Well, you can tell Excel not to make these types of corrections anymore!
Last week, we looked at how to arrange numerous Excel workbooks without have to spread windows out all over the place. But what if you want to arrange multiple worksheets in the same workbook. Can’t be done, right? Wrong! You can definitely do it! Heres's how.
Do you become an Excel contortionist, spreading new windows all over your many monitors every time you need to see data in two or more workbooks at the same time? If you need to view or compare the contents of multiple workbooks, there's a better solution. Clicking the Arrange All button from the Window group on the View tab of the ribbon will present you with several options to accomplish the same thing while saving real estate on your monitors. When the Arrange Windows window opens, you'll see several options: Tiled, Horizontal, Vertical or Cascade.
Even though the list of templates comes up first when starting Excel, most people just skip past it, unintentionally preferring the hard road of building new worksheets from scratch. Yet if you want a nicely formatted form, list, chart, or report but you don't have a lot of time - or ideas - Excel provides hundreds of templates at the ready to help you begin your project.
You may have dozens of Excel workbooks that you use, but chances are that there are a select few that you work with frequently and intensely. There are a couple ways within Excel to make those commonly used workbooks faster to access so that you can get your work accomplished with less clicking around.
When I'm teaching a class or doing a demo in Excel, people will often stop me suddenly and ask, "Wait, wait, wait! How did you just copy all of that data so fast?" Here's how you can speed things up for yourself.