Stack Overflow
Stack Overflow

Questions tagged [excel-2011]

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

151 questions
43
votes
9 answers

Reordering Chart Data Series

How does one reorder series used to create a chart in Excel? For example, I go to the chart, right click > Select Data. In the left column I see series 1, series 2, to series n. Say, I want to move series 3 after series 4, can it be done from chart…
KM.
  • 1,382
  • 1
  • 19
  • 34
17
votes
7 answers

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, my curiosity, all was here! I had a homework from university course to use LINEST. I even stopped trying to do so on MAC, because after googling I…
Ievgenii
  • 477
  • 1
  • 5
  • 13
17
votes
5 answers

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 do that for me, but dialog boxes show up for every action. This was fine for a few dozen files. However, I'm going to use this on hundreds of XLSM files at…
NJP
  • 815
  • 1
  • 7
  • 20
16
votes
3 answers

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" columns as per the following: "... Excel for Mac doesn't have a "Sort by Grand Total" option, but you can select the grand total column and…
ylluminate
  • 12,102
  • 17
  • 78
  • 152
12
votes
2 answers

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 of listings that are essentially the same aside from the tags column. What I'd like to have it do is combine these 5 listings into 1…
jbwharris
  • 710
  • 1
  • 10
  • 30
10
votes
3 answers

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 have a file with contents that look sort of like this: A B C D E 1 10 11 12 13 14 2 51 52 53 54 55 If I wanted to sum the…
Anirvan
  • 6,214
  • 5
  • 39
  • 53
10
votes
2 answers

Where is Go To Special in Excel 2011 for Mac?

Does anyone know where the Go To Special... in Excel 2011 for Mac? In Windows, you can use Ctrl+G, but I cannot find it in the Mac version :(
PMa
  • 1,751
  • 7
  • 22
  • 28
7
votes
2 answers

Excel charts: prevent auto grouping of dates

I got an excel table with two columns: date (dd/mm/yyy hh:mm) and value (integers). The table has about 8000 values in a time range of 4 days. When I try to create a line or bar chart on these two columns, excel somehow accumulates all values for…
Alex
  • 1,141
  • 1
  • 13
  • 24
6
votes
1 answer

VBA Simple Copying one Range to Another Range

This is a really simple VBA formula but it's failing. It's only pasting into cell A6 onwards. Is it just me? Excel 2011 by the way. Range("A4:A5").Select Selection.Copy Range("A6:A1000").Select ActiveSheet.Paste
SparrwHawk
  • 13,581
  • 22
  • 61
  • 91
6
votes
10 answers

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 takes a string as input so I need to convert the range to a string, while retaining as much of the formatting as possible (i.e. it needs to look like a table…
1937827
  • 97
  • 1
  • 2
  • 9
6
votes
6 answers

Solver.xlam is missing?

I created a program in Excel 2010 on my PC that relies on the built-in solver for Excel. I made sure it worked on both Excel 2010 and Excel 2013 for PC. I then tried to use this same program on Excel 2011, and ran into an issue. When I tried to…
TheTreeMan
  • 913
  • 8
  • 23
  • 38
6
votes
6 answers

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 using a Excel 2011 on a Mac. I can't find a way to reuse the saved template. The help instructs me to Click the chart On the Charts…
Cristi
  • 445
  • 2
  • 4
  • 14
5
votes
1 answer

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 dot. If my value is smaller than my formulas value, display the green dot. If my value is equal to my formulas value, display the orange dot. If…
Fizzix
  • 23,679
  • 38
  • 110
  • 176
4
votes
2 answers

NETWORKDAYS.INTL() function not working in VBA

I have this line in my macro (Excel 2011 VBA on Mac): nWeekDaysBetween = (Application.WorksheetFunction.NetworkDays.INTL(pDate, aDate, 7) - 1) When I run the macro, it highlights NetworkDays and gives: Compile error: Argument not optional. The…
andreyman
  • 51
  • 1
  • 3
4
votes
1 answer

Expected End of Statement in formula with quotes

Sub FillNames() Range("D2:D56").SpecialCells(xlCellTypeBlanks).Formula = _ "=IF(AND(C>800,C<900), "YES", "NO")" End Sub I get the compile error expected: end of statement. It seems to have issue with the quotes around the words YES and NO.…
PA_Commons
  • 269
  • 2
  • 6
  • 14
1
2 3
…
10 11