Beginner level information
If you’re curious about the version of Excel you’re using and don’t know how to go about it, you’ve come to the right place. It could be as simple as selecting the Help Menu and clicking About Microsoft Office Excel, but then again, maybe not. The five options below will help you sort things out. …
One key to understanding Excel 2001 for Mac is knowing the keyboard shortcuts, but to communicate them requires displaying the symbols that are specific to a Mac keyboard. The Media Browser has a nice area for Symbols that gave me what I needed. There are a few different ways to access the Media Browser. One …
Sorry if I get transfixed by shortcuts in Excel 2011, but they are a vital part of how I use Excel and so much different than Excel for Windows, so anything that helps the learning curve is worth the effort. In looking for something else, I discovered you can change the keyboard shortcuts in Excel …
How many files will Excel show in the Recently Used File List? Well, it depends on the version of Excel you’re using and vary between 9 and ninety-nine files. Here is a list of Excel versions, menu navigation to the recent file list, and the max files allowed. Excel 2010, 2007 File>Options>Advanced tab>under the Display …
Since I’m relatively new to the world of Mac but an old hand with Windows, making an effort to discover Excel 2011 for Mac comes with some adjustments. Using the Function keys is one such irritation adjustment. You see, using Excel on a Windows machine allows you to use the function keys, like F1, F2, …
Every once in a while you get fixated on something and the only way to let it go is to share it with others. So …. while reviewing the logical IF function and nested IF statements, I came up with a chart or table, that sort of evolved out of curiosity. It started by looking …
The other day I found myself switching frequently between three worksheets in an Excel workbook. Having to grab the mouse, select another worksheet tab, then switch my hand back to the keyboard became annoying, so I looked up the keyboard shortcuts. Excel for Windows: Ctrl+PgDn — takes you to the next worksheet Ctrl+PgUp — takes …
I just found a new feature in Excel 2010 that will save you some time. There’s an optional feature at the bottom of the File>Recent menu to Quickly access this number of Recent Workbooks. When you already have a file open in Excel, clicking the File menu will default to the Info tab so you …
Formatting is second nature with Excel because ergonomically you want people to notice the information in your data and not spend time finding it, either because it doesn’t stand out, or it blurs together. Recently I came across a new wrinkle with the indentation of cell contents and thought to share it with you here. …