A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

8
votes
2answers
12k views

Open a .csv file in Excel and have it update whenever .csv file changes

Hi I'm working with some web scrapping and the data on my csv files will be constantly changing. I want to open these files on Excel to view and also have it refresh whenever the csv source changes ...
8
votes
3answers
19k views

Why is Excel truncating my 16-digit numbers?

If I type in a 16 digit number (format: number, no decimals) it changes the number on me. Example: 1234567812345678 changes the view to 1234567812345670. If I type it in as a general format it ...
8
votes
7answers
21k views

How do you keep Microsoft Excel running at full speed even when it does not have the window focus?

I've noticed that when Excel 2007 (and probably earlier versions) has the window focus, Excel runs at full speed which means that files open fast and long-running VBA macros execute quickly. If the ...
7
votes
4answers
29k views

Specifying delimiter for Excel 2007 export

I'm trying to save an Excel 2007 file as a pipe-delimited text file but in the Save As list, I see only tab-delimited and csv options. How do I go about specifying the delimiter, which as I recall ...
7
votes
1answer
2k views

What is the “sep=” metadata you can add to CSVs?

While trying to find out how to get CSVs to open correctly in Excel on a Spanish PC (belonging to a customer) I found many answers recommending using sep=, at the top of the file: Easiest way to ...
6
votes
11answers
62k views

How to prevent cells from printing in Excel

How can I prevent the contents of specific cells (or entire row or column) from printing in Excel, while keeping them visible on the screen when I'm editing the file? Ideally I should be able to do ...
5
votes
1answer
18k views

How to make a Pie radar chart

I want to create a circular chart in Excel with 8 sectors like in this example: Instead of representing the percentage like in a pie chart, I want the actual value like in a radar chart. Is it ...
4
votes
6answers
6k views

Is there an efficient way to copy text from a PDF without the line breaks?

I need to get thousands of snippets of text from PDFs to a spreadsheet. They are short, seldom more than 2-3 rows, but each line break creates a new cell, and I have to repair that manually, which ...
3
votes
3answers
11k views

Excel: how to permanently apply conditional formatting to the whole spreadsheet?

I have the following annoying problem with Excel 2010. I use Conditional formatting to apply bold formatting to each line of the spreadsheet that meets a condition expressed by a formula. In the "...
3
votes
3answers
28k views

How do you update an Excel file (Data Refresh and update formulas) WITHOUT opening the file?

I have an Excel file that want to update and save automatically with out having to open it or manually interact with. Manually, I open the file up and hit data refresh which goes and does a SQL query ...
3
votes
2answers
25k views

How do I merge two Excel columns into one?

Let's say we have two columns/ranges A1:A10 (group A) and B5:B50 (group B) and we need to merge the two into one column in C1:C60 (60 in C = 10 from A + 50 from B) Data in group A & group B can ...
13
votes
2answers
68k views

Excel: How to convert “string” to a “number”?

I have a user with a query from an SQL Database that returns a series of string in this form: 000123123.23000 000123123.23000 000123123.23000 000123123.23000 000123123.23000 These are really ...
13
votes
3answers
12k views

How to insert a date into an Excel spreadsheet?

I want to insert date and time into a cell of an Excel spreadsheet. NOW() and TODAY() don't fit my needs. These functions insert dynamic date. But I want static: if I insert the date it won't change ...
12
votes
2answers
16k views

Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?
9
votes
10answers
101k views

Autonumbering a column in Excel

In my first column, I want to autonumber it from 1, 2, 3, 4, ..., x. How do I do that?
8
votes
1answer
42k views

Conditional formatting of TRUE / FALSE values in an Excel 2010 range

I have a range containing formulas that evaluate to TRUE or FALSE. How would one apply conditional formatting to this range, so that TRUE cells are Green, and FALSE cells are RED?
7
votes
3answers
6k views

How do I prevent Excel from locking files by default?

When I double-click on a CSV file on a network share, the file is opened in Microsoft Excel (which is what I want). However, Excel assumes that I'm going to modify the file, and that everyone else is ...
7
votes
2answers
11k views

How to conditionally create a hyperlink based on value of a cell

ColA Col B ColC Project A A.pdf A.pdf Project B No Link I have a list of project records. One column (e.g., B) ...
7
votes
4answers
29k views

Why is Excel removing leading leading zeros when displaying CSV data?

I have a CSV text file with the following content: "Col1","Col2" "01",A "2",B "10", C When I open it up with Excel, it displays as shown here: Note that Cell 2A attempts to display "01" as a ...
6
votes
1answer
7k views

Why does Office 2010 fail to open an Excel file?

I have a excel file I've put on a file server. When required i access it via a dll, fill it with some data in background only (through ExecuteExcel functionality). It used to work before. Recently I ...
5
votes
4answers
38k views

How to avoid double quotes when saving Excel file as Unicode?

I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text". When I save the Excel file to a text file in Unicode format, the text which ...
5
votes
12answers
49k views

How to stop Excel Treating US dates as UK dates?

I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
4
votes
2answers
18k views

Split Excel table over multiple PowerPoint slides

I have a table in Excel which is too long for one PowerPoint slide. So I would like to split it over 2 or 3 slides, but have the header on each of the slides. What is the easiest way to accomplish ...
4
votes
6answers
65k views

Excel VBA “Unselect” wanted

