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
12k views

Split Excel worksheet into multiple worksheets based on a column with VBA

Question is simple and may be repetitive. I have an Excel workbook which contains around 50 columns I have a criteria column for splitting this workbook into mulitple workbooks The approach is as ...
11
votes
2answers
9k views

Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?
9
votes
3answers
49k 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?
5
votes
1answer
24k views

Excel 2011 Mac auto-recover file lost

Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the previous document. Yes, he said and then got a document named ...
5
votes
5answers
19k 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
5answers
50k views

Apply Formula to a Range of Cells without Drag and Drop

Typically, in Excel, one can autofill a column by drag a cell down. However, since a lot of a lot of cells to fill up, manually dragging and scrolling the spreadsheet is time consuming. Is there a ...
4
votes
6answers
3k 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 ...
4
votes
2answers
4k 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 ...
4
votes
6answers
42k 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.
3
votes
1answer
3k views

possible to have two Y axes and two X axes on same chart

Is it possible to have a chart with left Y axis right Y axis top X axis bottom X axis all on same chart?
3
votes
2answers
398 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 ...
3
votes
2answers
4k views

Format restrictions for cell in Excel

I want a cell to only have a specified format, e.g. "01-02-03", meaning "double digit dash double digit dash double digit". I a user tries to enter something into the cell, an error should occurr ...
3
votes
1answer
23k 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 ...
3
votes
3answers
13k views

How to sum numbers in a range that only have a particular cell color [Excel]?

I would like to put a formula in Excel that would sum all the numbers of a specific range that have a specific cell background color.
2
votes
2answers
601 views

How can I combine two lists into one long list?

I have two lists in coloumns 1 and 2. I need coloumn 3 to be of the format one dash two. For example: Column C will need to repeat all values of A and B. I would prefer a formula for this is ...
2
votes
2answers
24k 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 ...
2
votes
3answers
9k 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
11k 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 ...
2
votes
2answers
7k 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 ...
1
vote
1answer
1k views

Excel: I need a formula that will count months between two dates. If it's 1-15 it should be a half month. Any ideas?

So I am trying to find a formula for excel. Bascically I have two dates and I need to know the number of months between them. But to add complexity, I need a rule in there that if the earlier date is ...
1
vote
5answers
32k 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 ...
1
vote
1answer
5k views

customize excel 2010 highlight track changes

Is there any way to customize how Excel highlights cells on Track Changes? My customer requested us to "highlight anything you've changed by changing text color to red," and I'd like to implement ...
1
vote
1answer
2k views

COUNTIF Duplicate Detection

I have created a formula (excel 2003) to output a "1" if duplicates are found in a column. =IF(COUNTIF(A$2:A$10750,A2)>1,"1","") For some reason this formula does not mark the last duplicate in the ...
1
vote
4answers
1k views

Looking up a value, depending on which set of dates another date falls between

and apologies if this is a duplicate - if you could point me in the direction of any existing answers, that would be great. I have a set of date ranges in Excel, each of which has some kind of ...
0
votes
3answers
99 views

Excel Formula average without blank cells

I have a row of values and want to find the average of the first 3, not counting blank cells. Example: A B C D E F G 12 blank 8 blank 7 9 4 The average of the first 3 ...
0
votes
2answers
58 views

how do I sum a column with times that are related to another colums

I have a sheet with names, that appear up to 20-30 times in the column. Every name has in another column a time related, meaning workhours. The times are in the format hh:mm:ss (e.g. 01:15:00). I want ...
0
votes
2answers
5k views

How to automatically update values referenced from one sheet to another in excel

Here is my problem. I have 2 to 3 worksheets, and I need to make a master worksheet. The 2-3 worksheets contain the sales made in the day and the customer name. The problem is that new customers come ...
0
votes
2answers
38 views

Referencing text from one cell into an equation in Excel

I have text in a cell (A1) that is also the name of a worksheet within my workbook. How do I go about referencing a specific cell on that sheet? I want it to look like the formula below without having ...
0
votes
2answers
8k views

List values based on criteria

