**2**

votes

**3**answers

4k views

### Custom format positive and negative in Excel

I have a number format in Excel that rounds the display of numbers like 3,105,245 to $3.1M and 34,235 to $34K.
[>=1000000]$0.0,,"M";[>=1000]$0,"K";0
This works great except when the number is ...

**1**

vote

**1**answer

350 views

### Import exponetial fixed width format data into Excel

I've received a bunch of text data files consiting of Lots of records (>30K/file) of 3 fields each of 5-place numbers in exponential format: s0.nnnnnEsee (where s is +/-, n is a digit and ee is the ...

**6**

votes

**2**answers

584 views

### How to tell Excel not to hide selection when it becomes inactive?

Excel has an annoying habit of making the current selection invisible when it becomes inactive - including the "focused cell" rectangle. When I try to process a spreadsheet in a certain way I may put ...

**2**

votes

**1**answer

2k views

### How do I change the maximum number of ticks on a graph in Excel 2007

I have a lab report due tomorrow and I am supposed to plot a data set given to me by the professor. The biology laboratory guidelines tell me to have no more than 5 tick marks on the graphs vertical ...

**1**

vote

**2**answers

993 views

### Excel transpose via paste

I want to transpose data in Excel. Normally, I cut the cells I need, and use paste special -> transpose. However, sometimes when I do paste special, a box comes up asking me if I want to use unicode ...

**5**

votes

**7**answers

34k views

### How to print multiple Excel sheets into a single PDF file?

I am trying to print multiple sheets from the same Excel workbook into ONE PDF file. But it frequently prints them separately or only the first sheet.
I selected all the sheets and made them have the ...

**2**

votes

**2**answers

7k views

### Excel graph plotting for large data set with dates

I have a large table of data (not created by me) with more than 1500 rows. The first column of which is a list of dates, monthly, starting from 1870. Some of the columns contain data for the full rage ...

**2**

votes

**1**answer

3k views

### Highlighting search results in Excel

Is it possible to have Excel highlight search results, or specific text that you're looking for? I really appreciate these features as they are in Firefox and IntelliJ IDEA.

**2**

votes

**3**answers

2k views

### Microsoft Excel – How to link or copy cells to a different worksheet on every nth row

