Top "Excel-2011" questions

Excel 2011 refers to the spreadsheet editor included in Microsoft Office for Mac 2011.

Reordering Chart Data Series

How does one reorder series used to create a chart in Excel? For example, I go to the chart, right …

excel charts excel-2011
Disable all dialog boxes in Excel while running VB script?

I have some code in VB that saves all XLSM files as XLSX. I already have the code that will …

vba excel excel-2011
Array formula on Excel for Mac

I need to call LINEST in Excel 2011 for Mac, I would say - this was a detective story. My laziness, …

excel macos array-formulas excel-2011
Combining duplicate entries with unique data in Excel

I have an Excel database and I'm trying avoid doing some manual combining of duplicate data. I've got a bunch …

excel excel-2011
Sort by "Grand Total" Column in Excel PivotTables?

As per an explanation found here by Mac CPub fro Excel 2011 (for OS X) supposedly you can sort "Grand Total" …

excel pivot-table excel-2011
How can I convert a range to a string (VBA)?

What is the best way to convert a range of cells to a string? I have a function that only …

vba macos excel excel-2011
How do I specify a variable Excel range?

I'd like to be able to dynamically specify a range in Excel, based on row/column variables. Let's say I …

excel worksheet-function excel-2011
Counting cells that contain a certain bit of text without duplicates

I need to count the number of cells in a column that contain a certain bit of text. Actually, I …

excel excel-formula excel-2011
How to apply a saved chart template to an existing chart?

I recently created a custom contour chart in excel to display my data colored with a heat-map color mapping. I'm …

excel templates charts contour excel-2011
Conditional formatting with the icon set and a formula

Basically I am trying to use the conditional formatting icon set that is a green dot, orange dot and red …

excel vlookup conditional-formatting excel-2011