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

learn more… | top users | synonyms (1)

0
votes
2answers
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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
0answers
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.