Excel 2008 | Excel Semi-Pro

Excel 2008

A Dynamic Dependent Drop Down List with a Horizontal Table Reference

April 9, 2012 Formulas

I received a comment asking if a dynamic dependent drop-down list in Excel could have a list where the “table headers were actually rows and not columns?” Since I’ve already detailed how this is done in the article mentioned above, I’ll keep this short. The screen shot below is what I’ll be referencing. At the […]

Get the full story …

How to Update a List or Range without OFFSET

March 22, 2012 Formulas

I avoid the use of Volatile Functions, especially OFFSET, which is commonly used to update a list or range. They can slow down the operation of your workbook. For very large workbooks with lots of data, it can be significant and irksome. Worksheet cells that use Data Validation for a drop-down list can simplify the […]

Get the full story …

Select Excel’s Used Range on a Mac

March 20, 2012 Beginner

I recently read a good blog post over at Contextures about selecting the actual used range on an Excel sheet, both manually and with VBA. However, using Excel on a Mac makes you keenly aware that there’s no Home button. The used range on a worksheet starts with cell A1 and ends with the last […]

Get the full story …

An Excel Crossroads – Mac and Windows

January 5, 2012 General Update

I bought a MacBook Pro and installed Windows 7 with Boot Camp Assistant so I could access the “normal” Excel. This was important to me at the time because I was doing Excel development work in versions 2003, 2007 and 2010 on a Windows PC. I love my MacBook Pro, which I consider my computer […]

Get the full story …

Microsoft Query Incompatible with Mac OS X Lion [Updated]

July 12, 2011 Advanced

The other day I read an article on how to prepare my MacBook Pro for Lion, the new Mac OS X coming out this month, and discovered that any application that requires PowerPC is incompatible with Lion and will not work. See update at the end of this post. So I followed the instructions to […]

Get the full story …

That Damn Delete Key in Excel for Mac

June 27, 2011 Beginner

I have no earthy idea why it took me so long to figure out how to delete the contents of a cell or range in Excel for Mac. Ever since I bought my MacBook Pro I’ve known the Delete key on a Mac isn’t really a Delete key. I mean, since my background is with […]

Get the full story …

Create a List in Excel 2008

May 3, 2011 Features

I was surprised to find a List Wizard in Excel 2008 (Mac) because Excel 2007 (Windows) has Tables, and had already been out for nearly a year when Excel 2008 was released. Here I’ll walk you through the process of setting up a List in Excel 2008 but won’t go into every detail because, as […]

Get the full story …

The Repeat Command in Excel for Mac

January 10, 2011 Intermediate

Adding the Repeat command icon to the Quick Access Toolbar in Excel for Windows is a simple process that I explained in a blog post last week. Excel for Mac — 2011 or 2008 — doesn’t have a Quick Access Toolbar, but you can customize the toolbars and menus. Add the Repeat Icon to the […]

Get the full story …

What Version of Excel am I Using?

January 3, 2011 Beginner

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. […]

Get the full story …

Apple Keyboard Symbols in Excel

December 23, 2010 Beginner
Thumbnail image for Apple Keyboard Symbols in Excel

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 […]

Related Posts Plugin for WordPress, Blogger...
Get the full story …