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

**1**

vote

**0**answers

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

**0**

votes

**2**answers

18 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

**0**answers

32 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

**2**answers

18 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

**1**answer

36 views

### About the maximum number of arguments in Excel's STDEV function

According to Excel's Help Center you can only use the STDEV function for up to 255 arguments.
1 to 255 number arguments corresponding to a sample of a population.
However, when I take the STDEV ...

**0**

votes

**1**answer

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

**1**

vote

**0**answers

35 views

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

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

**0**

votes

**2**answers

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

**0**

votes

**1**answer

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

**1**

vote

**0**answers

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

**0**

votes

**0**answers

29 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

**1**answer

43 views

### Edit current cell via keyboard?

In Excel for Macintosh 2011, when the cursor is in a particular cell of a spreadsheet and you wish for the focus to move to the edit line for that cell where the formula is displayed, is there a ...

**0**

votes

**0**answers

492 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

**3**answers

640 views

### How can I sort my data while keeping paired rows together?

How can I pair two rows on a spreadsheet, so that for each data entry I can sort the matrix but the pair of rows moves as a single list of data, retaining the structure of the two rows?
For example:
...

**0**

votes

**1**answer

50 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

50 views

### Search Excel price grid with variable values

WIDTH
DROP 1150 1550 1850 2160 2360 2750 3000 3480 3980 4450
1200 338 348 378 413 431 450 467 513 ...

**0**

votes

**2**answers

134 views

### VBA Excel 2011 for Mac: Create custom category for user defined function error

I created several functions i.e.: "cal_adval". I would like to add it to a new function category named "Custom Clearance"
I read the documentation, and wrote this macro:
Sub add_category()
...

**0**

votes

**1**answer

48 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

**2**answers

153 views

### Nneed to calculate average of NON sequential multiple cells & I want to exclude values = 0 or Empty Cell with AVERAGEIF

Nneed to calculate average of NON sequential multiple cells and I want to exclude values = 0 or Empty Cell with AVERAGEIFS.
There is a mistake in my formula but I can't find a way to have it since ...

**0**

votes

**2**answers

161 views

### How can I summarize age ranges and counts in Excel?

I have a table with a long list of individuals, and their age. From this data, I was able to derive a list of all ages, and then count how many people were of each age. Here is some simple, sample ...

**1**

vote

**2**answers

96 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:
...

**0**

votes

**0**answers

52 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

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

**-1**

votes

**1**answer

37 views

### How do I adjust the width of a series in an Excel chart?

Here is a picture of my current chart:
I've tried to modify the scale to get the series' (the column) to be thicker. Ideally, I'd like the columns to be closer together too. I've double-clicked on ...

**-1**

votes

**1**answer

50 views

### How do I reference a cell in an Excel data table without using the cell coordinates?

I do a summation on the values of a set of cells in an Excel data table. The problem is when I sort the table, the values in those cells change (because the records get sorted) and this changes the ...

**0**

votes

**3**answers

36 views

### What can an Excel table do?

I don't really understand why I should use an Excel table. It seems all the functionality that a typical Excel worksheet provides is duplicated by an Excel table. The only difference I can see is that ...

**0**

votes

**0**answers

66 views

### Make Excel Row Height Stay Once Sorted [duplicate]

One column has variable length data that may be one row or maybe a bunch of rows deep. (Actually another column does as well, but it doesn't get more than 3 rows deep).
When I sort my spreadsheet, ...

**1**

vote

**2**answers

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

**0**

votes

**1**answer

194 views

### Sum the number of hours in Excel

I want to sum the total hours I was worked in a project. For each day, I have:
Starting Time B1: 09:30:00 am
Ending Time C1: 17:00:00 pm
Total Hours D1: =C1-B1 (06:30)
I want to sum the values ...

**0**

votes

**1**answer

319 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

**2**answers

35 views

### EXCEL: IF function only working if Value is TRUE and remitting a #NA if the Value is FALSE: Apple Mac Air - Microsoft Office 2011

Can anyone help me with the following formula? Basically it works when the condition is TRUE but gives me an error when the condition is FALSE. I would like the cell to remit the value "0" if the ...

**0**

votes

**1**answer

411 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

**0**answers

23 views

### Issues keeping external web data in cells and columns upon refresh?

I have made a spreadsheet where I have multiple web queries to upload weather data from different locations.
I need specific MAX/MIN temperatures, etc. I can pull the data into Excel, but once I have ...

**0**

votes

**0**answers

69 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

**1**answer

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

**1**answer

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

**-1**

votes

**1**answer

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

**0**

votes

**1**answer

213 views

### How to set a shortcut to “Customize Keyboard…” in Excel Mac 2011

I would like to set a shortcut to "Customize Keyboard..." in Excel Mac 2011 so I could open the "Customize Keyboard" menu via a simple shortcut.
Apparently we can't do do it via Excel because there ...

**0**

votes

**0**answers

12 views

### Change focus in Excel to formula bar via keyboard using Excel 2011 in Mac [duplicate]

I want to ask the same question as this one but for Microsoft Excel 2011 in Mac. The issue is that in Excel 2011 for Mac there is no Tools -> Options.

**2**

votes

**1**answer

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

**0**

votes

**1**answer

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

**4**

votes

**1**answer

263 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?

**0**

votes

**1**answer

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

**1**

vote

**1**answer

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

**0**

votes

**2**answers

70 views

### Mac OS 10.8.4 and Excel

I am trying to delete everything after the "," on each cell in a column of email addresses. For example:
jonsmith@hotmail.com,2013-08-06 13:27:53,bounced
sallyfield@google.com,2013-02-06 ...

**0**

votes

**1**answer

345 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

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

**0**

votes

**1**answer

237 views

### Print multiple worksheets to a single physical page

If I have three worksheets in a workbook, how can I print them on the same physical page?
On Excel for Mac 2011, doing "Print What" "Entire Workbook" gives me three different pages, even if in ...

**1**

vote

**2**answers

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

**3**

votes

**4**answers

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