The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
1answer
9k views

Sum up totals if name is Persons Name [duplicate]

Possible Duplicate: Sum Values in One Range Based on Criteria in Another I have several columns in a spreadsheet with date, item, order etc. but also 2 columns: Column K - Owed By Column ...
0
votes
1answer
1k views

How to import row data into Access when Excel does a date conversion?

I have an Excel worksheet that looks like this: MONTH WIDGET QUANTITY COST Jul-09 Widget1 1000 1.00 ... <repeat a few thousand times> ... I would like to ...
1
vote
3answers
1k views

“clustered column” PivotChart using percentages isnstead of values - Excel 2010

My Excel 2010 data (simplified) looks like this: Product ID Product Family Safe For Kids Under $10 Free Shipping ...
2
votes
1answer
2k views

What's the difference between PowerPivot and regular pivot tables?

I keep reading how PowerPivot lets Excel process "millions of rows" (!!). I'm already doing this with a regular old pivot table hooked up to a (relational) SQL database. What does PowerPivot do ...
5
votes
4answers
22k views

Change border color of multiple cells in Excel 2010?

While it is easy to change the font color and fill color of multiple cells at once in Excel 2010, I can't find a way to do this with border colors. Is this possible?
7
votes
2answers
38k views

How to autofill Excel cells by week?

Let's say I type in 7/1/2011 into cell A1. I autofill/drag down the grippie and the cells beneath fill with an incremental days. Is there a way to autofill by week? In other words, cell A2 should ...
0
votes
2answers
2k views

Converting a formula from MS Excel 2010 to MS Excel 2003?

In Excel 2010 the forulma I am using is: =_xlfn.IFERROR(INDEX(K$76:K$2044,MATCH(Q23,P$76:P$2044,0),1),INDEX(K$76:K$2044,MATCH(Q23,L$76:L$2044,0),1)) But I need to convert it to excel 2003. I have ...
0
votes
2answers
364 views

Scroll wheel not working during selection

In Excel 2010, my scroll wheel doesn't scroll on roll while I'm holding the left mouse button to make a selection. Without the left mouse button, it works. Is it a bug or just me, any remedies? To ...
2
votes
1answer
193 views

Macro Help: Finding a replacement for Cut and Delete for Speed

I’m looking for a way around using the commands .delete .cut In my excel macros. I’m finding that these processes greatly slow down the procedure (by up to 20 min) for the more data it has to cut ...
2
votes
1answer
6k views

Make COUNTIFS count duplicate values only once

I've got all this data on test runs: controller start end start ts end ts 1 1:13 1:15 1:00 1:30 1 2:08 2:25 2:00 2:30 4 4:02 4:16 4:00 ...
1
vote
1answer
852 views

Replacing wildcard characters like ? in Excel

Was is das? I try to replace the ? symbol to the ! symbol in Excel (2010)... and this changes all the chars to !??? I try to make a conditionnal formatting for cells that contains ? but it applyes ...
0
votes
1answer
2k views

Secured excel sheet cannot expand/collapse grouped columns

We have an Excel spreadsheet with a secured/protected sheet. Only a small number of cells are open for editing. Now that it is protected, we cannot expand or collapse the columns in that sheet ...
3
votes
2answers
766 views

Chart data by month

I've the following data in an excel spreadsheet: Date (dd/mm/yyyy) Value ----------------- --------- 01/04/2011 123.45 03/04/2011 7234.25 16/05/2011 80.00 ...
2
votes
1answer
1k views

How do I disable multithreaded calculation in Excel 2010 - as a permanent setting (without needing to set it on a worksheet)

I need to be able to have excel 2010 open (in windows 7 if it makes a difference) and have this setting defaulted to off. I've tried unchecking the box and closing excel, saving the setting on the ...
3
votes
1answer
1k views

Pivoting concurrent start and end times into timeslots with Excel 2010 PivotTable

I've got a table of processes and their respective start and end times (calculated from the start time and duration), listed by the process ID: Run ID Duration Start Time End Time 200878 464 ...
1
vote
0answers
6k views

Windows 7 can't open Excel 2010 .xlsm files?

I just reinstalled Windows 7. When I installed Office 2010 I deselected some components to save disk space. Now, I can't open xlsm files. I would like to know which components in the Office ...
2
votes
3answers
137 views

