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 excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

1
vote
1answer
2k views

autosize excel 2010 comment box when add a lot of text

I'm finding some way to make Excel comment box auto-size when I add a lot of text into it. Some tries with Google and I've got this from Ozgrid but it doesn't work on my Excel 2010. Please help me ...
6
votes
4answers
66k views

Excel extract substring from string

I am looking for a way to extract a variable length substring from a string. My cells will look something like: ABC - DEF ABCDE - DEF ABCD - ABC I want to split the string at the - character, so ...
0
votes
1answer
55 views

How to filter a cell which containing data by other list

Good day all I have a table on a worksheet with two columns (name/ID). each column has a drop downlist data. I want to filter one column by using other drop down list. for example when I choose a ...
0
votes
2answers
301 views

How to send e-mail to customers using quick campaing?

I have a question/problem. I want sent email to my clients using quick campaing. But in those emails I want to put some information for only this customer. For example: First customer - A - have a ...
2
votes
4answers
15k views

Changing data series line weights in Excel chart (many at once)

Is there a way to edit the weight of all lines at once on an Excel line chart? I have a graph with about 50 data series on it, and it's too much to go through all of them and change the weights ...
5
votes
6answers
34k views

How to toggle Scroll Lock in Excel 2010 without a Scroll Lock key in the keyboard

I have a notebook with no Scroll Lock key (or any shortcut using the 'Fn' key). Somehow Excel 2010 got the Scroll Lock on. I see it left down in the status bar and now I can't navigate through cells ...
1
vote
2answers
1k views

How to transpose multiple cells at once in Excel

I have an Excel document such as this, with many listings: Name Address City, State ZIP Name Address City, State ZIP In between each, there is a blank line. How can I convert it to something like: ...
3
votes
1answer
2k views

Excel Validation to Prevent Entry of Two Specific Characters

I'd like to place some validation against a cell in Excel that allows all characters except a "-" (hyphen) and any white space. I've attempted the following but this doesn't seem to work. ...
1
vote
2answers
87 views

How to add to cells and return the result inthe third cell in excel?

say, i have the following data A B C 3 5 4 8 5 9 6 0 7 6 8 3 9 4 How can i add two cells from each line and put the result in the cloumn C, the result should look like this.. ...
1
vote
1answer
2k views

Exel 2007-2010 - auto-insert date when add new or edit comment

I see that when I add new a comment to a cell, Excel auto insert my username into it. So I wonder whether or not we can configure the way Excel add header to my comment. Actually, I need Excel to ...
0
votes
2answers
2k views

How to assign row numbers to cells in Excel

I want to make the columns be from 1 to 195, in order from least to greatest, so that if I make a mistake (say, I want to add an entry between row 28 and 29), I want Excel to order itself from 1 to ...
3
votes
1answer
2k views

How to set 2 conditions / criterias for VLOOKUP / LOOKUP / etc in OpenOffice Calc (or Excel)

I have this spreadsheet that started as a silly aid for a game (Mafia Wars 2), but grew into a tricky spreadsheet question. In the game your character have 9 "slots" for weapons and armors, 1 for ...
-1
votes
1answer
259 views

How to turn off checking digital signature for XLL add-ins?

I need to make Excel load unsigned XLL add-ins without showing any security prompts. How can I do that?
0
votes
0answers
806 views

Excel 2007 adding mean value and variance to histogram

I have to visualize a trend and I was wondering if it is possible to show a red line over a range of data for the mean value(data range) and the variance(data range). Example: Data: a,b,c,d,... ...
0
votes
1answer
595 views

Transpose columns into rows while importing into Excel

I have a text file with many more columns in it than are allowed in Excel, so I would like to transpose the data into columns while importing it into Excel. Any ideas on how I can do this?
1
vote
1answer
1k views

Record CPU usage then create Excel line chart with “Series” Column

I need to create a line chart to display the cpu usage of each process over time. How do I create the chart with time as the X axis, %CPU as the Y axis, then use the command name to indicate which ...
0
votes
1answer
33 views

Easy Excel 2010 issue with two lists of text

