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

**0**

votes

**2**answers

25 views

### How can I summarize age ranges and counts in Excel?

I have a table with a long list of individuals, and their age. From this data, I was able to derive a list of all ages, and then count how many people were of each age. Here is some simple, sample ...

**1**

vote

**2**answers

35 views

### How can I create this column chart in Excel?

Well, I'm trying to create a column chart from this simple piece of data and I don't quite understand how the the chart tool is selecting the data and axises.
Here is the data:
...

**0**

votes

**0**answers

13 views

### Excel - Updating a .xlsb file when saving a .xlsx file

I work on Excel for Mac 2011.
Sometimes, for no apparent reason, I can't open one file I saved in .xlsx. I did some research and found it was a bug. The only workaround I found is to save the file ...

**-1**

votes

**0**answers

40 views

### VBA code Excel 2011 on MAC

got Office 2011 for mac and am trying to use the VBA and macro document on it. Unfortunately what works with not problem on several versions of office for Windows, does't work on Excell 2011 for mac. ...

**0**

votes

**0**answers

36 views

### VBA not working in Excel for Mac 2011

I bought a Macbook Pro and Office 2011. Am trying to use an Excel file with VBA code and macros, which works on every other Windows PC I've tried. Unfortunately it doesn't on my Mac. Office 2011 is ...

**-1**

votes

**1**answer

28 views

### How do I adjust the width of a series in an Excel chart?

Here is a picture of my current chart:
I've tried to modify the scale to get the series' (the column) to be thicker. Ideally, I'd like the columns to be closer together too. I've double-clicked on ...

**-1**

votes

**1**answer

35 views

### How do I reference a cell in an Excel data table without using the cell coordinates?

I do a summation on the values of a set of cells in an Excel data table. The problem is when I sort the table, the values in those cells change (because the records get sorted) and this changes the ...

**0**

votes

**3**answers

36 views

### What can an Excel table do?

I don't really understand why I should use an Excel table. It seems all the functionality that a typical Excel worksheet provides is duplicated by an Excel table. The only difference I can see is that ...

**0**

votes

**0**answers

65 views

### Make Excel Row Height Stay Once Sorted [duplicate]

