Features | Excel Semi-Pro


Where is Control+Home for Excel on a Mac

April 28, 2013 Features

I wrote a post stating that I could not find the Windows Ctrl+Home keyboard shortcut equivalent on a Mac. Well I’m here to tell you that I found the keyboard shortcut combination that does the same thing on a Mac. The Excel Gods are with me. Hallelujah! Finding My Way Home The key to finding […]

Get the full story …

Control + Home in Excel for Mac

June 30, 2012 Features

One of my all-time favorite keyboard shortcuts in Excel is CTRL+Home, but on a Mac there is no Home button. Hence a constant source of frustration these last two years. I finally decided to do something about that and recently figured out a solution using VBA and the Personal Macro Workbook. But before I go […]

Get the full story …

Zoom to 125 Percent – Excel 2011 Default Workbook

August 29, 2011 Features

I want to have Excel 2011 (for Mac) open to a blank worksheet that is zoomed to 125% and it has taken a very long time to figure this out. It involves saving a template to a buried location, then manipulating the file in Finder to remove the extension. Simple, once you know the trick. […]

Get the full story …

Settings and Shortcuts for Excel 2003

August 23, 2011 Beginner

I recently found myself with a new, loaner laptop and a brand new copy of Excel 2003 as my default spreadsheet program. This was fine until I realized there were a number of things “missing.” Like shortcuts and settings that I’ve changed over the years to make Excel serve me, instead of the other way […]

Get the full story …

Where is the Insert Tab in Excel 2011?

May 17, 2011 Features

Switching to the Mac platform finds you with certain disappointments challenges. One of these is finding no Insert Tab on the Excel 2011 Ribbon. Windows versions of Excel (2007 and 2010) both have the Insert Tab on the Ribbon. So when you start using the new Mac version of Excel 2011, you can quickly become […]

Get the full story …

Worksheet Tab Protection Icon in Excel 2011

May 11, 2011 Features

There are times when you see something new and immediately know what it means. That’s what happened to me when I opened a file from a colleague and realized the padlock icon on the worksheet tab meant that the worksheet was protected. I was right. Since I had opened this file in Excel 2011 (Mac) […]

Get the full story …

Ribbon Home Tab Comparison – Excel 2010 Windows and 2011 Mac

May 5, 2011 Features

I’ll review each hard-to-find item on the Ribbon’s Home Tab in Excel 2010 (Windows) and let you know where they are located in Excel 2011 (Mac). I’ve even got some nifty pictures to speed along that understanding. Note: The Ribbons in Excel 2010 and 2007 (Windows) are interchangeable, but I’ll only refer to 2010 below. […]

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 …

Create a List in Excel 2003

April 30, 2011 Features

The forerunner of the modern Excel Table is know as a List Object. Excel 2003 has this feature, and I’ll simply refer to it here as a List. To create a List in Excel 2003, select your existing data table and choose Data > List > Create List…, or use the keyboard shortcut Ctrl+L. Excel […]

Get the full story …

Spreadsheet Size in Excel for Windows

April 29, 2011 Beginner

I’ve been thinking about converting my older XLS files to the newer XLSX format, but ran into a quirk that stopped me. Maybe I’m just too impatient. Here’s my story. A Few Facts First Excel versions 97-2003 (Windows) have a file extension of XLS and the worksheet size is 65,536 rows and 256 columns. In […]

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