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

**0**

votes

**2**answers

252 views

### How do i change the date format to UK in Excel 2011

My Excel 2011 for Macbook will accept input of dates only in US format MM/DD/YY. I would like to enter dates in UK format DD/MM/YY.

**0**

votes

**2**answers

58 views

### IF Function on excel - i need to put a formula into one cell using to < < however it isnt working

I need to put in one cell that IF the value of H3 and F3 is lower that 25000 but higher than 0 it will equal 29.95, if false 0
the formula
=if(0

**-1**

votes

**2**answers

34 views

### In MS Excel, what function should I use?

I have an original table:
Class 1 Class 2 Class 3 Class 4 Class 5
Ram Shyam Madhu Peter Xavier
Micheal Cynthia Helen Rama Hema
Peters Veronica Amy Sydney ...

**2**

votes

**1**answer

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

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

**1**

vote

**1**answer

917 views

### Comparing two similar lists in excel on mac to find duplicates

I have 2 rather long lists of companies (a developing main list and several other lists which need to be compared to the main) I need to find duplicates (but also fuzzy duplicates) - e.g. "A company" ...

**1**

vote

**1**answer

479 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

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

**1**answer

651 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

**1**answer

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

**1**

vote

**1**answer

757 views

### Excel for Mac - unable to create my own macros

I have a macro (made for Excel - Windows), which url encode strings - i.e. space becomes %20.
When I open the *.xlsm on a Mac with Excel installed(Office for Mac 2011), it does not work.
No errors - ...

**0**

votes

**1**answer

24 views

### In Excel 2011 the “date” function doesn't show the 4 digit year - can anyone explain why this happens

When I use the following, I get:
MsgBox(date) - 01/04/
?date in the immediate window, the same - 01/04/
?year(date) - 2015
?now - 01/04/ 07:18:19
I'm confused. My Macbook Pro is set to English and ...

**0**

votes

**1**answer

162 views

### Excel - Counting unique values with multiple criterias

I have a large scale data set and I am looking for a way to count the number of unique values:
Day -ID, Location-ID, Truck-ID
1, 18, 1
1, 19, 1
...

**0**

votes

**1**answer

35 views

### Using Mac Excel, How can I delete complicated duplicates?

I'm running Mac Office 2011 under Lion.
I have a spreadsheet with headers of Company, Name, Last Name, City, State, and Email. Some are duplicate entries but are missing the email. I would like to ...

**0**

votes

**1**answer

91 views

### Excel Chart Timeline

I have a CSV file that I have opened in Excel 2011 for Mac.
The CSV looked like this:
Timestamp | URL
01/Jan/2014:01:01:01 /path/to/something1
01/Jan/2014:01:01:05 ...

**0**

votes

**1**answer

150 views

### Change border color of selected cell

When I select a cell in Excel for Mac 2011 it is shown with a blue border:
How can I change the color of this border?

**0**

votes

**1**answer

536 views

### How to use Excel HYPERLINK function to link to an URL with query parameters?

*This is observed under OSX 10.8.5 with Office 2011 (mac).
The hyperlink function seems not working with url with query parameters, why?
HYPERLINK("http://mysite.com?foo=bar&x=y", "my link")
...

**0**

votes

**1**answer

64 views

### How do I seed another data table's records with category information in another Excel data table?

I have a data table, of which one of the columns is 'Categories'. It is a basic text column, but it has a finite set of strings (e.g. 'Utilities', 'Home', 'Medical', etc.) I would like to ...

**0**

votes

**1**answer

622 views

### Linking to Other Excel Sheets Greyed Out (Excel 2011 Mac)

I just got a file from my colleague which has some broken links. They were broken because the path to the cells pointed directly to a file on her computer. She sent over those files, and now I have to ...

**0**

votes

**1**answer

435 views

### Prevent Excel from converting text to columns

When I'm using Excel to parse multiple documents, and I need to control the import (Text, not General, on column import settings being the most notable example), how can I prevent Excel from ...

**0**

votes

**1**answer

152 views

### Office for Mac 2011 - unable to insert cells properly in Excel

I am unable to insert cells in a spreadsheet the way I want to.
When I try to insert two cells, the action automatically defaults to inserting a row instead of shifting cells down or right.
How do I ...

**0**

votes

**1**answer

998 views

### Merging rows in an Excel document with the same email and preserving merged row data

I have an excel sheet of around 50,000 records of something like this:
email product info moreinfo
a@a.com 866 data data1
b@b.com 960 data data1
c@c.com 976 data data1
c@c.com ...

**0**

votes

**1**answer

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

votes

**1**answer

31 views

### Excel 2011 for Mac - formula property dropdown list missing

Basically missing the dropdown properties list on Excel 2011 for Mac. How do I enable/show it?
I've already:
ticked the "show function ScreenTips option" under Excel Preferences > View > ...

**-1**

votes

**1**answer

34 views

### The value given by the Excel NOW() function

I have an Excel sheet that does a some SUMIFS() over manually entered data, including some kind of test for entry date.
When I enter a new data line, I first type =NOW() in the cell then copy-paste ...

**-1**

votes

**1**answer

30 views

### using date ranges and numbers

I have a spreadsheet that uses both dates and numbers. For example I have a job that takes 4 hours to complete and needs to be done on 10/11/13. I have several jobs that end on this date but the time ...

**2**

votes

**0**answers

15 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

**0**answers

562 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

**0**answers

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

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

24 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

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

**0**answers

960 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

**0**answers

295 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

**0**answers

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

**0**

votes

**0**answers

12 views

### Reconciling Inventory Spreadsheet with Updated Sheet

I have a workbook where one sheet (A) is an old inventory list. On another sheet (B) in the workbook, someone copied several of the columns from sheet A. Then they went around and updated the ...

**0**

votes

**0**answers

31 views

### Pairing Numbers in Excel

I have a list of congressman (and some of them repeat) and Iâ€™m looking for something that will fill in the matching distract number in the corresponding cell, so I can eliminate the risk of the human ...

**0**

votes

**0**answers

16 views

### Can Excel automatically create an x-axis range?

I'm doing a basic financial analysis with Excel. The gist of it is I have an input parameter (discount rate) plus a bunch of static data that gets fed into the =NPV(rate, x1...x_i) function. I would ...

**0**

votes

**0**answers

51 views

### Excel 2011 on OSX always opens on same monitor

I am running OSX and I have 3 monitors. In Mission Control, I have all 3 monitors to be their own Space. So each monitor has a toolbar at the top. Only one monitor has my dock on it (obviously). I ...

**0**

votes

**0**answers

74 views

### Adding to ranges within the XIRR function

The following (left side) is the standard example from the help on the XIRR function.
The 37.43% is the XIRR.
Now, assume that the initial row values are from somewhere else and I want to somehow ...

**0**

votes

**0**answers

178 views

### Mac Excel 2011 xlsm file will not open

I really hope someone might be able to help. I have just saved my research data base as a macro-enabled file. The screen went grey and hence I closed the app. On reopening, the file can be seen, and ...

**0**

votes

**0**answers

63 views

### how to perform operations between sheets in excel

My question is very easy and I'm sure there is already an answer somewhere but I don't know the correct keywords when searching for them.
So here is the question:
In column C of sheet2 I want to ...

**0**

votes

**0**answers

81 views

### Excel: can I create a pivot table that checks two columns for the same value?

Currently, I have an Excel worksheet with a table that contains ~5,000 rows. The structure works like this:
The difficulty I'm having is that "Theme" and "Theme2" have the same possible values. So ...

**0**

votes

**0**answers

2k views

### How to change default font size in Microsoft Excel for Mac?

I'm using Microsoft Excel for Mac 2011 and by default, a new spreadsheet has a font size of 12 for cells. On a 4k screen resolution, font size 12 is a bit small, so I have selected the whole ...

**0**

votes

**0**answers

174 views

### Mac error opening hyperlinks from Windows Excel workbook

I have an Excel spreadsheet that has many hyperlinks in cells to external documents. All documents and the Excel file are in one folder. This folder is uploaded to Dropbox using a Windows 7 platform. ...

**0**

votes

**0**answers

81 views

### Excel - Updating a .xlsb file when saving a .xlsx file

I work on Excel for Mac 2011.
Sometimes, for no apparent reason, I can't open one file I saved in .xlsx. I did some research and found it was a bug. The only workaround I found is to save the file ...

**0**

votes

**0**answers

513 views

### VBA not working in Excel for Mac 2011

I bought a Macbook Pro and Office 2011. Am trying to use an Excel file with VBA code and macros, which works on every other Windows PC I've tried. Unfortunately it doesn't on my Mac. Office 2011 is ...

**0**

votes

**0**answers

94 views

### How to keep track of manual entries each day?

I am trying to keep track of manual entries but do not know the correct method of doing this. Should it be done using vba or by using formulas? I have spreadsheet you can view so you can see what I am ...

**0**

votes

**0**answers

67 views

### Is it possible to use alt-XYZ shortcuts on Excel on OS X?

I don't want to know the equivalents -- I want to use the same commands. I'm switching between windows at work and a mac at home.