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

learn more… | top users | synonyms (1)

5
votes
1answer
24k 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 ...
5
votes
1answer
551 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?
4
votes
2answers
19k 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 ...
3
votes
1answer
11k 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?
3
votes
4answers
7k 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 ...
3
votes
2answers
7k 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 ...
2
votes
6answers
9k 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
3answers
37k 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 ...
2
votes
1answer
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 | ...
2
votes
5answers
9k 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 ...
2
votes
2answers
12k 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
1answer
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, ...
2
votes
2answers
50 views

Average of Count of Cells for Day of Week in MS Excel

I'm looking to do an average of rows per week day. And so far, I haven't been able to figure it out. I'm using Excel 2011 for Mac. Here's a sample screenshot: Here's the screenshot of the ...
2
votes
3answers
6k 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 ...
2
votes
2answers
2k 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
1answer
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:
2
votes
1answer
27 views

How to disable moving down on Enter key in Excel 2011 for Mac?

When entering data in a cell and pressing enter, the cursor moves down one step. How do I disable this?
2
votes
0answers
35 views

Changing language of functions in Excel 2011 for Mac

I use Office 2011 for mac, with Norwegian language. I don't mind menus and such being Norwegian, but for some reason, the names of functions have been translated from English to Norwegian, and that is ...
2
votes
0answers
734 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?
2
votes
1answer
101 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, ...
2
votes
1answer
13k 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 ...
2
votes
2answers
712 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
0answers
242 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 ...
2
votes
1answer
1k 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 ...
2
votes
0answers
266 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 ...
1
vote
6answers
12k 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
1answer
85 views

How to make a concentric pie chart in Excel?

I'd like to make a chart (preferably on its own sheet) that is a combination of a regular pie and a doughnut. The regular pie sits in the middle and the doughnut surrounds it. I have seen those ...
1
vote
1answer
132 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 ...
1
vote
2answers
29 views

How to replicate efficient pasting from delimited text behavior in Excel?

Sometimes when I paste space delimited values from a text file into excel it automatically separates them into the correct columns. Other times I have to use the "Text to Columns" tool. I haven't ...
1
vote
1answer
378 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 ...
1
vote
2answers
5k 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 ...
1
vote
1answer
33 views

Remove duplicate rows, and keep newest row based on date column

I have a huge list of data in excel (250.000+ rows) in the following format: Number Value1 Date Value2 40325 1 21/01/11 18.10 2 65485 3 22/01/11 16.47 2 40325 9 ...
1
vote
3answers
43 views

Excel, IFs and Dates

I have a household budget, it is split into fixed and variable expenses. I would like to include the fixed expenses only during/after the month they are incurred. Not a problem using the following ...
1
vote
2answers
166 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: ...
1
vote
2answers
29 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 ...
1
vote
1answer
6k 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 ...
1
vote
1answer
469 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
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
2answers
923 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?
1
vote
1answer
13 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
1answer
27 views

How to create stacked chart

I go nuts at Excel. So here's my problem: I have a table where the Y-values are projects that we are working on in that year on the x-values are project related properties. On of those properties is ...
1
vote
2answers
28 views

How to recover the overridden file on my MacBook Pro?

I have Windows excel on my MacBook Pro. I accidentally saved one Excel file overtop another excel file. Is there anyway to recover the earlier file (the one I just saved over)?
1
vote
2answers
37 views

Is there a way to reference an external excel file depending on a cell's value?

I am trying to make a template for a document that will be updated every week, and I was wondering if there was a way to insert some values automatically depending on the value of a cell. To explain, ...
1
vote
1answer
373 views

No Startup folder in Microsoft Office for Mac 2011

I'm trying to save a new default worksheet in Excel for Mac 2011. Instructions say to save it in the Startup folder at this location: /Applications/Microsoft Office 2011/Office/Startup/Excel There ...
1
vote
1answer
63 views

Is it possible to change or modify built-in VBA editor in Excel for Mac 2011

I am using the built-in VBA editor in Excel 2011 for Mac, but the built-in editor doesn't respond well to my scrolling gestures. I'm having too much trouble writing/finding code. Is it possible to ...
1
vote
2answers
171 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 ...
1
vote
1answer
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
1answer
237 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 ...
1
vote
0answers
17 views

Select all cells with certain fill color

Is it somehow possible to select all cells with a certain fill color in Excel for Mac? On a PC it's possible through find/replace but that option isn't there in Excel 2011 for Mac.