Questions tagged [microsoft-excel-2011]
The 2011 version of Microsoft's spreadsheet application for OSX.
12
questions
2
votes
2
answers
7k
views
Prevent Excel from converting text to columns
When I'm using Excel to parse multiple documents, and I need to control the import (Text, not General, on column import settings being the most notable example), how can I prevent Excel from ...
6
votes
1
answer
47k
views
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 ...
3
votes
3
answers
75k
views
Locating Autorecover files Excel 2011 doesn't find
When Excel 2011 crashes, it often does not automatically re-open the latest version from the auto-recover files. Instead Excel may bring up the last user saved version that may not have the latest ...
1
vote
1
answer
65k
views
How do you plot time on the X axis in excel?
I need to plot the decay of my phone's battery against time over night. My starting time is 23:17:47 and my ending one is 07:05:49. I don't have any issue in changing the time format in the current ...
19
votes
4
answers
56k
views
How to move columns with drag and drop in Excel 2011?
How can I move columns with drag and drop in Excel 2011?
6
votes
3
answers
70k
views
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 ...
3
votes
2
answers
7k
views
How to get the list of sheet names of ms-excel?
I have an excel file which has a lot of sheets. How could I get a list of sheet names of ms-excel?
(PS: The office is mac version.)
1
vote
1
answer
182
views
Error message when trying to retrieve a value from a range using VLOOKUP
I've got an excel spreadsheet where I would normally use a VLOOKUP.
In this case I need to find the ID of the record when comparing email addresses, so the email address is the unique id here.
For ...
1
vote
1
answer
769
views
Show date format in Excel as the OS default
Is there a way in Excel (2007 and up) to set the date format of a column to the date format of the OS locales. The data entered in this column is a date (imported from a database date field).
For ...
1
vote
8
answers
37k
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 ...
0
votes
2
answers
2k
views
How to correct floating point round-off error in Microsoft Excel for Macintosh 2011?
I'm using Microsoft Excel for Macintosh 2011 and have a spreadsheet of start and stop time spent on activities with some time differences between start and stop times that are converted into total ...
0
votes
1
answer
374
views
Error in importing the numbers in scientific notation
I am importing(copy-paste) values into Excel from R Console which are in scientific notation (1.920943e-10, 7.580894e-05). Excel is not treating them as numbers instead text. How to resolve this ?
...