**1**

vote

**1**answer

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

**4**answers

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

**1**answer

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

**2**answers

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

**4**answers

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

**6**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**4**answers

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

**2**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**4**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**4**answers

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

**3**answers

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? ...