The 2011 version of Microsoft's spreadsheet application for OSX.
Included in Microsoft Office 2011 for Mac, it replaced Office 2008 for Mac. It is the MAC OS X version of Microsoft Excel 2010.
Questions tagged [microsoft-excel-2011]
173 questions
3
votes
1 answer
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 then type my next number, hit enter twice, and so…
JJ Rohrer
- 161
3
votes
3 answers
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-C3
When only A3 and B3 have values entered, I would…
lt78
- 31
2
votes
1 answer
How to disable moving down on Enter key in Excel 2011 for Mac?
When entering data in a cell and pressing enter, the cursor moves down one step. How do I disable this?
user3934760
- 37
2
votes
0 answers
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 document name; specifically it always adds the…
MorrisIriga
- 260
- 1
- 3
- 13
1
vote
0 answers
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.
oskare
- 123
0
votes
1 answer
Excel 2011 - make a cell display another cells value if its adjacent cell is equal to a 4th cell
For example, if the value in I31 equals a value in column A (lets say A5) I want to display B5 (so same row) in a new cell (say I32). How can I do this?
Jared
- 45
0
votes
1 answer
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 would display as 01/04/2015. I can't see any…
0
votes
2 answers
MS EXCELL =SUM IF formula
I need to formula for the following
iF a1= 1 then d1 must = b1+c1
tried =sumif(a1,"1",b1:c1)
I only want cell d1 to calculate if cell a1 is '1'
lyndon
- 1
0
votes
1 answer
(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 =CONCATENATE(A1,B1,C1) = it Works thus far.
the prior instruction’s…
