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)

2
votes
3answers
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
1answer
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
2answers
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
1answer
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
2answers
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
7answers
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
2answers
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
1answer
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
3answers
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
1answer
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
1answer
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
2answers
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
5answers
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
1answer
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
5answers
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
7answers
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
2answers
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
1answer
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
1answer
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
4answers
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
5answers
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
3answers
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
2answers
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
4answers
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
3answers
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
4answers
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
1answer
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
4answers
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
2answers
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
6answers
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
10answers
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
3answers
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
1answer
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
5answers
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
2answers
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
6answers
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
2answers
7k views

Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?
0
votes
4answers
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
1answer
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
4answers
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
1answer
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
1answer
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
5answers
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
2answers
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
1answer
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 ...