I would like the final appearance after my VBA has finished running to be empty of selection -- to have no cell or range on any sheet colored (if it was range selected) or in a bold line box (anything ...
3
votes
2answers
13k views

Fill down in Excel, but based on multiple values

I have spreadsheets (not created by me) that have blank entries in one column where they should really have data. I want to take every empty cell and fill it with the nearest value above it. I'm ...
3
votes
1answer
12k views

Why does cutting a cell in Excel not work properly?

I am having a problem with cut & paste, and copy & paste. I lose the formatting when I paste. Also, the cut does not cut but just works as "copy". And when I select the cell and do cut or copy,...
3
votes
4answers
18k views

Excel text alignment with custom formatting

Is there anything in a custom formatted formula which defines the text alignment? I know the different parts of the formula is numbers, negative numbers and so on, but I need to set the alignment. ...
2
votes
1answer
10k views

Remove password from Excel files in batch

I am going to get batches of 200+ Excel files with a blank password, one just needs to press enter when asked for the password. The system I am loading these files into cannot handle password ...
0
votes
2answers
77k views

How do you write an Excel formula that will paste a specific value in a different cell?

So basically I want to write a formula that will check a condition, and if that condition is met, then I want to paste a specific line of text in a different cell. I should note that I do not want the ...
13
votes
6answers
50k views

Excel: How do I reference an entire row except for a couple of cells?

I want to be able to sum together the values of an entire row except for the first 2 cells. So something like this: =sum(A3:A*infinity*) How do I do this?
12
votes
3answers
13k 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 ...
12
votes
5answers
117k views

Excel: If statement with #N/A

I have over 6000 records and half of them are formulas that are missing a variable so they result in #N/A on the spreadsheet, what i want to do is if the cell is #N/A then leave the cell blank, ...
10
votes
3answers
76k views

convert text string to date/time format

I have a column that is text formatted like 20110408_2041. How can I format it to date/time format?
10
votes
5answers
71k 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 ...
8
votes
5answers
27k views

Why does this Excel file keep asking to save?

A client sent me some Excel .xlsx documents, and every time I open one of them and then close it, Excel asks if I would like to save changes, even if I didn't make any. This doesn't happen with any ...
7
votes
1answer
84k views

Change cell color based on other cell value

I have encountered numerous questions related to changing a cell color based on its value, which can be achieve easily with Excel "Conditional Formatting". However I'm interested in changing a cell ...
7
votes
1answer
63k views

How can I hide 0-value data labels in an Excel Chart?

I would like to hide data labels on a chart that have 0 as a value, in an efficient way. I know this can be done manually by clicking on every single label but this is tedious when dealing with big ...
7
votes
1answer
37k views

Excel 2010: Can I hide columns without excluding the data from a graph?

In Excel 2010, is it possible to hide columns but still have the values show up in a graph? I have a graph of monthly data going back to 2005, with each month's data in a column. If I hide the ...
7
votes
2answers
49k views

How to disable Excel number autoformat

This problem is simple to correct but is very very annoying what I'm doing is to type a hour range, eg. (0-1),(1-2),(2-3) so on per cell row DATE --- HOUR 1/1/2013 0-1 1/1/2013 1-2 1/1/...
7
votes
10answers
38k views

Changing bounds of excel file embedded in powerpoint

When I embed an excel files into powerpoint, I'm having two issues. On some of the spreadsheets, empty columns are displayed on the right hand side of the powerpoint slide On other spreadsheets that ...
6
votes
4answers
100k views

Excel chart: How to reverse the X axis of time series data

In Excel 2003, I have a time series from a financial report that goes something like this: 2007 2006 2005 Amount 300 200 100 I want to create a graph of the time series that looks ...
5
votes
6answers
50k views

How to get the Excel header on each print page to be the first row of the table

I need the first row in an Excel spreadsheet to print as the header on all pages.
4
votes
2answers
197 views

How to Export — not Save As — to another format?

How can I Export a sheet or table or selection to another file format without changing the currently active document ? Our primary data operation environment is in Excel, where extensive use of ...
4
votes
1answer
16k views

Disable autoformat in Excel 2010

I have already disabled autoformatting from the autocorrect menu of the proofing tab in Excel options. For whatever reason I keep experiencing this formatting change even after explicitly setting the ...
4
votes
3answers
7k views

Extract data from delinked Excel plot

I have a Word file which has some Excel plots in it. Unfortunately I lost the original excel plots and the word file is now 'de-linked'. Is there a way to retrieve the lost data for the plots? Just ...
4
votes
2answers
552 views

Drawing sample points versus time in Excel

I have a set of data as follow: As you can see the first column has either R or P, the second column is a measured value, and third one is obviously time. I need to present this in a chart (I ...
4
votes
2answers
5k views

Counting occurences of a character in an excel spreadsheet

Feel silly asking this question, but I need some help! I want to count how many * appear in a range of 5 cells. The cells will range from 0-7 * each. I was thinking of using the =COUNTIF(A2:A:6,"*...
4
votes
6answers
47k views

Missing Paste special options in Excel 2010

I have a weird problem with the Excel. Every time I copy and paste only the text is copying and the format is not copying as shown in the below figure. There are no paste special options available ...
3
votes
2answers
83 views

Combine multiple rows to one (many-many relationship)

Could anyone help me write an Excel formula to do the following? I am trying to merge product codes for a customer from a flat file extract. Each customer can have multiple products, and vice ...
3
votes
2answers
36k views

Conditionally format cells based on match in another sheet

I have an Excel spreadsheet with 2 worksheets. The first is just a header row and a single column of item names. The second is a list of item groups, with a header row and a title in the left most ...