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
2answers
472 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
1answer
10k 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 ...
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
26k 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
4k 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
2answers
56 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
39k 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
4answers
535 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 ...
0
votes
3answers
2k views

custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...
24
votes
11answers
102k 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 ...
14
votes
3answers
44k 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?
11
votes
8answers
14k views

Excel hyperlink not redirecting properly (bug?)

I have an Excel hyperlink problem: I click on, let's say A1, copy the link in it (http://www.godaddy.com/domains/searchresults.aspx?ci=54814), right click on hyperlink and copy that SAME URL as the ...
9
votes
2answers
8k 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 ...
6
votes
4answers
14k 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
3answers
23k 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
2answers
23k 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 ...
5
votes
4answers
12k 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
2k 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 ...
5
votes
6answers
16k 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 ...
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
54 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
3answers
172 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 ...
3
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 ...
3
votes
1answer
4k views

Show Excel column filter information in cells

We have a sheet with a huge number of columns and filtering is often used to navigate to the correct data. The problem is that sometimes its not obvious that the filter has been applied , the visual ...
3
votes
1answer
253 views

Paginate Rows into Columns in Excel

How would I 'paginate' every X row into a new column? ORIGINAL LIST Col A ----- 1 2 3 4 5 6 7 8 9 10 Is there a way to break after every third item? Turning the list into this: PAGINATED LIST Col ...
3
votes
1answer
2k views

Excel conditional formatting to highlight entire row if one date is not equal to another date in that row

I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...
3
votes
1answer
18k 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?
3
votes
2answers
14k views

Excel cells - show text different to the actual value?

Is it possible in Excel to have a cell show text that is different from its value? I would like to have a a cell that has the value 1,2,3 ... or 7 but it will show day of the week as text - but when ...
3
votes
1answer
18k views

How do you force the focus of an Excel Cell to remain the same?

I have set up an excel table where occasionally the data I have in several columns gets shifted down several rows to make room for new data. I also have a cell that references the top most cell in ...
3
votes
2answers
5k views

How to utilize multiple monitors with Microsoft Project 2010 (or other Office 2010 products)?

My question does primarily concern Project 2010, though it would be applicable to other Office products such as Excel, which can tend to span several horizontal screens. Seems like an obvious ...
3
votes
6answers
23k views

Entering Time data in excel in mm:ss format (without the leading 0: for the hours)

I want to enter time data into excel sheet in mm:ss format. The problem is - that although the cell format is mm:ss, if I enter the data like this: 12:33 the actual value stored is 12 hours and 33 ...
3
votes
2answers
7k views

Saving a tab separated file in Excel without quotes

I have a tab separated value file that I want to edit in Excel. When Excel saves the file it modifies any column with quotes. It puts quotes around the whole column, and then double any quotes within ...
3
votes
3answers
3k views

Excel trendline accuracy

This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get. An example: r L (mm) 30,00 97,0 60,00 103,2 ...
2
votes
6answers
2k 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 ...
2
votes
1answer
2k views

How do I filter on bold, struck through or italic text in Excel 2007?

Is it possible to filter an Excel column based on the format of the text, such as whether it's bold, italic or struck through?
2
votes
2answers
2k views

VBA Excel 2007 help to speed up code to hide rows [closed]

I am trying to write a VBA code that automatically hides rows if a value in the row is equal to "". My range of values is A37:A400. Because my range is so big my previous VbA is to slow and looks one ...
2
votes
1answer
243 views

how to determine which values in a given set of cells will add up to a numerical range

In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers: 1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16 26 ...
2
votes
2answers
939 views

Excel - Sum values if their row meets more than one criteria

I have a spreadsheet of my bank account transaction history in this format: | A | B | C | D 1 | Date | Amount | Balance | Category 2 | 2013-03-10 | $ -10.59 | ...
2
votes
3answers
16k views

Excel ran out of resources while attempting to calculate one or more formulas

I received the error message "Excel ran out of resources while attempting to calculate one or more formulas" on ONE of my computers (Out of 2). My worksheet contains: (Inside a single worksheet, not ...
2
votes
3answers
18k views

Count unique names in excel column range

I have an excel spread sheet that contains a list of server names in column B. The server names appear multiple times in this column. I would like to count the number of unique server names in a ...
2
votes
1answer
8k views

Compare 2 text cells and show difference in the third cell

If cell A1 = abcd, cell B1 = abcdefg, then what formula to use in order to get the text difference efg?
2
votes
1answer
2k views

Using Excel Linest function with blank cells

I need LINEST function to be applied with blank cells to get the slope parameter as well as the associated standard error. I can get the slope parameter with a normal function that may resolve the ...
2
votes
3answers
8k views

Ctrl + Shift + Arrow stopped working

When I work with a big amount of data, I introduce formulas in Excel by using the shortcut: Ctrl+Shift+arrow. That shortcut allows me to select a whole set of data to the left, right, up or down. ...
2
votes
6answers
31k 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 ...
2
votes
8answers
21k views

Excel freezes when copying / cutting to paste elsewhere

When cutting/copying some cells to paste them into another sheet/page, sometimes Excel freezes/locks up and fades out. At the top toolbar it says in brackets "not responding". Eventually, I must ...
2
votes
2answers
8k views

Export to CSV From Excel

I frequently use Excel to prepare data to load into a table. I create a CSV file from it and use that file for data loading. I generally find myself creating the CSV file multiple times. My current ...
2
votes
1answer
3k views

Excel count coloured cells

If i have 500 cells filled with red, 500 filled with green and 50 filled with yellow, is it possible to do a countif sorta formula where i will have a cell which will count the number of red cells, ...