Excel 2004 for Mac Solution Center | How-to articles - Excel 2004 for Mac- How to copy or move sheets by using VBA code in Excel for Mac
You can use Microsoft Visual Basic for Applications (VBA) code to copy or move sheets within a workbook or between workbooks. This is particularly useful if you want to move or copy many sheets, or if you want to make multiple copies of a sheet. This... - Number of significant digits MS Excel retains
Microsoft Excel retains 15 significant digits. To display all 15 digits, you must use a number format (custom or built-in) other than General. The General number format displays up to 11 numeric characters, with the decimal point counting as a... - Description of the differences between the 1900 date system and the 1904 date system in Excel
Provides the description of the differences between the 1900 date system and the 1904 date system in Excel. Discusses the problems that you may experience when you use these two different date systems in Excel workbooks. - Description of the effects of the improved statistical functions for the Analysis ToolPak in Excel
Describes how the numeric improvements in Excel statistical functions affect the tools in the Analysis ToolPak (ATP). Contains links to articles that discuss the Excel statistical functions in detail. - Working with time periods that exceed 24 hours in Excel for Mac
In Microsoft Excel, you can format a cell containing the sum of amounts of time that exceed 24 hours with the number format "[h]:mm:ss"; Microsoft Excel automatically adds times beyond 24 hours and formats them correctly. - Description of the formula to sum digits of a number in Excel for Mac
Although there is currently no built-in formula that finds the sum of the digits of a number in Microsoft Excel, you can use the formula in the "More Information" section in this article to do this. - Error trapping with Visual Basic for Applications in Excel for Mac
When a run-time error occurs in a Microsoft Visual Basic for Applications macro, an error message appears on the screen, and the macro either halts or behaves unpredictably. To prevent the application from crashing or behaving unpredictably, you can... - Description of the Value2 property for the Range object
Microsoft Excel 97 for Windows and Excel 98 for Macintosh include a new Visual Basic for Applications property called Value2. The Value2 property, which you can use for the Range object, is almost identical to the Value property except that the Value2... - Number formatting affects perceived precision in Excel for Mac
Microsoft Excel for Mac calculates a number based on its stored value not its displayed value. When a formula or worksheet function performs a calculation, Excel for Mac uses the values in cells that are referenced by the formula. Note that the... - How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel
Describes how to use the INDEX and MATCH worksheet functions in Excel to find a value based on multiple criteria. This article also provides some examples to show how to perform this task. - How to count the occurrences of a number or text in a range in Excel for Mac
This article explains how you can use worksheet functions in Microsoft Excel for Mac to count the number of occurrences of a specific number or text string in a range of cells on a worksheet. The "More Information" section of this article contains... - How to remove individual AutoFilter drop-down lists in Excel for Mac
In Microsoft Excel for Mac, you can programmatically hide an AutoFilter drop-down list for a specific field in a list by using a new argument for the AutoFilter method in Microsoft Visual Basic for Applications. This article includes a sample Visual... - Visual Basic macros that add or remove hidden apostrophes in Excel for Mac
You can use a Visual Basic for Applications macro to change a formula or a value to text and vice versa. To change a formula or value to text, run a macro that adds a hidden leading apostrophe in front of the formula or value. To restore the formula or... - Macros to delete formula links in Excel for Mac
When you open a workbook that contains links to another workbook, Microsoft Excel asks you if you want to update links. If the file that the link is referring to no longer exists, or if it has been moved to a different folder, you may want to delete... - Formulas to count the occurrences of text, characters, or words in Excel for Mac
This article contains formulas that calculate the following: The number of occurrences of a text string in a range of cells. The number of occurrences of a character in one cell. The number of occurrences of a character in a range of cells. The number... - How to assign a macro to an option button in Excel
Describes how to assign a macro to an option button from the Forms toolbar in Excel. The macro will then run when the option button is selected. - How to create a BoxPlot/Box and Whisker Chart in Excel
Microsoft Excel charts do not include a BoxPlot/Box & Whisker chart type. However, you can create a reasonable representation of this type of chart by following the steps outlined in this article. To create a sample BoxPlot/Box and Whisker chart,... - Microsoft Security Advisory: Vulnerability in Microsoft Office Excel could allow remote code execution
Provides a link to Microsoft Security Advisory (968272): Vulnerability in Microsoft Office Excel could allow remote code execution. - Using AppleScript with Excel for Mac
Microsoft Excel for Mac and later versions support AppleScript in the scriptable capacity. With this feature, you can control Excel for Mac from other programs or scripts. - How to open Office 2008 for Mac documents in an earlier version of Office for Mac
Describes how to obtain and install the Open XML File Format Converter for Mac. You must have this converter to open Office 2008 for Mac documents in an earlier version of Office for Mac. - How to recover text from any Word for Mac or Excel for Mac file
This article explains what the "Recover Text from Any File" converter is and how to use it to recover damaged documents. - How to sum either odd or even rows only in Excel for Mac
When you use any of the worksheet functions in Microsoft Excel, and you have a range argument that includes either hidden rows or columns, the cells in these hidden areas are still used by the function. For example, if you have the following in a... - How to add data to a ComboBox or a ListBox in Excel for Mac
This article provides examples of how to use a Microsoft Visual Basic for Applications macro to populate a ListBox or ComboBox control. - How to sum a range of cells based on a number format in Excel
This article includes a sample Microsoft Visual Basic for Applications custom function that sums the values in a range of cells that are formatted with a specific custom number format. Microsoft provides programming examples for illustration only,... - Maximum times allowed in Microsoft Excel for the Macintosh
Microsoft Excel limits the maximum time value that you can enter into a cell or return by using a formula. This article describes the limits in different versions of Microsoft Excel.
|
| |