Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it "VBA". If it is about an Excel formula or worksheet function, then also tag it "worksheet-function".

learn more… | top users | synonyms (2)

6
votes
5answers
1k views

Excel Formula to Calculate Duration of Time Based on a String of Text Such As 9:00am — 12:30pm

I'm trying to develop an Excel formula that would calculate the actual time duration for a string of a time range of the following format: 1:00am – 3:00am According to this article it seems it should ...
1
vote
1answer
531 views

Excel distorting markers in scatter plot

I've run into an issue with scatter plots in Excel. For whatever reason, Excel is distorting the appearance of markers on the plot, such that markers within the same series do not look the same. For ...
3
votes
3answers
3k views

With German regional settings, how to display some cells in U.S.-currency-format e.g. $1,000.00?

My Windows 7 has regional settings set for German/Germany. This causes currency values in Excel to appear like this: 234.234,00 € However, sometimes I want currency data in a cell to appear like ...
1
vote
1answer
2k views

How do I change default excel extension in Excel 2007?

I'm getting hard drive images from someone that I am tweaking with my own software. But, The image has Office 2007. I've noticed that when I try and save an Excel document, it defaults to *.xls, not ...
3
votes
2answers
1k views

Split a string in a cell in Excel using numbers as the divider

Example cell value: President & Founder, Millennium Pain Center, 1998– present. I'd want that parsed (split) into "President & Founder, Millennium Pain Center," and in another cell, " 1998– ...
2
votes
1answer
834 views

Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string

I had a followup question to this related post - Formatting a CSV to force Excel to interpret value as a string (not date or number) I was wondering how does one escape text starting with " using ...
14
votes
2answers
25k views

How to find and replace the character “*” in Excel

I am trying to find and replace the * (star, or shift+8) character in a bunch of formulas in Excel 2007. * of course matches the ENTIRE contents of the cell, which is not what I want. How do I ...
1
vote
1answer
16k 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 ...
2
votes
1answer
17k views

How to calculate sum based on cells that have a specific text next to them?

I have a list of prices and sum them up in a cell at the right. Next to some prices I have the work "select". How do I calculate the sum of all prices which next to them have the word "select"?
0
votes
1answer
296 views

Category totals within a pivot table

Assuming I have a pivot table such as Category Year Amount A 2009 100 A 2010 150 A 2011 120 Total A: 370 B 2009 50 B 2010 60 B 2010 70 Total B: 180 C 2009 100 C 2010 180 C 2011 50 Total C: 320 Grand ...
1
vote
2answers
1k views

Excel conditional formatting of row

Can someone please tell me how to highlight multiple cells in a row based on some values in any one of a given number of cells? For example, if in Row 2 any of the cells from D2 to L2 have value "A" ...
1
vote
1answer
7k views

Excel IF and VLOOKUP function help

The exercise is to use IF() and VLOOKUP() functions to return the tax rate based on the annual income and number of people in the household. So far I've tried inputting: ...
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
2answers
570 views

How to create sub-totals in Excel using SUM()?

It's been a long time since I needed to use Excel and I need a little help with copying a formula. This is a simplified explanation of what I'm trying to do: A1:365 has daily sales figures in it. ...
2
votes
1answer
651 views

How can I view updated data cells in Excel in a shared workbook?

Is there a way to view updated data in a shared workbook without having to write a macro or closing and reopening Excel?
2
votes
1answer
2k views

Embed microsoft query in excel with multiple parameters from spreadsheet

I am trying to embed a microsoft query within an excel spreadsheet, that passes several parameters from the spreadsheet to the query. I would like the microsoft excel query function to find a few ...
1
vote
2answers
9k views

Is importing one Excel spreadsheet into another Excel spreadsheet possible?

Can I import an Excel spreadsheet into another spreadsheet (two separate files) by linking in certain cells from one to show in other cells in a different file? I'm not sure if I can do this or where ...
3
votes
2answers
472 views

Convert “Mon Aug 01 09:08:25 CDT 2011” to a usable date/time using Excel

I have a giant spreadsheet with computer names and the date stamp that they last reported into our PGP server that I need to convert to a usable date/time, so I can sort the column by the time the ...
24
votes
5answers
51k views

Formatting a comma-delimited CSV to force Excel to interpret value as a string

Searching around for a while trying to figure out how to format a CSV file in such a way to force Excel to interpret the values as a string and not try and convert them to numbers or dates. e.g... ...
1
vote
3answers
2k 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
3k 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 ...
3
votes
4answers
44k views

How to get excel row numbers to skip the header

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there some way to have it start counting from the real line one (the line after the header). ...
14
votes
1answer
35k views

How to sort an Excel spreadsheet columns by row contents?

How do I sort the columns of an Excel spreadsheet? The Sort command from the Data menu only allows me to sort rows by the value of a column. I want to sort the columns alphabetically by the contents ...
4
votes
4answers
6k views

How to increase row height in Excel by X. ie. Add vertical cell padding

I have this report and I want to increase the vertical cell padding to make it easier to read. Now, typically you could just select multiple rows and change the row height until you're satisfied. ...
0
votes
1answer
289 views

How to run macro with parameter from windows command line?