Finding the number of specific characters inside a formula

I'm trying to find the number of of +'s in a formula inside a single cell in excel. If it were a normal cell with text inside, this would be quite easy. But due to the restrictions of the file I'm ...
3
votes
1answer
434 views

Macro Find: Is there a macro to Format a Word Document as if it were beign created in VBA?

I have a lots of code(for Excel) in Vba and would like to transfer a copy of it into a word document. Does anyone know of a macro that will format the word document to treat the code as if it were in ...
7
votes
2answers
3k views

How do I get excel to not mess around with the formatting of a .csv file

I have two issues with a csv file that occur when I try and edit it in Excel. I have an ISBN column that gets reformatted to scientific format every time I save the file The encoding for the file is ...
4
votes
2answers
5k views

Export of a custom table style in MS Excel

How to export a custom table style in MS Excel 2007/2010? I know how to export a custom chart, but I can't see how to export a custom table style.
0
votes
2answers
808 views

Summing of total with dynamics rows coming external datasource

I am using Excel 2010 and retrieving data from SQL analysis service. When I refresh the data from Excel, the rows all refresh as they are bound to an external datasource. I am adding a separate ...
0
votes
1answer
630 views

Excel 2010 pivot table data filtering

I have a pivot table with each row having an error code (say, widget defect code, with 0 being no error). I want to be able to summarize the data with total error rates, but I'd also like to summarize ...
1
vote
1answer
247 views

Excel userforms

I have developed a macro that does a whole bunch of things for me based on a few things. (Importing files). The file names are dated dd_mm_yyyy and right now I enter them into a sheet where the macro ...
2
votes
4answers
3k views

Can one list everything that uses a particular cell in Excel 2010?

I've been tasked with making changes to an Excel 2010 spreadsheet I know little about. One of the biggest changes the client wants is to remove numerous cells that are no longer needed by his ...
2
votes
2answers
1k views

How does one find the definition of a function in Excel 2010?

I've been tasked with making changes to an Excel 2010 spreadsheet I know little about. I was pretty good with Excel about a decade ago, but I'm not really sure how to look-up the definitions of ...
0
votes
1answer
277 views

Handling a big Excel File

I am managing an Excel data file (Excel 2010) which contains more than 400,000 rows and 55 columns. It is impossible to work with a Pivot table: I get a message that Excel does not have enough ...
1
vote
0answers
726 views

Excel 2010 AddPicture functionality changed?

Me again. In Excel 2003, we're using some VBA to automate adding a picture to a worksheet. The call, in a nutshell, is: Dim Pic as Object Dim filePath as String . . . Set Pic = ...
9
votes
2answers
23k views

Excel pie chart: How to combine smaller values in a single “Other” slice?

I have this pie chart in Excel 2010 (based on a pivot table): I'd like to combine all the values smaller than X% in a single "Other" slice. In previous versions of Excel, it was possible to use the ...
0
votes
1answer
167 views

Excel 2010 - How do I record a macro and play it back for all cells in a column?

