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
26
votes
6 answers
How to copy and paste without overwriting in Excel
I'm trying to copy a block of cells, but instead of shifting down the rest of the rows, it overwrites them
How do we copy and paste a set of cells and shift the rest so nothing is lost?
Iancovici
- 559
- 3
- 7
- 17
19
votes
4 answers
How to move columns with drag and drop in Excel 2011?
How can I move columns with drag and drop in Excel 2011?
Kenzo
10
votes
6 answers
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 align?
For example,
| 0.02 |
| -0.25 |
| …
Atticus29
- 237
- 2
- 3
- 7
7
votes
3 answers
Keyboard Shortcut to Fit Column Width to Text in Mac Excel?
On a PC this is Alt+O,C,A, as explained here.
Is there an equivalent keyboard shortcut in Excel for Mac, to fit the column width to the width of the text?
I'm using the 2011 version.
Nelu
- 565
- 2
- 8
- 18
7
votes
1 answer
Excel 2011 Mac auto-recover file lost
Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the previous document. Yes, he said and then got a document named previousfilename(version 1). To be certain that this…
jtheman
- 428
- 1
- 5
- 16
6
votes
2 answers
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 file and reopen it to look at the new version of the…
user37473
- 299
- 2
- 3
- 10
6
votes
1 answer
Remove duplicate rows, and keep newest row based on date column
I have a huge list of data in excel (250.000+ rows) in the following format:
Number Value1 Date Value2
40325 1 21/01/11 18.10 2
65485 3 22/01/11 16.47 2
40325 9 25/01/11 19.00 0
70912 8 27/01/11 16.43 …
Bjarke Mønsted
- 63
- 1
- 1
- 3
6
votes
3 answers
Excel data into PowerPoint slides
I have already found some helpful sites but I'm still unable to do what I want. My Excel file contains few columns and multiple rows. All the data from one row would be in one slide but data from different cells in that one row should go to a…
nqw1
- 235
- 1
- 3
- 6
5
votes
1 answer
How to change default size of the comment boxes
It's incredibly frustrating to resize the box every time I put a comment. Anybody know the shortcut, or can provide a clue so I can script this?
Daryll Santos
- 343
- 1
- 4
- 10
4
votes
1 answer
How to make a concentric pie chart in Excel?
I'd like to make a chart (preferably on its own sheet) that is a combination of a regular pie and a doughnut. The regular pie sits in the middle and the doughnut surrounds it.
I have seen those before, but I fail to see the option in Excel. I use…
Řídící
- 260
- 1
- 4
- 13
4
votes
4 answers
Text function in Excel isn't formatting year
I've got a problem with the text function in Excel (2007).
It doesn't format the year, it just states yyyy instead of e.g. 2014.
If I have a cell with 23-7-2014 and use the formula =TEXT(A1,"dd-mm-yyyy") I get 23-7-yyyy.
My PC is set to using the…
GasGiant314
- 53
- 1
- 3
4
votes
6 answers
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 which is updated dynamically based on anything in…
Day
- 870
- 2
- 8
- 19
4
votes
1 answer
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 clipboard has more than a few cells copied into it.
Is…
eipi10
- 141
- 1
- 5
4
votes
2 answers
How can I process million rows of data in Excel?
I understand that Excel can only process 65,536 rows of data. If I'm trying to analyze 7 million rows of data (say, plot a histogram distribution of 7 million values), is there any workaround?
Can I still sort all 7 million values even if only 65K…
ejang
- 173
- 1
- 1
- 6
3
votes
1 answer
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 a royal pain. It's quite cumbersome to search…
Ivar
- 31
- 1