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

**17**

votes

**4**answers

48k views

### How to move columns with drag and drop in Excel 2011?

How can I move columns with drag and drop in Excel 2011?

**7**

votes

**1**answer

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

**1**answer

32k 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?

**5**

votes

**2**answers

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

**5**

votes

**1**answer

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

**3**

votes

**6**answers

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

**3**answers

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

**3**

votes

**6**answers

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

**3**

votes

**2**answers

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

**3**

votes

**1**answer

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

**6**answers

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

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

**2**

votes

**1**answer

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

**2**

votes

**1**answer

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

**2**

votes

**2**answers

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

**3**answers

29k 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: =A3-B3-...

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

42 views

### Bitwise Operations Missing? (Excel for Mac 2011)

According to the relevant
Microsoft Support page on the BITAND function, I should have access to it, as I am running Excel for Mac 2011 (with the latest updates installed):
"APPLIES TO: Excel 2016, ...

**2**

votes

**1**answer

231 views

### Replace method generates application-defined or object-defined error in Excel for Mac

I'm having trouble with this on the latest version of Excel for Mac.
Here's the macro:
Sub Run()
'
' Run Macro
'
'
Sheets("Data").Select
Cells.Select
Range("BK1").Activate
...

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

**2**

votes

**1**answer

347 views

### How to close an excel file using terminal or python

I am using XlsxWriter to create an Excel file using a Python script.
When I re-run the script to update the file with new information, which I need to do often, I have to manually close the Excel ...

**2**

votes

**2**answers

161 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

**1**answer

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

**3**answers

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

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

**2**

votes

**0**answers

14 views

### Excel for Mac alters document names after saving

I have a 2012 non-Retina MacBook Pro with Excel 2011 for Mac version 14.6.3. Every time I save a document using the Save As command and save as a PDF document, Excel alters the name I entered as the ...

**2**

votes

**1**answer

800 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

**0**answers

147 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

**1**answer

139 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

**2**answers

961 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

**0**answers

438 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

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

**2**

votes

**0**answers

268 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

**1**answer

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

**8**answers

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

**1**

vote

**1**answer

142 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

**1**answer

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

**2**answers

45 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

**1**answer

448 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

**2**answers

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

**3**answers

3k views

### Display excel grid lines in front of a chart?

I have an area chart in Excel for Mac 2011 that I'd like to display grid lines in front of. Is there a way to do this? I know I could make the chart semi-transparent and show the grid lines through, ...

**1**

vote

**3**answers

77 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

**2**answers

286 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:
http://imgur.com/...

**1**

vote

**2**answers

38 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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

112 views

### MINVERSE only returns a single number

For the life of me, I can not get the MINVERSE function on Excel 2011 on my Apple Macbook to work.
I entered the function into a matrix.
I type =MINVERSE(A1:C3), the location of my matrix to be ...

**1**

vote

**1**answer

32 views

### Can you autofill numbers going upward?

I know how to autofill numbers going downward. But I'm curious if you can autofill numbers going upward? I'm using Excel 2011 on MacOS X (El Capitan).
It may sound counter-intuitive, but my boss ...