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

**0**

votes

**0**answers

7 views

### How can I manipulate Mac Excel 2011 to automatically populate a table from change in stock?

Good evening everyone. You will have to excuse my poor descriptives as I am not overly literate with general computing. I am running a MacBook Pro with Excel 2011 and the latest OS X (El Capitan 10.11....

**1**

vote

**2**answers

6k views

### Can I link images using a relative path?

I am working on an MS Excel workbook that contains around 200 images. They are currently saved within the workbook, so the file becomes huge and working gets very slow.
Linking the pictures without ...

**0**

votes

**2**answers

3k views

### Excel 2011 for Mac/ Pivot table / tabular layout how to “fill down?”

I've got a great pivot table in tabular layout, but how do I "fill down" values in column A?
A10 should also read "Alpaha Police"
A15:A18 should also read "Atkinson Co Sheriff"

**3**

votes

**6**answers

11k views

### How can I quickly determine if an Excel spreadsheet contains any formulas or is just “static” text?

I've inherited an Excel spreadsheet with many sheets, all full of text and numbers. As far as I can tell, this is all hardcoded, static text. After a quick look, I can't see any formulas or anything ...

**-1**

votes

**0**answers

7 views

### Highlight names in column A, sheet 1 that are found in Column C, sheet 2, 3, etc

I have a list of names in column A, sheet 1 that I would like highlighted if the names are found in column C, sheet 2, 3, 4, etc. I am trying CF, but cant quite seem to get it. please help.

**1**

vote

**8**answers

22k views

### Duplicating a row with formulas, without changing cell references

i have a large financial spreadsheet with a ton of formulae. i'd like to duplicate a row such that it retains the same formula and coordinates as the source row (basically duplicate a summary row and ...

**2**

votes

**2**answers

11k views

### Tie stock quote value to cell in Excel 2011 Mac

I've been working on a mock stock portfolio in Excel, and I've been looking for ways to automatically update the data, eg. stock price and P/E ratio.
I have tried using a web query to MSN Money, but ...

**0**

votes

**1**answer

21 views

### Auto refresh Excel worksheet after changed by external application?

I have a question similar to this one but I'm just using an Excel file, no CSV involved:
Open a .csv file in Excel and have it update whenever .csv file changes
I have an Excel file that I ...

**-1**

votes

**1**answer

32 views

### How to use non-contiguous range arguments in Excel's XIRR?

The XIRR requires range arguments. I would like to know how I can somehow use 'split' ranges which are in different locations. Perhaps the picture explains it better. What do I enter in F7, if I want ...

**2**

votes

**0**answers

14 views

### Excel for Mac alters document names after saving

I have a 2012 non-Retina MacBook Pro with Excel 2011 for Mac version 14.6.3. Every time I save a document using the Save As command and save as a PDF document, Excel alters the name I entered as the ...

**0**

votes

**0**answers

19 views

### How do I create a macro in Excel for Mac? [duplicate]

I have found this thread on this topic
How to get the list of sheet names of ms-excel?
But I have no idea how to create the macro people are talking about. I will be grateful for your help on how to ...

**2**

votes

**3**answers

28k views

### Excel: formula to display answer only if ALL cells in a formula have a value

I have a scenario where I don't want excel to use a blank cell as a zero value. I only want the cell to display the result if all the cells in the formula have a value entered.
For example: =A3-B3-...

**2**

votes

**1**answer

5k views

### Find first number greater than x and return another value in that row

I have created an investment spreadsheet. In one column I have the ending balance each year. In another column I have the years.
A B
2000 500K
2001 450K
2003 1.2M
2004 1.5M
How can I display ...

**0**

votes

**2**answers

357 views

### VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance"
I read the documentation, and wrote this macro:
Sub add_category()
...

**1**

vote

**1**answer

44 views

### Get rid of PivotTable help on Excel for Mac

Every time I start up Excel For Mac 2011 and build a Pivot Table, Excel feels it's needed to remind me in a modal what Pivot Tables do ("PivotTables summarize data and reveal patterns and trends").
...

**1**

vote

**1**answer

72 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

**2**answers

20 views

### How to find the number of rows that have date time fields between 5 and 6 PM

I have a phone log that I want to report some data off of. All of the solutions out there that I have looked up seem to assume I only have a time value and that they don't include an actual date.
I ...

**2**

votes

**1**answer

35 views

### Bitwise Operations Missing? (Excel for Mac 2011)

According to the relevant
Microsoft Support page on the BITAND function, I should have access to it, as I am running Excel for Mac 2011 (with the latest updates installed):
"APPLIES TO: Excel 2016, ...

**0**

votes

**2**answers

3k views

### How do i change the date format to UK in Excel 2011

My Excel 2011 for Macbook will accept input of dates only in US format MM/DD/YY. I would like to enter dates in UK format DD/MM/YY.

**0**

votes

**2**answers

82 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

**1**answer

17 views

### Uncrowding a scatter plot when most points lie near lower end of X-axis

Given an Excel scatter plot thus:
where the bulk of the points lie at the lower end of the X-axis, how can the lower end be made to look less crowded (without removing data points), while ...

**0**

votes

**1**answer

1k views

### X axis on Time-Based data

I have a series of 24 hr. data, taken about once per hour. I wish to plot the values against time. On day 1 the 10:00 data was taken at 10:10, on day 2 the data was taken at 9:58. I do not want both ...

**0**

votes

**0**answers

32 views

### Using SUMPRODUCT to total column range X if meets numerical criteria in range Y

I am seating people for an event. There are 16 tables (column E). People may come alone, with spouse and/or guests (total for each in column I). I want a way to get a table count as I work through ...

**0**

votes

**0**answers

16 views

### Predefined chart styles in Excel available to other users?

I need to set up a MS Excel document with custom chart styles. As far as I understand the style of an existing, customised chart can be saved as a predefined chart style. I then need this style to be ...

**3**

votes

**1**answer

2k views

### direction right to left Excel 2011 on Mac

I am trying for a long time already and can't find a solution for MAC
I would like my excel worksheets to be Right To Left.
Using Excel 2011 on Mac.
How can I do it?

**1**

vote

**1**answer

99 views

### MINVERSE only returns a single number

For the life of me, I can not get the MINVERSE function on Excel 2011 on my Apple Macbook to work.
I entered the function into a matrix.
I type =MINVERSE(A1:C3), the location of my matrix to be ...

**0**

votes

**1**answer

30 views

### Concatenating datas from different sheets

I have an Excel workbook with 2 sheets. Sheet #1 contains 2 columns, names and points.
| A | B |
|-----------|----|
| John Doe | 65 |
| Jolly Doe | 45 |
| Hello Doe | 50 |
Sheet #2 ...

**3**

votes

**6**answers

16k views

### How do I align a column of numbers by decimal point in Microsoft Excel when some of those numbers are negative?

Let's say I have a list of the following numbers:
0.02
-0.25
-4.13
5.24
-11.36
40.61
-141.20
How would I align them in a column such that they are left-justified in the cell but the decimal points ...

**2**

votes

**1**answer

3k views

### How to return first non-blank cell and if it's already a value before it, return the third non-blank and so on?

How to make a function which would return the first non-blank cell value but if it's defined in the left cells next to it, it would jump 2 cells and look for the next value.
Table:
1 | 2 | 3 | 4 | ...

**0**

votes

**1**answer

33 views

### How to get the difference between 2 cells

I have an Excel file like below.
The value in column C should be the difference between A and B (A is always longer, B is always A substring).
If both values in A and B are same, C will be empty.
...

**2**

votes

**3**answers

11k views

### Formula to move data from every third row to a column?

I have an excel sheet (mac, Excel 2011) that contains names (1st row), job titles (2nd row), and company/institution (3rd row) in one big column. I am trying to separate them into three different ...

**0**

votes

**1**answer

32 views

### Merge two sheets on two columns into a new sheet in Excel?

I'm using Excel 2011 on OSX. I have Sheet1 that looks like this:
pupil_id date test_score
1 2015/10/01 98
2 2015/10/01 83
And I have Sheet2 that looks ...

**0**

votes

**0**answers

35 views

### Group different values with same name field in Excel

I'm having troubles with the following document.
Is there a way to group different values with the same name field?

**0**

votes

**1**answer

65 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(...

**0**

votes

**2**answers

996 views

### Linking to Other Excel Sheets Greyed Out (Excel 2011 Mac)

I just got a file from my colleague which has some broken links. They were broken because the path to the cells pointed directly to a file on her computer. She sent over those files, and now I have to ...

**1**

vote

**1**answer

32 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 ...

**1**

vote

**0**answers

56 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

14 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 ...

**17**

votes

**4**answers

48k views

### How to move columns with drag and drop in Excel 2011?

How can I move columns with drag and drop in Excel 2011?

**1**

vote

**1**answer

232 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 ...

**2**

votes

**6**answers

14k views

### How can I get Excel 2011 to stop opening my Personal Macro Workbook?

Ever since I created a couple of macros in Excel for Mac 2011, the Personal Macro Workbook opens every time I open Excel. How do I keep that from happening?
I have since deleted the macros, but I ...

**0**

votes

**0**answers

105 views

### How do I setup Excel to chart a budget with multiple currencies and categories?

I am using MacOS X and Excel for Office Mac 2011 version 14.2.4.
I have three separate currencies: Chinese yuan (¥), US dollars ($), Thai baht (฿). Each currency has its own table with the following ...

**2**

votes

**1**answer

27k views

### Create a form as a worksheet in Excel that adds records to another worksheet

I am trying to create a form in Excel for vehicle requests. What I want to happen is to create one worksheet that is a recreation of the current paper form, but have a clickable button that will ...

**0**

votes

**0**answers

49 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

24 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

219 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

16 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

**4**answers

16k views

### How can I sort my data while keeping paired rows together?

How can I pair two rows on a spreadsheet, so that for each data entry I can sort the matrix but the pair of rows moves as a single list of data, retaining the structure of the two rows?
For example:
...

**2**

votes

**1**answer

306 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 ...

**0**

votes

**0**answers

53 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 ...