Excel For Mac Articles
Articles tagged Excel For Mac, including related tutorials, examples, and walkthroughs.
37 articles
How to Add Cells in Excel to Sum Up Totals Automatically
Excel's great for displaying data and even better at crunching numbers. Here's how to add cells in Excel to sum up totals automatically... Even when you change the numbers....
Where is Control+Home for Excel on a Mac
The control + home keyboard shortcut in Excel for Windows is replicated in Excel for Mac by either fn+control+left arrow or fn+command+left arrow....
Add Macro Button to the Toolbar in Excel 2011
Here is a short tutorial on how to add a macro button to the toolbar in Excel 2011, with a few tips on how to change the button image....
Control + Home in Excel for Mac
I figured out how to get a Control + Home keyboard shortcut to work in Excel 2011 (for Mac). It's an Excel Windows favorite of mine....
A Dynamic Dependent Drop Down List with a Horizontal Table Reference
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...
How to Update a List or Range without OFFSET
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....
Select Excel's Used Range on a Mac
Selecting the used range in an Excel worksheet is complicated by not having a Home button on the Mac keyboard. Some VBA code can solve this problem....
An Excel Crossroads - Mac and Windows
The Mac is my computer of the future but I need Windows versions of Excel, so enter Parallels software to make things easy to decide the issue....
Pay Periods and Funky PivotTable Controls
Use a PivotTable to find how many months in a year have an extra pay period. Excel 2011 PivotTable controls are funky looking, comparatively speaking....
Microsoft Query Incompatible with Mac OS X Lion [Updated]
Excel for Mac users should beware, Microsoft Query is an incompatible app in the upcoming Lion upgrade for Mac OS X....
That Damn Delete Key in Excel for Mac
The Delete Key on a Mac doesn't work in Excel for Mac to delete cell and range contents like a Windows computer. fn+Delete is the magic combination....
A Dynamic Dependent Drop Down List in Excel
Learn how to create dynamic dependent drop-down lists in Excel....
Where is the Insert Tab in Excel 2011?
The Excel 2007 and 2010 Ribbon both have an Insert Tab, which does not exist in Excel 2011 (Mac). Here is a chart to tell where each item is located....
Worksheet Tab Protection Icon in Excel 2011
I opened a file from a colleague and realized that the padlock icon on the worksheet tab meant that the worksheet was protected. Only in Excel 2011....
Ribbon Home Tab Comparison - Excel 2010 Windows and 2011 Mac
The Ribbon Home Tab in Excel 2010 (Windows) is quite different than in Excel 2011 (Mac) so here is a guide to finding those things that seem lost....
Create a List in Excel 2008
The List feature in Excel 2008 is a hybrid with a List Wizard providing lots of functionality. However a List with a Defined Name is not updated....
My First Excel 2011 Chart
My first chart made in Excel 2011 with a data table below, a sparkline chart, and a picture of the ski slope. The chart shows break a event point....
Sorting Columns From Left To Right in Excel Causes Problems
You may never have the opportunity to Sort columns of data from Left to Right , but beware of some apparent problems . A reader mentioned that when sorting from...
F2 in Excel for Mac
The F2 key is a fundamental shortcut in Excel for Windows. But how works F2 in Excel for Mac?...
Excel 2011 Preferences
Default Preferences that should be changed in Excel 2011 [Mac] for General, View, Edit, Calculation, and Ribbon....
Excel 2011 Keyboard Shortcuts on Your Desktop
Locate Excel 2011 Keyboard Shortcuts Help web page and save to your computer for off-line access via your web browser, Firefox, Chrome, or Safari....
The Repeat Command in Excel for Mac
Add the Repeat command icon to the Standard Toolbar in Excel for Mac, 2011 and 2008, from the Customize Toolbars and Menus dialog box....
What Version of Excel am I Using?
A reference to find out what version of Excel you are using. Excel for Windows - versions 2010, 2007, 2003. Excel for Mac - versions 2011, 2008....
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 M...
Keyboard Shortcuts in Excel 2011
Create, Delete, or Peruse Keyboard Shortcuts in Excel 2011 or 2008 by using the Customize Keyboard dialog box....
Recently Used File List in Excel
The number of files Excel will show in the Recently Used File List depends on the version of Excel you're using and vary between 9 and 99 files....
Use Function Keys Normally in Excel 2011
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 th...
VBA Help System Lacking in Excel 2011
The VBA Help system for Excel 2011 for Mac is a tangled web of confusion that's frustrating and difficult to say the least. Excel 2010 is much better....
Calculate the Xth Weekday of Any Month in Excel
A simple formula to calculate the Xth Day of any month using four inputs: Year, Month, Week, and Day. Data validation with custom formatting required....
Microsoft Office 2011 Document Connection
The Microsoft Document Connection program comes with Office 2011 for Mac and is a great way to access your SkyDrive files in the cloud....
Equation Editors in Excel 2010 and Word 2011
The Equation Editor is new in Excel 2010 and designed to create a mathematical equation as graphical object. Word 2011 has the same Equation Editor....
Switch Between Relative and Absolute References in Excel for Mac
Use the keyboard shortcut Cmd+T to switch between relative, absolute, and mixed formula references in Excel for Mac....
Excel 2011 Ribbon Screen Shots
Just a few screen shots of the new Ribbon in Excel 2011, with a Home tab comparison to Excel 2010....
Excel 2011 for Mac - Installation, Preferences, and VBA
I install Excel 2011, review some Preferences, and take a quick peek at the VBA....
Enter a Constant Value in a Name
Create a Name in Excel that holds a constant value....
Copy a Worksheet Picture in Excel 2003 or Excel 2008
Copy a picture of a spreadsheet in Excel 2003 or Excel 2008 for Mac and paste into your presentation software or elsewhere....
Change Excel 2008 to Look Normal
Change the default spreadsheet view in Excel 2008 for Mac to Normal....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us