I have two lists of text codes text1 text2 text3 text4 text5 etc. and another list with: text3 text2 etc. how do I select only those items from the longest/first list which are not in the ...
0
votes
1answer
969 views

CSV error on phone number

On my website I generate a CSV file from a database of users. When I view the CSV file in my browser all the information comes up as it was submitted by the users, but when I download the CSV file ...
5
votes
3answers
17k views

Find missing entries from a list of sequential numbers in a column?

I have an Excel sheet containing the results of 66000 test cases. Or, at least it should... Now, because I was running the tests asynchronously and kept stopping and starting I had the foresight to ...
2
votes
1answer
980 views

Why is Excel 2007 backwards?

I opened up Excel 2007 and this is what I see: Where the row headings are on the right and the columns are backwards... Does anyone know what is going on and how to fix it?
1
vote
2answers
4k views

Rotating SmartArt or charts in MS PowerPoint or Excel

How do I rotate (90 degrees) a SmartArt Graphic or chart in Microsoft PowerPoint or Excel? I'm trying to show rotating spheres that when lined up, provide a topic for an intro, body and conclusion ...
1
vote
0answers
2k views

Excel with Version Control - Best way to merge excel files?

What is the best way to allow multiple users to edit the same excel file and later merge the files together with conflict resolution?
-2
votes
1answer
5k views

Excel - how do I reference latest date cell in a column for a specific month?

I have a bank balance Excel sheet with: Date in column A Debit/Credit in Column B Running balance in column C On a separate sheet I want to have a 12 cells for months of the year that state what ...
0
votes
1answer
2k views

How to convert decimal years into a date (format dd-mmm-yyyy or similar) in either Excel or SPSS?

I've found a fair number of formulas online which let me convert birthdate into decimal age in years but I can't find something that converts, for instance, 1.0 into 04-Nov-2011. Any help would be ...
1
vote
2answers
584 views

Dynamic data validation in Excel

On my first sheet I have all my options: A B ============= yellow DOG Green DOG PINK DOG YELLOW CAT Pink CAT black BIRD RED BIRD On my next sheet I want: Animal ...
3
votes
2answers
10k views

Excel Name.RefersToRange: how to check if Name object refers to a range?

The Microsoft documentation says about RefersToRange: If the Name object doesn't refer to a range (for example, if it refers to a constant or a formula), this property fails. I'm trying to ...
0
votes
2answers
554 views

Microsoft Office Excel 2007 - Hyperlink Query

I am currently working on a spreadsheet where I am referencing drawings throughout the document. I have the drawings saved in the same folder as the spreadsheet. When sending the document externally ...
2
votes
3answers
669 views

How to get a de-duplicated list of row labels and their summed values in Excel 2010

I have an Excel sheet with multiple rows in this format: Column A|Column B label | value --------|-------- header (merged cells) labelA |12 labelB |5 labelC |9 header (merged cells) labelA ...
0
votes
3answers
62 views

What's Excel's minimum initial configuration?

I frequently need to re-start Excel. I would like to configure/start some parameters to launch Excel more quickly. Is this possible to do?
2
votes
1answer
30k views

How Do I Embed The Entire Excel Workbook Int a MS Word 2010 Document

In Office 2007, I could embed the entire Excel workbook into a MS Word document. The Word page would show an icon for the Excel file. It did not display any of the contents of the workbook on the ...
4
votes
1answer
227 views

Is there any way to embed tables from excel that have pull down menu

I may not be using the correct terminoloby, but, here goes. We have setup an Excel spreadsheet that is formatted into multiple 8.5 x 11 pages on one tab. The spread sheet has tables with a pull down ...
1
vote
1answer
265 views

Advanced graph in Excel

This is my data: Date Electricity Electricity2 Electricity3 Water Oil level (cm) 2011-06-30 8508 16041 7521 794 / 2011-07-10 8568 16170 7601 800 ...
0
votes
1answer
2k views

How do I create this clustered column chart in Excel?

I have a data sheet split into three tables (one for each level). Within each table, there are four columns based on the answer (positive, neutral, negative, or N/A) and then there are six rows, each ...
1
vote
4answers
23k views

