Excel Legacy Articles
Articles tagged Excel Legacy, including related tutorials, examples, and walkthroughs.
31 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....
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....
Check the Analysis ToolPak Add-In in Excel 2003 [VBA Code]
This VBA code checks to see if the Analysis TookPak Add-In is installed in Excel 2003 when the file is opened, and will notify the user if not....
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....
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 2003
The List Object in Excel 2003 is the forerunner of the modern Excel Table with some of the same features....
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...
The Mini Toolbar in Excel
Do basic formatting in Excel with the Mini Toolbar. It appears above the shortcut menu when you right-click an object - cell, range, chart, or shape....
Add Freeze Sheet Panes to the Quick Access Toolbar
Add a one-click Freeze Panes command to the Quick Access Toolbar in Excel 2010 and 2007....
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....
Import Data From the Web in Excel
Import data from a web page into an worksheet with Excel 2010 and 2007 (windows versions). This external data query can be refreshed if data changes....
Copy a Help Topic URL in Excel 2010
Help topics in Excel 2010 are shown in a separate window from Office.com that allows the URL to be easily copied from the Help topic's Properties....
Redo and Repeat Commands in Excel [Updated]
The Repeat command is useful in Excel and intertwined with the Redo command. Add the Repeat command to the Quick Access Toolbar to discover its uses....
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....
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....
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....
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....
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....
Absolute and Relative Cell References in Excel
Learn what a relative and absolute cell reference means in rows and columns, then use relative and absolute in one formula with two cell references,...
Introduction to PowerPivot
PowerPivot works with Excel 2010 to import millions of rows of data from different sources, build relationships, and visualize data with PivotTables....
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....
The WEEKDAY Function in Excel
Excel 2010 has new function arguments for the WEEKDAY Function. It returns an integer value based upon the day of the week....
Excel on the Web – Another Spreadsheet in the Cloud
A look at the Excel Web App spreadsheet with integration to Excel 2010 desktop program....
Expand Menus in Excel 2003
Show full menus in Excel 2003...
Microsoft Excel 2010 on the iPad with the OnLive Desktop
The OnLive Desktop brings a Windows desktop to the iPad so you can enjoy a full version of Microsoft Excel 2010. Truly amazing....
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