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

learn more… | top users | synonyms (1)

0
votes
0answers
7 views

How can I manipulate Mac Excel 2011 to automatically populate a table from change in stock?

Good evening everyone. You will have to excuse my poor descriptives as I am not overly literate with general computing. I am running a MacBook Pro with Excel 2011 and the latest OS X (El Capitan 10.11....
1
vote
2answers
6k views

Can I link images using a relative path?

I am working on an MS Excel workbook that contains around 200 images. They are currently saved within the workbook, so the file becomes huge and working gets very slow. Linking the pictures without ...
0
votes
2answers
3k views

Excel 2011 for Mac/ Pivot table / tabular layout how to “fill down?”

I've got a great pivot table in tabular layout, but how do I "fill down" values in column A? A10 should also read "Alpaha Police" A15:A18 should also read "Atkinson Co Sheriff"
3
votes
6answers
11k 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 ...
-1
votes
0answers
7 views

Highlight names in column A, sheet 1 that are found in Column C, sheet 2, 3, etc

I have a list of names in column A, sheet 1 that I would like highlighted if the names are found in column C, sheet 2, 3, 4, etc. I am trying CF, but cant quite seem to get it. please help.
1
vote
8answers
22k views

Duplicating a row with formulas, without changing cell references

i have a large financial spreadsheet with a ton of formulae. i'd like to duplicate a row such that it retains the same formula and coordinates as the source row (basically duplicate a summary row and ...
2
votes
2answers
11k 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 ...
0
votes
1answer
21 views

Auto refresh Excel worksheet after changed by external application?

I have a question similar to this one but I'm just using an Excel file, no CSV involved: Open a .csv file in Excel and have it update whenever .csv file changes I have an Excel file that I ...
-1
votes
1answer
32 views

How to use non-contiguous range arguments in Excel's XIRR?

The XIRR requires range arguments. I would like to know how I can somehow use 'split' ranges which are in different locations. Perhaps the picture explains it better. What do I enter in F7, if I want ...
2
votes
0answers
14 views

Excel for Mac alters document names after saving

I have a 2012 non-Retina MacBook Pro with Excel 2011 for Mac version 14.6.3. Every time I save a document using the Save As command and save as a PDF document, Excel alters the name I entered as the ...
0
votes
0answers
19 views

How do I create a macro in Excel for Mac? [duplicate]

I have found this thread on this topic How to get the list of sheet names of ms-excel? But I have no idea how to create the macro people are talking about. I will be grateful for your help on how to ...
2
votes
3answers
28k views

Excel: formula to display answer only if ALL cells in a formula have a value

I have a scenario where I don't want excel to use a blank cell as a zero value. I only want the cell to display the result if all the cells in the formula have a value entered. For example: =A3-B3-...
2
votes
1answer
5k views

Find first number greater than x and return another value in that row

I have created an investment spreadsheet. In one column I have the ending balance each year. In another column I have the years. A B 2000 500K 2001 450K 2003 1.2M 2004 1.5M How can I display ...
0
votes
2answers
357 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() ...
1
vote
1answer
44 views

Get rid of PivotTable help on Excel for Mac

Every time I start up Excel For Mac 2011 and build a Pivot Table, Excel feels it's needed to remind me in a modal what Pivot Tables do ("PivotTables summarize data and reveal patterns and trends"). ...
1
vote
1answer
72 views

How do I use Excel 2011 Personal Macro Workbook?

I realized I asked about excel 2010, but that only covers Windows OS. How can I use the Personal Macro Workbook in Excel 2011 on OSX?
0
votes
2answers
20 views

How to find the number of rows that have date time fields between 5 and 6 PM

I have a phone log that I want to report some data off of. All of the solutions out there that I have looked up seem to assume I only have a time value and that they don't include an actual date. I ...
2
votes
1answer
35 views

Bitwise Operations Missing? (Excel for Mac 2011)

According to the relevant Microsoft Support page on the BITAND function, I should have access to it, as I am running Excel for Mac 2011 (with the latest updates installed): "APPLIES TO: Excel 2016, ...
0
votes
2answers
3k 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
82 views

Hide a Control Box in Excel

I have some radio buttons in Excel (2011 Mac), and they are grouped by a Group Box. I want to make the Group Box invisible. I searched on the internet and found that I could do that with VBA by ...
0
votes
1answer
17 views

Uncrowding a scatter plot when most points lie near lower end of X-axis

Given an Excel scatter plot thus: where the bulk of the points lie at the lower end of the X-axis, how can the lower end be made to look less crowded (without removing data points), while ...
0
votes
1answer
1k views

X axis on Time-Based data

I have a series of 24 hr. data, taken about once per hour. I wish to plot the values against time. On day 1 the 10:00 data was taken at 10:10, on day 2 the data was taken at 9:58. I do not want both ...
0
votes
0answers
32 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
16 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 ...
3
votes
1answer
2k 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?
1
vote
1answer
99 views

MINVERSE only returns a single number

For the life of me, I can not get the MINVERSE function on Excel 2011 on my Apple Macbook to work. I entered the function into a matrix. I type =MINVERSE(A1:C3), the location of my matrix to be ...
0
votes
1answer
30 views

Concatenating datas from different sheets

I have an Excel workbook with 2 sheets. Sheet #1 contains 2 columns, names and points. | A | B | |-----------|----| | John Doe | 65 | | Jolly Doe | 45 | | Hello Doe | 50 | Sheet #2 ...
3
votes
6answers
16k views

How do I align a column of numbers by decimal point in Microsoft Excel when some of those numbers are negative?

Let's say I have a list of the following numbers: 0.02 -0.25 -4.13 5.24 -11.36 40.61 -141.20 How would I align them in a column such that they are left-justified in the cell but the decimal points ...
2
votes
1answer
3k views

How to return first non-blank cell and if it's already a value before it, return the third non-blank and so on?

How to make a function which would return the first non-blank cell value but if it's defined in the left cells next to it, it would jump 2 cells and look for the next value. Table: 1 | 2 | 3 | 4 | ...
0
votes
1answer
33 views

How to get the difference between 2 cells

I have an Excel file like below. The value in column C should be the difference between A and B (A is always longer, B is always A substring). If both values in A and B are same, C will be empty. ...
2
votes
3answers
11k views

Formula to move data from every third row to a column?

I have an excel sheet (mac, Excel 2011) that contains names (1st row), job titles (2nd row), and company/institution (3rd row) in one big column. I am trying to separate them into three different ...
0
votes
1answer
32 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
0answers
35 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
1answer
65 views

Excel formula disappears when saving as .xls

I have a long formula in one of my cells. It is: =IF(K11=1,MATCH(C66,valv1,-1),IF(K11=2,MATCH(C66,valv2,-1),IF(K11=3,MATCH(C66,valv3,-1),IF(K11=4,MATCH(C66,valv4,-1),IF(K11=5,MATCH(C66,valv5,-1),IF(...
0
votes
2answers
996 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 ...
1
vote
1answer
32 views

Can you autofill numbers going upward?

I know how to autofill numbers going downward. But I'm curious if you can autofill numbers going upward? I'm using Excel 2011 on MacOS X (El Capitan). It may sound counter-intuitive, but my boss ...
1
vote
0answers
56 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 =A6+...
0
votes
1answer
14 views

Can Powerpoint update two Excel objects that are from the same Excel file?

I've been reading through the forums and haven't come across a definite answer for my query. I have a PPT presentation that includes 2 different worksheets from the same Excel file, pasted as Excel ...
17
votes
4answers
48k views
1
vote
1answer
232 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 ...
2
votes
6answers
14k views

How can I get Excel 2011 to stop opening my Personal Macro Workbook?

Ever since I created a couple of macros in Excel for Mac 2011, the Personal Macro Workbook opens every time I open Excel. How do I keep that from happening? I have since deleted the macros, but I ...
0
votes
0answers
105 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 ...
2
votes
1answer
27k 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 ...
0
votes
0answers
49 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
1answer
24 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 ...
2
votes
1answer
219 views

Replace method generates application-defined or object-defined error in Excel for Mac

I'm having trouble with this on the latest version of Excel for Mac. Here's the macro: Sub Run() ' ' Run Macro ' ' Sheets("Data").Select Cells.Select Range("BK1").Activate ...
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 ...
1
vote
4answers
16k 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: ...
2
votes
1answer
306 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 ...
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 ...