Excel formula to convert per-annum interest rate to compounding daily and weekly rates

If I borrow $100,000 at an annual interest rate of 10%, then I would have been charged $10,000 at the end of one year. However, I want the interest to be calculated daily and compound. If I simply ...
1
vote
2answers
1k views

Excel 2007 vs Excel 2010: Data Validation values using Named Ranges and the INDIRECT function

I am running into a bizarre error in Excel that I am hoping someone can help me with. I have a macro-enabled workbook created in excel 2010. On the workbook are a series of radio buttons. When a ...
3
votes
2answers
5k views

Make Excel cell save formula results and not the actual formula?

I have C1 that needs to combine C2 and C3. The problem with this is that is that if I'm importing with SQL it doesn't combine C2 and C3, but instead imports nothing or the actual formula. Is there a ...
1
vote
0answers
225 views

Excel keyboard shortcuts are switched – how do I set them back to their defaults?

I have a spreadsheet created by someone else. They switched Ctrl+Home to go to the beginning of the row, and Home to the start of the worksheet. Also, I have the Tab key jumping 30 columns to the ...
0
votes
1answer
91 views

MS Works inventory formula

In MS Works I would like to count the number of times a #1 comes up in a column. In another field I would like to know the number of times a #2 is present and so on up to the # 4 appears. Can ...
0
votes
1answer
465 views

How do I plot multiple per-type line graphs in Excel?

I have a bunch of CSV data imported in Excel: tuples are Timestamp, Type, Type Count. I'd like to plot multiple per-type line graphs but Excel keeps choking on me; can anyone suggest how should I ...
0
votes
2answers
1k views

Pivoting list without totals / aggregates

Is it any easy way to create a "pivot"ed table of data to compare result data in several columns, but without actually summing/counting or doing other pivot operations? example: arrange the ...
4
votes
4answers
13k views

Conditionally format a cell if it contains formula

Is it possible to conditionally format a cell if the cell contains formula (to alert myself and other users when updating the cell)?
3
votes
3answers
66k views

How do I separate a comma-separated list into two columns in Excel?

I have a long, comma-separated list which looks like this in Excel: 401.50,0.027 402.00,0.028 402.50,0.029 403.00,0.031 403.50,0.032 404.00,0.034 404.50,0.037 Is there a simple way to ...
9
votes
3answers
3k views

How can I dismiss the floating “Auto Fill options” button in Excel 2010?

Reproduce the issue Go to Excel and type fill in the first 2 rows of a column Select both rows of the column Drag down the anchor of the selection (bottom right) 1 row down Now you will see this: ...
0
votes
1answer
15k views

How do I use an OR clause in a COUNTIFS formula?

This formula works, but it'd be simpler with an OR statement in there somewhere... ...
0
votes
1answer
564 views

Check for multiple conditions and sum values in a range

I am trying to solve a conditional-problem in excel which is very similar to this question However I need to do the following: If product code in range A1:A100 = A certain code and month in ...
10
votes
2answers
9k views

show Excel sheet tab in >=2 row

Some days I'm working with extremely large Excel files, they have to many sheet that can't be show in 1 sheet tab. (see image) So, I'm wondering that whether or not we can show Excel sheet on ...
2
votes
1answer
2k views

Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...
1
vote
3answers
2k views

Convert ZIP code to state in OpenOffice

I'm trying to move data from two of our old systems into a new system. Problem is, somewhere along the line the 'state' column of our DB was corrupted. I have a column of ZIP codes I need to ...
3
votes
4answers
39k views

What's a simple way to do sensitivity analysis in Excel?

I have an Excel model of medium complexity that I'm trying to do some sensitivity analysis on. The ideal would be to have, for each of a set of inputs, run over a range of possible values and store ...
7
votes
3answers
3k views

Excel elapsed time format

In Excel, given a number representing some amount of time (e.g. 25.5 hours), is there a way to format it so that it shows as 1d 1h 30m? Bounty question : Is there a way to add months to this format? ...