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

**0**

votes

**1**answer

303 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

723 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

83 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

**2**answers

907 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

803 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

517 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

211 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

**5**answers

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

**2**answers

58 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

69 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

748 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

**1**answer

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

**3**

votes

**6**answers

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

**0**

votes

**1**answer

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

**3**

votes

**3**answers

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

85 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

698 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

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

**2**

votes

**1**answer

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

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

569 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

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

**7**

votes

**1**answer

31k views

### Excel 2011 Mac auto-recover file lost

Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the previous document. Yes, he said and then got a document named ...

**2**

votes

**2**answers

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

**2**

votes

**3**answers

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

1k views

### Merging rows in an Excel document with the same email and preserving merged row data

I have an excel sheet of around 50,000 records of something like this:
email product info moreinfo
a@a.com 866 data data1
b@b.com 960 data data1
c@c.com 976 data data1
c@c.com ...

**0**

votes

**1**answer

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

**0**answers

333 views

### Excel 2011 Conditional Formatting: compatibility issues

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed).
The purpose is a semi-automatic calendar, where one enters ...

**2**

votes

**2**answers

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

**2**

votes

**2**answers

4k views

### How to get the list of sheet names of ms-excel?

I have an excel file which has a lot of sheets. How could I get a list of sheet names of ms-excel?
(PS: The office is mac version.)

**2**

votes

**1**answer

3k views

### Using Mac Excel, how can I delete partial duplicate rows?

I'm running Mac Office 2011 under Lion.
I have a sheet of many thousands of rows of data, with a good 40 or 50 columns. One column is email address. If any two rows have a duplicate email address, ...

**1**

vote

**0**answers

89 views

### Excel Sheet Link [closed]

I'm doing a dissertation of 17000 words, and I have a huge file of more than 400 pages in excel So how I can put all the excel work in one link in words or another program.

**1**

vote

**1**answer

2k views

### How to create excel line charts with irregular scales

I am trying to create a line graph, The vertical axis is an irregular scale - 1,1c,1b,1a,2,2c,2b,2a and so on.
Here is the data in chart format
I am having trouble representing this data in the ...

**1**

vote

**1**answer

540 views

### Show date format in Excel as the OS default

Is there a way in Excel (2007 and up) to set the date format of a column to the date format of the OS locales. The data entered in this column is a date (imported from a database date field).
For ...

**1**

vote

**7**answers

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

**0**answers

344 views

### How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...

**1**

vote

**1**answer

939 views

### Excel for Mac - unable to create my own macros

I have a macro (made for Excel - Windows), which url encode strings - i.e. space becomes %20.
When I open the *.xlsm on a Mac with Excel installed(Office for Mac 2011), it does not work.
No errors - ...

**2**

votes

**1**answer

2k views

### Turn off (or increase size threshold) for clipboard warning in MS-Excel

This question asks how to programmatically turn off the "there is a large amount of information in the clipboard" warning" that MS-Excel pops up whenever you try to close an Excel file and the ...

**0**

votes

**1**answer

379 views

### Excel Different line graph loaded on each selection

I have been adding a lot of absence/presence data into an MS Excel 2011 for Mac sheet. On the days students are present they get points, on days they are absent they get zero. If student was there, ...

**0**

votes

**1**answer

694 views

### Excel 2011 for Mac VLOOKUP Date Issue

I'm fairly proficient in using vlookups, but I'm having an issue vlooking up dates between two different spreadsheets.
=VLOOKUP(B6,'[example.xlsx]Sheet1'!$B$1:$AA$260, 19, FALSE)
My formula is ...

**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

**1**answer

186 views

### (Combine 3 columns into one in excel 2011 for mac) plus change formula into usable number

If I set up the following, from a previous Applemac - from a “Superuser“ - excel solution.
(Combine 3 columns into one in excel 2011 for mac)
I enter column D to use the formula ...

**1**

vote

**1**answer

137 views

### Error message when trying to retrieve a value from a range using VLOOKUP

I've got an excel spreadsheet where I would normally use a VLOOKUP.
In this case I need to find the ID of the record when comparing email addresses, so the email address is the unique id here.
For ...

**2**

votes

**1**answer

2k views

### How come I can only forecast a trendline 5 periods backwards, while I can forecast it 1000+ forward?

It doesn't make any sense. I can do it in Excel 2010 on Windows, but not Excel 2011 on OS X.
Workbook I used: http://cl.ly/Ewfe
Screenie:

**1**

vote

**2**answers

5k views

### Set Zoom Default to 125% Excel 2011 on OS X

I don't like smal fonts. Therefore I would like to have a default zoom level of 125% for all spread sheets in Excel 2011 on OS X Lion. Is there a way to tell Excel to open all spread sheets with a ...

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

**1**

vote

**1**answer

3k views

### Alternating Row Colour with Conditional Formatting in Excel 2011 for Mac?

Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?

**1**

vote

**1**answer

423 views

### Highlight Excel spreadsheet cells every three days

I use Excel 2011 on OS X to track down my tasks list.
Now I would like to add a date cell to some tasks so that every three days these tasks get highlighted. My question is if there is any way so ...

**2**

votes

**0**answers

267 views

### Can I disable Excel's warning when saving CSV files? [duplicate]

Possible Duplicate:
Excel: Is there a registry setting to suppress the warning messages when saving spreadsheets in CSV format?
Excel always says
...may contain features that are not ...

**3**

votes

**2**answers

10k views

### How can I process million rows of data in Excel?

I understand that Excel can only process 65,536 rows of data. If I'm trying to analyze 7 million rows of data (say, plot a histogram distribution of 7 million values), is there any workaround?
Can I ...