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

**5**

votes

**1**answer

433 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

**1**answer

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

**4**

votes

**2**answers

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

**4**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

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

**5**answers

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

**2**answers

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

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

**3**answers

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

**2**answers

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

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

505 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

**1**answer

95 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

**1**answer

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

**0**answers

211 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

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

**0**answers

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

**6**answers

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

**1**answer

129 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

**2**answers

21 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

363 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

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

40 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

148 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

**2**answers

25 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

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

**1**answer

372 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

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

**2**answers

665 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

**2**answers

26 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

**1**answer

191 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

**1**answer

43 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

**2**answers

158 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

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

**0**answers

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

**1**

vote

**0**answers

22 views

### Comparing two spreadsheets and add data from one if it meets both email address are correct

I want to compare two spreadsheets against using email address and if the email address matches then take information from a cell and add it the the 2nd sheet.
Example Sheet columns:
ID
First name
...

**1**

vote

**0**answers

64 views

### Excel 2011 conditional formatting, problems w/ adding deleting rows [duplicate]

I have a standard form I use that requires an row to be highlighted one of 7 colors when a condition is met in a cell in that row. The form varies wildly in length. Currently, I am using conditional ...

**1**

vote

**0**answers

28 views

### Excel for Mac 2011 - Conditional Format - Look inside formula for sheet reference

I would like to use conditional formatting to locate all cells on a large sheet (Sheet 1) that have a reference to another sheet (Sheet 2) within a formula in a cell on Sheet 1. I was hoping I could ...

**1**

vote

**0**answers

38 views

### Excel for Mac 2011 move column 2 in sheet 1 to column 1 in sheet 2

I would like to move column 2 into column 1 for each successive sheet, one sheet per week, automatically. Is that possible? I do it with this formula ='1st week'!D2 and manually changing '1st week' to ...

**1**

vote

**1**answer

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

**1**

vote

**0**answers

944 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

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

**1**

vote

**0**answers

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

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

**1**

vote

**0**answers

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

**1**

vote

**1**answer

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

**1**

vote

**0**answers

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