Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

-3
votes
0answers
38 views

EXCLE - Input a number and have a reaction based on a drop down options

I need that users can enter a number in a specific cell and then select a dropdown option to indicate if the number they entered is a POSITIVE# or a NEGATIVE#, to minimize error. Like: if a user ...
0
votes
0answers
14 views

Custom Cell Format - Microsoft Excel for Mac 2011

I applied a custom format to cells. The custom was adding parentheses to text. The text looked like 2010-01. After adding the custom format it looked like (2010-01). I have a worksheet with a ...
0
votes
0answers
33 views

How to show number labels on the minor divisions of the Y axis in Excel

How do I show number labels on the minor division of the Y axis in Excel 2011? For example, between 1,000 and 10,000 on the chart below, can I add labels like 3000, 7000, 8000 to the axis?
0
votes
1answer
40 views

Using INDEX and MATCH, IF and AND to return the column title of a cell Excel 2011 Mac

[enter image description here][1]I have a data set consisting of columns representing 0.1 metre increments, and for each column I have a numerical value. These numerical values decrease as the ...
0
votes
0answers
49 views

Automatically format currency based on the currency in another cell

Cell A1 can be any currency I want Excel to automatically format the currency of cell B1 to match the currency of cell A1. I assume this involves conditional formatting but I don't know how to write ...
0
votes
1answer
851 views

Excel: Combine multiple rows but keep column data?

I have an Excel spreadsheet (Excel 2011 for Mac) with 1175 rows containing species names (431 names total) and 72 columns (A:BT) of months from October 2011 to August 2017. Each row only has one cell ...
0
votes
1answer
31 views

Need to Delete Blank Row including All Data in the Row - Excel 2011 for Mac

I have an Excel spreadsheet of email addresses with first and last names. Some of the names do not have an email address and it's blank so I want to delete the blank fields along with the first and ...
0
votes
0answers
10 views

24" iMac, OS 10.7.5 - Office 2011 - text changes point size

24" iMac, OS 10.7.5 - Office 2011 - any idea why Excel changes pt size of type if I change the colour of the text - it only happens if there's a half, e.g. 4.5pt instantly changes to 5pt. Is there any ...
0
votes
0answers
22 views

Dividing a number by the sum of a range of cells

I'm trying to spread a transport cost over the number of units that were delivered (that's the back story). My question is: how do I write a formula in F3 that divides E3 (£40.00) by the sum of C3 ...
0
votes
1answer
38 views

Excel: What's causes an option to appear twice in a drop-down menu?

I am working on a budget and I have a drop down menu for the items. I have one category called Food but when I type in Food, it appears that there are 2 options I can only select one of them and not ...
0
votes
1answer
42 views

Create custom hyperlinks in Excel

I am looking for a formula to automatically create custom hyperlinks into an excel spreadsheet, based on contents of another cell I have a list of books where I can get the image from an url database....
1
vote
1answer
8k views

How do I automatically sort a table in Excel every time one of its values is updated?

I'm keeping the results from a season of the baseball board game Strat-O-Matic in an Excel spreadsheet (Excel 2011 for Mac). The sheet has the league schedule and league standings. I've already set it ...
1
vote
1answer
34 views

Match two columns, and bring along values in the corresponding columns - Microsoft Excel for Mac 2011 v. 14.4.1

I need to match two columns (B and C) and move down the values (C and D) inserting an empty line where there's no match. into this Is there a formula that can do this?
1
vote
0answers
82 views

Office Excel 2011 for Mac : when exporting an excel sheet to csv, around 25000 empty csv lines get added

so when saving as windows csv and press save i get the actual data: 1,1,2, then i get around 25'000 lines: ,,, ,,, ,,, ,,, ,,, ,,, .... when i do the same with libre office i get only the data, no ...
0
votes
1answer
353 views

How to do conditional formatting with date comparison on Excel 2011

Please forgive me since I don't know where to start with this problem. I have an Excel sheet with multiple columns. Two of the columns are dates in the format of "MM/DD/YYYY HH:MM:SS", column A and ...

15 30 50 per page