I need to make a macro. I can (barely) figure this out. This macro will perform an operation on a single cell (convert link text into a live link as in In Excel, I pasted in a bunch of URLs, but they ...
2
votes
1answer
1k views

In Excel, I pasted in a bunch of URLs, but they aren't live links — how do I bulk convert them to live links?

In Excel, I pasted in a bunch of URL's into a column. However, they aren't live links after pasting. How do I bulk convert them all to live links swiftly?
4
votes
3answers
11k views

Excel 2010 data validation warning (compatibility mode)

We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation software. The current LabVIEW software can only handle the legacy .xls format, so we're ...
2
votes
1answer
302 views

Excel 2010: How to rearrange a column into a row

I'm trying to invert columns and rows in a part of my worksheet: columns should become rows and vice-versa. How can I easily do that?
1
vote
1answer
580 views

Excel conditional formatting multiple repeating rows

I'm using Excel 2010 I have a monthly menu. menu days are listed by row with 2 menu items list for each day. Col-C Col-D Day 1 Cheesburger Hamburger Day 2 Taco Quesadilla Day 3 ...
0
votes
1answer
113 views

Creating a graph for data in Excel

I have two conditions (1-public, 2-Montessori) and a set of values based on the score of the children that is either a 0 or 1. I need a histogram showing how many children got a 0 and how many got a ...
3
votes
4answers
72k views

Keyboard shortcut to change case of text in cells in Excel 2010?

Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.
3
votes
2answers
1k views

Subscripts and superscripts in Excel

I have an XL sheet with chemical formulae - which is basically just letters with numeric subscripts and superscripts. I can save as an html page and get the <sub> and <sup> html elements, ...
2
votes
2answers
1k views

Have a column with numbers starting with a 0. (EXCEL)

I have data that I want to import in excel. It's phone numbers from multiple country. For example: David France 0145535663 Luis Spain 62333331 Mike USA 5465555112 The numbers have different length so ...
7
votes
2answers
4k views

VBA Runtime error 1004: Method 'OpenText' of object 'Workbooks' failed

After an upgrade to Excel 2010 (from 2003), a script used for standardizing data from Access import has stopped working. It returns an error: "Run-time error '1004': Method 'OpenText' of object ...
0
votes
2answers
2k views

Excel Pivot Table Manipulations

I work for a Helpdesk and I am trying to create a pivot table that shows the resolution rate of our analysts. This is the pivot table I currently have shows each analysts name on the left and the data ...
2
votes
4answers
1k views

Excel formula re-calculating unexpectedly

Someone has sent me a spreadsheet (as an email attachment) where a simple sum formula has not been recalculated, as when I open the email from Outlook, it opens in Excel 2010 in protected view and I ...
0
votes
2answers
1k views

Show online/offline status of email address in Excel from MS Communicator

I got a sheet of employees in Excel 2010 and would like to see who's online on Communicator jst by looking at the sheet and the row with employee's name. Each employee has the firm's email address in ...
7
votes
1answer
1k views

Where can I find guidelines for how to use Excel's “Data and Model” cell styles (specifically “Linked Cell”)?

(I originally asked for "well-known" guidelines, but got no answers. In light of that I think it's fine is anyone just wants to answer with their own guidelines or a link to some they like.) I have ...
4
votes
1answer
2k views

Excel 2010 Macro “Command could not be completed by using the range specified”

Running a macro on an Excel spreadsheet, I get the Run-time error: 1004 Command could not be completed by using the range specified. Selected Debug and the highlighted code is: ...
0
votes
1answer
7k views

Excel formula to find frequency of occurrence of unique words in a column

I have a spreadsheet with a column with repeating number of different kinds of words like A1 A2 A3 A1 AA A2 A7 A8 A1 Now I want to plot a graph showing the frequency of occurrences of a word. The ...
0
votes
3answers
131 views

Re-ordering data in a cell in spreadsheet

I have an Excel spreadsheet where data is time stamped, but the time stamp is as follows (in one cell): Fri Mar 11 If it was 11 Mar Fri, the data would be easier to sort. How do I change the ...
1
vote
3answers
189 views

Excel plot chart from data as given in the example

I have a huge spreadsheet with simple data as follows 13:04:28 A 13:04:37 A 13:06:56 B 13:07:03 B 13:07:10 C 13:07:18 C 13:07:23 C 13:07:28 C 13:07:33 C Basically ...
2
votes
3answers
12k views

Excel and Word document In same PDF using Word/Excel 2010?

In Word and Excel 2010, you can save Word and Excel file as PDFs natively. Can you combine a Word and Excel file into the same PDF using this PDF save functionality?
1
vote
1answer
388 views

Excel 2010: Home tab is blank

A user on our network has somehow managed to empty out their home tab in Excel. I've not had much luck finding a fix on Google. Does anyone have any ideas how to fix this? The tab cannot be ...
2
votes
1answer
4k views

How to add time duration column total from Skype Call History CSV file in Excel 2010?

How to add time duration column total from Skype Call History CSV file in Excel 2010? These are my exact steps on how to set up my Excel spreadsheet. How to import Skype Call History CVS in Excel ...
1
vote
4answers
6k views

Excel do dynamic “merge & Center” based on values or through “Conditional Formating”

is it possible to dynamically apply "merge & Center" based on values or through "Conditional Formatting"? I made it possible to add colors but I want to do more advanced thing with Excel do ...