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

learn more… | top users | synonyms (1)

3
votes
1answer
1k 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
1answer
2k 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
155 views

How can I use a macro to group and average the values in an Excel column?

I'm new here and I've been struggling with macro writing. I was wondering if anyone could help me out with making/explaining a macro that could be used in my data set. I have an Excel file that looks ...
1
vote
1answer
245 views

How to close an excel file using terminal or python

I am using XlsxWriter to create an Excel file using a Python script. When I re-run the script to update the file with new information, which I need to do often, I have to manually close the Excel ...
1
vote
1answer
79 views

How do I match cells in one worksheet to another and print a result?

Not new to excel, but new to formulas. I have to say this is killing me. So what I am trying to do is take strings in one column, check if any of them are in another column of a separate worksheet, ...
1
vote
1answer
2k 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
764 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
550 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
955 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
25 views

Merge two sheets on two columns into a new sheet in Excel?

I'm using Excel 2011 on OSX. I have Sheet1 that looks like this: pupil_id date test_score 1 2015/10/01 98 2 2015/10/01 83 And I have Sheet2 that looks ...
0
votes
1answer
22 views

Getting the name of a named cell in MS Excel 2011

I am using a formula in Excel, which involves cell names. The formula is =MIN(name1,name2,name3) name1 is the smallest, but it shows name1's value. I want it to show the text "Name1". How do I do ...
0
votes
1answer
16 views

Sorting using Subtotals and Data Subtotals

In sorting using Subtotals via Data Subtotals, is there a way I can get all lines of info to come down NOT just the ones I'm totaling? The only way I have remedied it is copying it down from the Page ...
0
votes
1answer
37 views

Error in importing the numbers in scientific notation

I am importing(copy-paste) values into Excel from R Console which are in scientific notation (1.920943e-10, 7.580894e-05). Excel is not treating them as numbers instead text. How to resolve this ? ...
0
votes
1answer
22 views

I want to take two columns of cells (not the whole columns) and copy them and sort them into different cells

My Table: I want to copy the names and scores from the desirability score area into the "Most to least desired rooms area but place them in descending order. How do I do this? Edit: I want the ...
0
votes
1answer
143 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
106 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
1answer
194 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
58 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
219 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 ...
2
votes
0answers
128 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
400 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
49 views

Why doesn't Excel auto-adjust formula when a row is moved?

I have a simple spreadsheet with just one formula, which auto-increments the number in the first column, going from cell A6 down. So the value in A6 is hard-coded 1, then A7 contains the formula ...
1
vote
0answers
128 views

EXCEL 2011 - Inventory with Matrix and Vlookup

I am creating an inventory matrix, which has on the first column a list of all the items in the inventory, and on the first row a list of the dates for when the inventory gets renewed. Basically, not ...
1
vote
0answers
99 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
44 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
33 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
45 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
438 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
345 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
29 views

Using SUMPRODUCT to total column range X if meets numerical criteria in range Y

I am seating people for an event. There are 16 tables (column E). People may come alone, with spouse and/or guests (total for each in column I). I want a way to get a table count as I work through ...
0
votes
0answers
13 views

Predefined chart styles in Excel available to other users?

I need to set up a MS Excel document with custom chart styles. As far as I understand the style of an existing, customised chart can be saved as a predefined chart style. I then need this style to be ...
0
votes
0answers
32 views

Group different values with same name field in Excel

I'm having troubles with the following document. Is there a way to group different values with the same name field?
0
votes
0answers
95 views

How do I setup Excel to chart a budget with multiple currencies and categories?

I am using MacOS X and Excel for Office Mac 2011 version 14.2.4. I have three separate currencies: Chinese yuan (¥), US dollars ($), Thai baht (฿). Each currency has its own table with the following ...
0
votes
0answers
47 views

Separating concatenated name, address, and phone number

I imported company names, addresses, and phone numbers into a cell. Due to the different number of characters, I cannot separate the fields of information with text to columns; for example: ABC ...
0
votes
0answers
53 views

sum rows and columns depending on two values

I got the following table in Excel (Microsoft Excel 2011 for Mac). It is basically for controlling issues. It shows a number of persons (employees) that are assigned to specific work-packages that ...
0
votes
0answers
106 views

OS X 10.9.5 and Microsoft Office 2011 corrupt table formatting troubleshoot

My task was to take three columns of data – "item #", "description", and "quick ship" (each column contains lots and lots of data...) from Excel and move that into information into a table in Word so ...
0
votes
0answers
50 views

Regroup rows based on a column value

I have the following data: Last Name | First Name | Division Doe | Jane | A Doe | John | B Does | Michael | B So, every user is assigned to a group. Now what I would ...
0
votes
0answers
66 views

All Data Option Filter Validation

I am creating a dashboard that has five inputs that filters my data by the custom data validation combination. My dashboard updates correctly based on the custom combinations, but I am unable to add a ...
0
votes
0answers
115 views

Update Table based on Range start value and end value

I have a set of data that uses a primary key of month of the year by numerical value, e.x. Month 1, Month 3. I am trying to update my table and its values from the raw data set based on a user entered ...
0
votes
0answers
96 views

Group dates as MM-YYYY on Pivot Table

I'm using Excel 2011 for Mac. I have a sheet with dates that I have grouped into a Pivot table. The data spans across months of 2013 and 2014. I want to chart the trends over a month of a year, but ...
0
votes
0answers
156 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
141 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
215 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
5k 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
136 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
717 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
135 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
69 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.
-1
votes
0answers
15 views

Get a “Invalid procedure call or argument (Error 5)” in Excel 2016 but not in Excel 2011

Here's the relevant code in the BurnUpApplication Module: For Each slice In slices graph.drawSlice slice Next Which calls the following code in a CBurnUp class: Public Sub drawSlice(slice As ...