I have a need for running a Macro from the Windows command line with parameter. For example, a macro should save, in A1 cell, the value of the parameter specified. Is it possible to accomplish this?
1
vote
2answers
412 views

Excel 2010 pivot tables

On the left I have the following data from a client, and need to turn into the table on the right. The date columns are dynamic - they vary weekly and the resulting pivot table should react when date ...
1
vote
1answer
356 views

Searching for a rows that contain a value in one column in Excel

I have several columns in a spreadsheet in Excel and need to find the rows that contain the value Y in column B (CWI in example below), then print out the value of another column (e.g. Column A; Job ...
3
votes
3answers
1k views

How can I strip macros from an Excel workbook so that I can upload and edit it on SkyDrive?

I don't have any access to MS Office, but SkyDrive for personal use is proving great for my basic edits, but as soon as somebody sends me a workbook containing macros, which I don't need, I can't ...
8
votes
2answers
65k 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 ...
2
votes
1answer
2k views

Creating an Excel range out of disjoint cells

I have a spreadsheet with my investment accounts, showing for each month the deposit or withdrawals that happened that month and the end-of-month balance. I want to use the IRR function to calculate ...
1
vote
3answers
5k views

How to sort on hh:mm:ss (duration) in Excel

I have a column of data that represents duration, e.g. 33:15 - 30 minutes and 15 seconds; 1:05:00 - 1 hour and 5 minutes, etc. If I try to sort it A-Z, then 1 hour gets sorted before 30 minutes. Is ...
2
votes
1answer
551 views

How to calculate AVERAGE(POWER(A1:A2, 10)) in Excel?

I can do this creating a new column B where =POWER(A1, 10) and then I get the result with =AVERAGE(B1:B2). But how to do that without a new column?
1
vote
2answers
153 views

How to sum the other cells in a column with Excel?

In cell A1 I can't write =SUM(A:A) (Circular reference). If I write =SUM(A2:A15) when I insert A16 the result won't be affected. How to do this?
3
votes
1answer
91 views

How do I look up a value in a 2-D table in Excel?

Given a two-dimensional table with row and column headers, like this: What is the formula to return the value at the intersection of a particular row and column? For example, I want a formula that ...
2
votes
1answer
240 views

How to retrieve non-contiguous cell collections from strings in Excel?

I tried to =SUM(INDIRECT("B4,B6")) but it doesn't work. How to do that?
16
votes
16answers
132k views

How to get the current column name in Excel?

What is the function to get the current line number and the current column name for a cell in Excel?
3
votes
1answer
308 views

How to make many column formulas ignore the same lines in Excel?

I have multiple columns and at the end of each one I have a SUM and MEAN lines. Now I want to ignore some lines thus making =SUM(A1:A15) into =SUM(A1:A13;A15) if I want to ignore line 14. Doing this ...
4
votes
2answers
6k views

How to make two formulas reference the same cells in Excel?

I have one row that uses =MEAN(A1:A15), and another one that uses =SUM(A1:A15). But many times I have to alter this range to, let's say, A1:A13;A15 in both cells. I would like to alter the range in ...
2
votes
1answer
150 views

Remove duplicate results when filtering data in Excel

I'm working with Excel 2007. I have 700+ lines of information on an Excel sheet and I am using filter to filter out when the certain employees started working for a certain branch and/or team using ...
11
votes
3answers
66k views

Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row. Is there a way to format all cells having a distinct value a unique color without manually creating a conditional format ...
1
vote
1answer
57 views

How to select the whole range of array formula?

I have an array formula in worksheet; how can I select the whole range occupied by this formula?
3
votes
4answers
43k views

How do I change the default paper size to A4 in Excel 2010 (and other Office 2010 programs)?

I've looked in the usual places, page settings, and printer settings, but unless I go to Page Layout and select A4 for each new sheet, it opens as letter. I've found a few workarounds, but they all ...
1
vote
2answers
3k 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 ...
3
votes
2answers
1k views

How do you show the toolbar in Excel 2008 on Mac OS X Lion if it's hidden?

In Snow Leopard and earlier, there was a "tic-tac" control in the top right of the window, but after upgrading to Lion, it's no longer there. Any ideas?
0
votes
2answers
380 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 ...
1
vote
1answer
2k views

Plot disproportionate values in single graph with Excel

I have multiple series of data that are on different scales and I would like to graph all of them in the same line chart based on percentage, but I want to label the points with the actual values. One ...
1
vote
3answers
1k views

In Microsoft Excel, how do you determine middle and end characters in these values?

I'm not an Excel guru by any means, but one of our users has asked me to come up with a way to extract certain data from a column cells in an Excel spreadsheet. Given the following examples, how ...
6
votes
3answers
41k views

Search text in multiple Excel files

I'm using Microsoft Office 2007. How can I search inside multiple Excel files?
0
votes
0answers
2k views

Stretch an Excel table in PowerPoint over multiple slides? [duplicate]

I work in a business where most people run on PowerPoint and wouldn't know what to do with an Excel sheet if it bit them. I need to regularly update a spreadsheet and put it into PowerPoint, but it ...
2
votes
1answer
200 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 ...