I have a table on a worksheet called "DealSetup" that looks like this simplified version: A B 1 John Doe 1 2 Jane Doe 1 3 Mark Doe 2 4 Doug Doe 1 5 Mary Doe 2 I ...
0
votes
2answers
46k 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 ...
0
votes
2answers
4k views

How to make a dropdown list such that… (see details)

I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already. I want to create a line graph in Excel. One line is fixed and ...
0
votes
4answers
564 views

Sharing Excel sheet over network?

Is it possible to have a server PC running a Microsoft Excel sheet to which several Thin Clients, with Barcode Scanners, will be connected via TCP/IP? The scanners should dump their data in the Excel ...
0
votes
2answers
2k views

How to convert column data into rows, grouped by identifier

I have data as shown below in two columns and I need to arrange them horizontally in a row for each individual. Baker 17 Baker 37 Baker ...
26
votes
12answers
111k views

Excel displays ### for long text - what's wrong?

We've got an excel sheet with a pretty long text in one cell. Instead of line breaks (as set in the cell format), we get a long line of ####s. We can go back and forth by deleting and adding chars at ...
16
votes
3answers
54k views

Turn off scientific notation in Excel

I would like to prevent Excel behavior that any large number I enter is stored as a number, then abbreviated to scientific notation. Is it possible to tell Excel 2007 to stop doing this?
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 ...
7
votes
3answers
25k views

How to set the default page layout from RTL to LTR in Excel 2010?

Whenever I open an Excel spreadsheet, it is displayed in a right-to-left layout by default (i.e the right most column is A and I need to scroll to the left to reach further columns). I can change ...
6
votes
4answers
15k views

How to insert empty rows in Excel 2013 when I have copied rows in my clipboard?

This seems like something which should be painfully simple to do but I can't figure it out. So with an empty clipboard I can right click on a row header and say insert row, no problem, it inserts a ...
6
votes
2answers
6k views

How to change the delimiter when you copy from Excel and paste to notepad

I would like to copy cells from Excel, and paste it to notepad with comma as delimiter, in stead of tab(which it is). Is there any way to do this without doing a replace in Notepad or saving the ...
6
votes
2answers
24k views

How to disable the annoying compatibility warnings in Excel?

Every time I edit a CVS or 2003-2007 Excel file it gives a warning that it will be saved in compatibility mode. I have this habit of saving every other minute via Ctrl+S and the window keeps popping ...
6
votes
6answers
18k views

How can I make Excel documents open in different windows?

Office 2007, Windows Server 2008 x64. How can I make Excel so that when I double-click a document, it opens in a new Excel instance, so that I can easily view them side-by-side as separate windows ...
5
votes
4answers
14k 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 ...
5
votes
2answers
3k views

How to keep part of a spreadsheet always visible during navigation

I want to apologize in advance for asking something that's clearly available on the web. Unfortunately, I don't know the appropriate terminology though. I'm looking to keep certain rows/columns ...
4
votes
2answers
4k 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 ...
4
votes
1answer
21k 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?
4
votes
5answers
16k views

Cell colors change when copy&paste in Excel 2010

We have a 3rd party tool that creates an Excel file (xls, 97/2003 format) and formats some cells in different colours. When I copy a range of cells into a newly created file (xlsx, 2007/2010 format) ...
4
votes
1answer
3k views

Excel Chart X Axis Values

I'm trying to create a line chart in Excel with the following values from my sheet: (0,100) (1,90) (2,80) (4,70) (8,60) (16,50) The problem I can't work around is that I want the 0, 1, 2, 4, 8, 16 ...
3
votes
3answers
104 views

How to correctly sort calendar months “mmm” with AutoFilter?

I need to use filter to sort calendar months in mmm format. Data > Sort > Custom will do it but I cannot make filter work. Months are in a column eg SEP, APR, JAN, APR, etc. Filter just does ...
3
votes
1answer
27k 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 ...
3
votes
3answers
185 views

Strange behavior of left arrow key in Excel 2010

When I press the left arrow to return to column A - it will not stop at column A but will continue to wrap around to the end (column XEP or something huge like that). How do I make it stop when it ...