# Questions tagged [microsoft-excel-2011]

The 2011 version of Microsoft's spreadsheet application for OSX.

**0**

votes

**1**answer

970 views

### Excel formula disappears when saving as .xls

I have a long formula in one of my cells. It is:
=IF(K11=1,MATCH(C66,valv1,-1),IF(K11=2,MATCH(C66,valv2,-1),IF(K11=3,MATCH(C66,valv3,-1),IF(K11=4,MATCH(C66,valv4,-1),IF(K11=5,MATCH(C66,valv5,-1),IF(...

**1**

vote

**1**answer

161 views

### Can you autofill numbers going upward?

I know how to autofill numbers going downward. But I'm curious if you can autofill numbers going upward? I'm using Excel 2011 on MacOS X (El Capitan).
It may sound counter-intuitive, but my boss ...

**0**

votes

**2**answers

1k views

### Hide a Control Box in Excel

I have some radio buttons in Excel (2011 Mac), and they are grouped by a Group Box.
I want to make the Group Box invisible. I searched on the internet and found that I could do that with VBA by ...

**0**

votes

**0**answers

273 views

### Why doesn't Excel auto-adjust formula when a row is moved?

I have a simple spreadsheet with just one formula, which auto-increments the number in the first column, going from cell A6 down. So the value in A6 is hard-coded 1, then A7 contains the formula =A6+...

**0**

votes

**1**answer

26 views

### Can Powerpoint update two Excel objects that are from the same Excel file?

I've been reading through the forums and haven't come across a definite answer for my query. I have a PPT presentation that includes 2 different worksheets from the same Excel file, pasted as Excel ...

**1**

vote

**1**answer

2k views

### How can I use a macro to group and average the values in an Excel column?

I'm new here and I've been struggling with macro writing. I was wondering if anyone could help me out with making/explaining a macro that could be used in my data set.
I have an Excel file that looks ...

**0**

votes

**0**answers

109 views

### Separating concatenated name, address, and phone number

I imported company names, addresses, and phone numbers into a cell. Due to the different number of characters, I cannot separate the fields of information with text to columns; for example:
ABC &...

**0**

votes

**1**answer

63 views

### Getting the name of a named cell in MS Excel 2011

I am using a formula in Excel, which involves cell names.
The formula is
=MIN(name1,name2,name3)
name1 is the smallest, but it shows name1's value. I want it to show the text "Name1". How do I do ...

**2**

votes

**1**answer

697 views

### Replace method generates application-defined or object-defined error in Excel for Mac

I'm having trouble with this on the latest version of Excel for Mac.
Here's the macro:
Sub Run()
'
' Run Macro
'
'
Sheets("Data").Select
Cells.Select
Range("BK1").Activate
...

**0**

votes

**1**answer

56 views

### Sorting using Subtotals and Data Subtotals

In sorting using Subtotals via Data Subtotals, is there a way I can get all lines of info to come down NOT just the ones I'm totaling?
The only way I have remedied it is copying it down from the Page ...

**1**

vote

**1**answer

1k views

### How do I use Excel 2011 Personal Macro Workbook?

I realized I asked about excel 2010, but that only covers Windows OS. How can I use the Personal Macro Workbook in Excel 2011 on OSX?

**0**

votes

**0**answers

108 views

### sum rows and columns depending on two values

I got the following table in Excel (Microsoft Excel 2011 for Mac).
It is basically for controlling issues. It shows a number of persons (employees) that are assigned to specific work-packages that ...

**3**

votes

**1**answer

2k views

### How to close an excel file using terminal or python

I am using XlsxWriter to create an Excel file using a Python script.
When I re-run the script to update the file with new information, which I need to do often, I have to manually close the Excel ...

**1**

vote

**0**answers

328 views

### EXCEL 2011 - Inventory with Matrix and Vlookup

I am creating an inventory matrix, which has on the first column a list of all the items in the inventory, and on the first row a list of the dates for when the inventory gets renewed. Basically, not ...

**1**

vote

**2**answers

1k views

### How do I use IF in MS Excel-Mac 2011 for 3 variables?

When I type A, B or 0 in one cell, I want to see in other two cells (separately) to show
2,1 if I type A
1,2 if I type B
0,0 if I type 0
Can someone help me how to do this?
I currently only have ...