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
28
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
- 579
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
7
votes
1 answer
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
- 573
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 …
6
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
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
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
5
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
- 880
- 2
- 8
- 19
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
4
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
- 41
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
4
votes
2 answers
Can I link images in MS Excel 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 saving them works very well -- I now have the…
Port Islander 2009
- 41
- 1
- 1
- 3
4
votes
4 answers
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 columns. I've tried all the macros i could find.…
user1672691