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

**0**

votes

**2**answers

40 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

37 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

**0**

votes

**2**answers

134 views

### Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula ...

**2**

votes

**1**answer

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

**1**

vote

**1**answer

369 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

549 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

450 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

**1**answer

155 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

30 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

72 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

78 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

426 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

682 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" ...

**0**

votes

**1**answer

53 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

92 views

### How to inspect which values were used in calculation in Microsoft Excel?

In cases where I have complicated formulas like
=HLOOKUP(ROUNDDOWN((D$165-1)/12,0)+1,$D$24:$M$25,2)*D$2
Is there a good way to see which values ended up being used in the calculation? In this ...

**0**

votes

**1**answer

485 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

306 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

125 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

162 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

29 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

189 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

18 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

25 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

852 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

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

**0**

votes

**0**answers

22 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

75 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

49 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

57 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

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

73 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

461 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

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