One column has variable length data that may be one row or maybe a bunch of rows deep. (Actually another column does as well, but it doesn't get more than 3 rows deep).
When I sort my spreadsheet, ...

**1**

vote

**2**answers

18 views

### Convert numerical result to a letter in Excel for Mac 2011

I just wanted to know how to convert the result of a calculation into a simple YES or NO outcome. I.e. if the value is less than X then 'YES' you need to reorder, if the value is greater than X then ...

**0**

votes

**1**answer

56 views

### Sum the number of hours in Excel

I want to sum the total hours I was worked in a project. For each day, I have:
Starting Time B1: 09:30:00 am
Ending Time C1: 17:00:00 pm
Total Hours D1: =C1-B1 (06:30)
I want to sum the values ...

**0**

votes

**1**answer

96 views

### How to use Excel HYPERLINK function to link to an URL with query parameters?

*This is observed under OSX 10.8.5 with Office 2011 (mac).
The hyperlink function seems not working with url with query parameters, why?
HYPERLINK("http://mysite.com?foo=bar&x=y", "my link")
...

**0**

votes

**2**answers

31 views

### EXCEL: IF function only working if Value is TRUE and remitting a #NA if the Value is FALSE: Apple Mac Air - Microsoft Office 2011

Can anyone help me with the following formula? Basically it works when the condition is TRUE but gives me an error when the condition is FALSE. I would like the cell to remit the value "0" if the ...

**0**

votes

**1**answer

118 views

### Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...

**0**

votes

**0**answers

17 views

### Issues keeping external web data in cells and columns upon refresh?

I have made a spreadsheet where I have multiple web queries to upload weather data from different locations.
I need specific MAX/MIN temperatures, etc. I can pull the data into Excel, but once I have ...

**0**

votes

**0**answers

50 views

### How to keep track of manual entries each day?

I am trying to keep track of manual entries but do not know the correct method of doing this. Should it be done using vba or by using formulas? I have spreadsheet you can view so you can see what I am ...

**0**

votes

**1**answer

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

**2**

votes

**1**answer

44 views

### Excel opens all files in directory

Excel 2011 is behaving strange. When I open a file, Excel responds by opening all (.xlsx and .csv) files in the directory!
I'm running OS X Mavericks. Tried several ways of opening: double click, ...

**-1**

votes

**1**answer

29 views

### using date ranges and numbers

I have a spreadsheet that uses both dates and numbers. For example I have a job that takes 4 hours to complete and needs to be done on 10/11/13. I have several jobs that end on this date but the time ...

**0**

votes

**1**answer

85 views

### How to set a shortcut to “Customize Keyboard…” in Excel Mac 2011

I would like to set a shortcut to "Customize Keyboard..." in Excel Mac 2011 so I could open the "Customize Keyboard" menu via a simple shortcut.
Apparently we can't do do it via Excel because there ...

**0**

votes

**0**answers

11 views

### Change focus in Excel to formula bar via keyboard using Excel 2011 in Mac [duplicate]

I want to ask the same question as this one but for Microsoft Excel 2011 in Mac. The issue is that in Excel 2011 for Mac there is no Tools -> Options.

**2**

votes

**1**answer

741 views

### How to copy and paste without overwriting in Excel

I'm trying to copy a block of cells, but instead of shifting down the rest of the rows, it overwrites them
How do we copy and paste a set of cells and shift the rest so nothing is lost?

**0**

votes

**1**answer

33 views

### How do I seed another data table's records with category information in another Excel data table?

I have a data table, of which one of the columns is 'Categories'. It is a basic text column, but it has a finite set of strings (e.g. 'Utilities', 'Home', 'Medical', etc.) I would like to ...

**4**

votes

**1**answer

183 views

### How to change default size of the comment boxes

It's incredibly frustrating to resize the box every time I put a comment. Anybody know the shortcut, or can provide a clue so I can script this?

**0**

votes

**1**answer

54 views

### How to inspect which values were used in calculation in Microsoft Excel?

In cases where I have complicated formulas like
=HLOOKUP(ROUNDDOWN((D$165-1)/12,0)+1,$D$24:$M$25,2)*D$2
Is there a good way to see which values ended up being used in the calculation? In this ...

**1**

vote

**1**answer

130 views

### Insert blank row into excel

I've been using this Excel program as a data base with this particular information for 5 years, inserting rows for alphabetical arranging on a regular basis. Now all of a sudden, can't do it. This ...

**0**

votes

**2**answers

66 views

### Mac OS 10.8.4 and Excel

I am trying to delete everything after the "," on each cell in a column of email addresses. For example:
jonsmith@hotmail.com,2013-08-06 13:27:53,bounced
sallyfield@google.com,2013-02-06 ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

113 views

### I have to hit enter twice to move to next cell

A few days ago, I suddenly discovered that, after editing a cell, I need to hit enter twice to move the next cell. So basically, when I'm doing data entry, I'll type my number, hit enter twice, and ...

**0**

votes

**1**answer

187 views

### Print multiple worksheets to a single physical page

If I have three worksheets in a workbook, how can I print them on the same physical page?
On Excel for Mac 2011, doing "Print What" "Entire Workbook" gives me three different pages, even if in ...

**1**

vote

**2**answers

91 views

### Find unique values in a range that occur a minimum number of times

I am trying to cut down on some manual work I do by using Excel functions. Each day I have a list of statistics that I need to analyze, and all values vary in one way or another. Each spreadsheet has ...

**3**

votes

**4**answers

3k 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 ...

**0**

votes

**0**answers

91 views

### Save custom macro toolbar modifications in Excel 2011 for Mac

I produced several custom macros in Windows, modified the XML so that a custom Ribbon Tab was visible in the 2013 version of Windows, and everything was wonderful.
I'm now trying to produce ...

**0**

votes

**2**answers

44 views

### Manually populate a Pivot Table

This is really a stupid question because I am supposed to know the answer.
I have a data file that looks like this:
Tech || Workdate || Fail || Manual
Joe || 2013-05-23 || 6 || 1
Joe ...

**0**

votes

**0**answers

60 views

### Is it possible to use alt-XYZ shortcuts on Excel on OS X?

I don't want to know the equivalents -- I want to use the same commands. I'm switching between windows at work and a mac at home.

**0**

votes

**1**answer

84 views

### Prevent Excel from converting text to columns

When I'm using Excel to parse multiple documents, and I need to control the import (Text, not General, on column import settings being the most notable example), how can I prevent Excel from ...

**1**

vote

**0**answers

557 views

### Keyboard Shortcut to Fit Column Width to Text in Mac Excel?

I know this on a PC. It is Alt+O,C,A, as explained in this question.
Can someone tell me please what the keyboard shortcut is to fit the column width to the width of the text in Excel on a Mac?
I'm ...

**0**

votes

**1**answer

57 views

### Office for Mac 2011 - unable to insert cells properly in Excel

I am unable to insert cells in a spreadsheet the way I want to.
When I try to insert two cells, the action automatically defaults to inserting a row instead of shifting cells down or right.
How do I ...

**2**

votes

**2**answers

9k views

### Locating Autorecover files Excel 2011 doesn't find

When Excel 2011 crashes, it often does not automatically re-open the latest version from the auto-recover files. Instead Excel may bring up the last user saved version that may not have the latest ...

**1**

vote

**1**answer

75 views

### Copying an absolute reference in Excel

I am trying to copy an absolute cell reference from one sheet to another. The nature of the second sheet means that the formula will move from cell to cell depending on where it is placed. Is there a ...

**0**

votes

**3**answers

246 views

### Excel - Sum First Value Of Non-Unique Adjacent Column

I have a table:
ColA | ColB
1 1
2 1
2 1
3 1
4 1
5 1
I would like to sum ColB only once where ColA = 2.
Essentially, I would like to sum the values ...

**1**

vote

**0**answers

179 views

### What is the best way to create charts of “database-style” tables and data in Excel?

I'm a biologist and I frequently have to do analysis on relatively large (for Excel) datasets. Usually a few charts are needed to display the data, but creating them seems to require laying out out ...

**1**

vote

**1**answer

3k 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 ...

**1**

vote

**1**answer

989 views

### Office 2011, Mac OS Lion, Excel creates temporary file on Windows server 2008, SMB share how to stop?

I have an issue with Mac's and a windows SMB share, when using Excel 2011.
If I open an excel document from the windows share it will create a "Ghost file" starting with ~$ then the full filename e.g ...

**0**

votes

**1**answer

146 views

### HLOOKUP Return Greatest Value

I have some columns A, B, C, D, E, F, G with some values in the rows below 2, 3, 4. I don't know if HLOOKUP is the correct answer for what I am trying to do but I want to have a function that looks at ...

**0**

votes

**1**answer

182 views

### Why does my conditional SUM not work?

I am Using Excel 2011 for Mac and am having a hard time figuring out a way to return some data that I need.
I have a sheet with a table, column D is "Type" and column H has numbers. I want one cell ...

**2**

votes

**2**answers

2k 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: ...

**1**

vote

**3**answers

2k 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

5k views

### Excel chart with year-to-year comparison

Given this data:
Date Year Month Usage (Kw-h) Cost/Month
02/19/08 2008 2 501 59.13
03/18/08 2008 3 404 48.49
04/16/08 2008 4 387 45.67
05/22/08 2008 5 319 ...

**1**

vote

**1**answer

299 views

### Mac Excel 2011: find Items in one column that are not in another column

Hi this is a repeat of the question: Excel: Find Items in one column that are not in another column
I have two columns in excel, and I want to find (preferably highlight) the items that are in ...