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

learn more… | top users | synonyms (1)

2
votes
1answer
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
0answers
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
1answer
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
1answer
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
4answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
2answers
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
2answers
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
2answers
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
1answer
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 ...