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

**2**

votes

**1**answer

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

80 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

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

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

**0**

votes

**4**answers

2k views

### duplicating a row in excel

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

**1**

vote

**0**answers

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

**0**

votes

**1**answer

509 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

152 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

116 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

970 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

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

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

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

311 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

264 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

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

**1**

vote

**2**answers

176 views

### Linking a cell to a tab within an Excel workbook

I'm using Microsoft Excel 2011. One of my workbooks contains a tab. I want that tab to open when I click a link. The link should be in a cell in the same workbook. How can I create such a link?

**3**

votes

**2**answers

8k views

### Excel data into PowerPoint slides

I have already found some helpful sites but I'm still unable to do what I want. My Excel file contains few columns and multiple rows. All the data from one row would be in one slide but data from ...

**0**

votes

**2**answers

3k views

### Opening a file for output/input in Microsoft Visual Basic on Mac OS X

I am working in Excel for Mac 2011 and my goal is to create a simple macro that writes particular cells to a file. This is generally a simple task, but VB chooses not to accept a file path. For ...

**0**

votes

**2**answers

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

**1**answer

720 views

### How can I sort by word/token in Excel 2011

Is it possible to sort a spreadsheet based on if a word is contained in cells within a column?
Like if I take the "title" column and sort, keeping the rows connected, to bring all the rows with a ...