Microsoft Excel – How to link or copy cells to a different worksheet on every nth row.
I have an interesting problem. It is probably simple, but I can’t figure it out.
I have a list of cells (about ...

**0**

votes

**1**answer

2k views

### Excel: Cell Value as Excel Document Metadata Property

I know you can add custom Document Properties in Excel 2007.
see: http://office.microsoft.com/en-us/excel/HA100475241033.aspx#5
But I thought there was a way to pull a value from a cell as a custom ...

**1**

vote

**1**answer

2k views

### Excel: highlight groupings of data differently based on a cell's value

Consider a sheet with a bunch of values grouped together. The goal is to have Excel shade the entire row's background color differently for each differing group of Requisition.
The color is not ...

**2**

votes

**2**answers

2k views

### Excel to CSV comma delimited

When I try to save a long list in Excel as a CSV comma delimited it works for the first 17 rows and then stops. Why and how I can fix it?
It puts commas after the data in the first 17 rows and then ...

**3**

votes

**5**answers

32k views

### Excel: copy cell formatting in equation

If I make an equation:
' on cell A2
=A1
Is there a way to make A2 have the exact same formatting as A1 and not just the value?
EDIT:
i.e. I want a FORMULA that copies both the value and the ...

**6**

votes

**1**answer

3k views

### break up a large CSV file

I have a large CSV file (about 6,000 rows) that I want to break up into smaller CSV files (about 100 rows each). Is there an easy way to do that?

**3**

votes

**5**answers

338 views

### Any good 'how to…' resources out there? [closed]

Does any one have any good resources - websites or books, when it comes to creating (mastering) simple to complicated graphs or charts?
I've reached the point where I need to do more than tables. ...

**4**

votes

**7**answers

3k views

### Free way to perform a text search in PDF and Excel files

Is there a free way to perform a text search in PDF and XLS (Excel spreadsheet) files?
I want to be able to find a specific word in these type of files.
Is there a free tool for that?

**4**

votes

**2**answers

15k views

### How do you include an OR inside a SUMPRODUCT function, in Microsoft Excel?

How do you include an OR inside the sumproduct function in Excel? I currently use two sumproduct formulas because I have two variables I want it to count:
...

**2**

votes

**1**answer

37 views

### Moving contacts

How do I move a large contact list on my pc to my new Mac address book? I moved the excel file to my iMac, but have trouble moving the info to my address book.

**1**

vote

**1**answer

14k views

### Combining multiple Excel 2007 tables into one PivotTable

I have two tables, in separate Excel worksheets in the same file, which I'd like to combine. Is this possible?
The tables look like so:
Project | Subproject | Hours
PAlpha | SPOne | 5
PAlpha ...

**0**

votes

**4**answers

6k views

### My pivot chart has the wrong Y axis values but correct data point values

I created a pivot chart based on some raw data for the x axis (dates) and 4 calculated fields for the Y values.
The values on resulting lines are correct (see the data label at the end of the line) ...

**3**

votes

**5**answers

2k views

### Excel performance improvement

I have an 8 CPU 3GHz Windows machine that is estimated to finish a calculation using Excel in 16 days based on a sample data test. This performance is not acceptable(!).
The calculation does not use ...

**2**

votes

**3**answers

22k views

### Protecting the formatting in Excel 2007

I'm creating a number of forms in Excel 2007 for other people to use. They will be accessing the digital versions, and I'm afraid that they'll eventually accidentally break the formatting I've ...

**1**

vote

**2**answers

949 views

### Pivot table - calculations across totals

I have a Pivot table in Excel, where I have two fields in the totals area (say, I calculate the Countof both A and B).
Is it possible to do calculations on these totals instead of just displaying ...

**4**

votes

**4**answers

6k views

### How to create diagram in spreadsheet with dates on x-axis?

I recently became a father to twin boys. Naturally there is a lot of weighing and measuring, and we record these numbers in a spreadsheet. I use OpenOffice.org Calc (but I'm open to solutions for ...

**2**

votes

**3**answers

99 views

### How to create PDF documents from my MS excel files?

How to create PDF documents from my MS excel files? Hi guys, I need to create PDF documents from my MS excel files. How do I do it?
Anyone know how to convert word doc to pdf? Someone has given me a ...

**1**

vote

**4**answers

1k views

### calculate time differences in excel 2003

I have a goal of 2h47m00s minutes per month. If I attend let's say 1h20m00s and when my Excel cell format is:
[Red]-[m]:ss;[Blue][m]:ss
...then it gives me in red color 87 minutes time difference ...

**8**

votes

**1**answer

1k views

### Where is data validation text stored in Excel?

I have an Excel 2003 sheet with lots of different data validation rules.
Is there anyway that they can be viewed other than through the regular data validation dialog?
It would be helpful to export ...

**3**

votes

**4**answers

10k views

### Excel chart, how to make a formula produce gaps?

I have a chart in Excel 2007 that is basically just a line graph.
Some cells that make up the series data cannot produce a value through their formula, and I'd like the chart to place a gap in that ...

**0**

votes

**2**answers

2k views

### Excel duplicates the changes from one sheet to all sheets in xls

I have an xls file with 5 sheets in it. If I write ="something" in B2 in sheet1 all sheets 2-5 also is changed in B2.
This happened after several problems with 2003 vs. 2007 versions of office. Now ...

**14**

votes

**6**answers

21k views

### Freeze row and columns in Excel (and the same time)

How can I lock both column and rows and the same time using the 'freeze panes' in Excel ? I can manage to freeze either columns or rows but not both. I can do a similar thing with "split panes", ...

**5**

votes

**10**answers

13k views

### Can you convert an address to a zip code in a spreadsheet?

Given a column of street addresses with city and state but no zip in a spreadsheet, I'd like to put a formula in a second column that yields the ZIP code. Do you know a way to do this?
I'm dealing ...

**5**

votes

**3**answers

4k views

### Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore.
Using Excel ...

**1**

vote

**1**answer

713 views

### Compare between Excel worksheets

All my product's SKU and prices are in an Excel document in different columns (Sheet1). In the same spreadsheet, but on another worksheet (Sheet2), I have distributor data with product SKU and prices. ...

**6**

votes

**5**answers

37k views

### How to get time difference as minutes in Excel?

I have time values in two cells in an Excel sheet and I need the difference of
the times in minutes.
The cells in the Excel are like below:
A B C
1 6:38 8:23 1:45:00
A is ...

**1**

vote

**2**answers

331 views

### How to open Excel with a certain number style?

how to open Excel,
and that the cell's styling will be Number with no numbers after the dot (.)
for example: the number 1234567890 will show 1234567890 not 1.23E+09
thank's in advance

**1**

vote

**6**answers

118k views

### Adding a zero before values in an Excel spreadsheet column?

While trying to fill in social security numbers into Excel 2007, my dad found out that he couldn't make the numbers start with a zero (0).
Example: 0123456789 is turned into 123456789
What do I need ...

**0**

votes

**1**answer

715 views

### Excel: Fetch values from downloaded xml and insert into table?

How do I force Excel to download http://api.eve-central.com/api/evemon, parse it and format the values in a table every time the .xlsx file is opened?
I tried importing the XML and it worked, but I ...

**0**

votes

**2**answers

3k views

### Is there a way to reload an excel file

I'm trying to parse some logs in a file. The program that add logs runs in the background. I want to look at the file at a given moment and then after a few minutes to reload it and look again.
Is ...

**0**

votes

**2**answers

292 views

### Excel doesn't calculate anymore

I don't have a clue what happened. Excel stopt calculating.
The only thing i did was applying a filter, which is not active anymore.
This is an example
value R76 = 200
value H76 = =R76*1,06
...

**0**

votes

**1**answer

732 views

### Excel similar or comparison between two sheets and color row

I would like to compare two sheets (sheet1 and sheet2), and color a compleet row in sheet2 when for example 1 or more the same numbers are found in sheet1,
I came this far but then everything gets ...

**0**

votes

**1**answer

1k views

### Excel pivot table calculated field total returns unexpected value [closed]

Can someone please tell me what I'm doing wrong? I have created a pivot table based on the following data for each month over a six-month period: Month, Impressions, Clics, Joins, Acceptation Rate.
I ...

**9**

votes

**2**answers

7k views

### Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?

**0**

votes

**4**answers

8k views

### Set automatic axis limits for bar chart without defaulting to zero

I am building a bar chart in Excel with data values ranging from, e.g., 10 to 20. I want the x-axis limits to be automatic, but although the right limit (near 20) works correctly, the left limit ...

**1**

vote

**1**answer

234 views

### excel autonumber 1.a , 1.b, 1.c

in an excel sheet.
we generally give serial number as 1 , 2 , 3
if i want to give subparts to 1
i am thinking of giving 1.a, 1.b, 1.c
normally for the case of 1, 2, 3, - i would pull down using the ...

**1**

vote

**4**answers

3k views

### CSV to Excel sheet again

I have a problem.
I know it's possible to make from a excel sheet a csv file delimited by comma's. But is there a way to transfer it back to a normal excel sheet with having back the same table ...

**2**

votes

**1**answer

18k views

### Excel Dashboard Templates [closed]

Are there any nice sites for neat and free Excel dashboard templates? The following one is a great example:

**1**

vote

**1**answer

110 views

### Is there an Excel add-in that allows me to create a survey and send it directly from Excel?

Is there an Excel add-in that allows me to create a survey and send it directly from Excel?

**2**

votes

**5**answers

5k views

### In a spreadsheet (Excel, Google Docs, OpenOffice), how do I transpose data from rows to columns, but only non-null cells?

I work with all three spreadsheet programs listed above, and I believe my question can be answered the same or similarly for all three.
On my sheet, I have a top row full of column headers. The ...

**1**

vote

**2**answers

548 views

### ms-excel: bubble trouble - creating amazing looking charts [duplicate]

Possible Duplicate:
MS Excel: Bubble trouble - creating amazing looking charts
i am reading this article:
http://www.juiceanalytics.com/writing/bubble-trouble/
i would like to make a ...

**0**

votes

**1**answer

231 views

### How do I format each cell in column FOO in Excel if the len() of the cell value is longer then BAR?

If this is the wrong place to ask this let me know.
Here is the formula I have right now:
=LEN($A$2)>$AB$11
Applies to:
=$A$2
That works great for the one cell. I need it to apply to each ...