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)

6
votes
2answers
11k views

How can I determine which version of Excel was used to create a .xls file?

Does anyone know of a way to determine which version of Excel was used to create a file? We have some .xls files and need to determine the version. They open fine in Excel 2007 and higher, but a ...
6
votes
3answers
23k views

How to refresh data in shared Excel 2010 workbook

I have a Excel 2010 workbook that is shared by other users who periodically update various cells. Is there a shortcut key, like F5 with most web browsers, that updates the document with any changes ...
6
votes
9answers
15k views

When does Excel decide to overflow text into adjacent cells, or cut them at the boundary?

In Excel, 2010 or any other version probably, if I enter in a cell, a long single-line text that is longer than the width of the cell, Excel sometimes render the text across the next adjacent cells; ...
6
votes
4answers
15k views

Click to select row to end of data in Excel?

In Excel, you can select an entire row by clicking its number at the left edge of the window. But doing so selects the entire row all the way to infinity. If you apply a fill color to a row selected ...
6
votes
4answers
25k views

Microsoft Excel returns the error 'Document not saved' after generating a 2GB temporary file

Summary Saving an Excel workbook sometimes runs very slowly; A huge temp file is created; You get a 'Document not saved' error; Your current Excel session cannot save the file, no matter what you ...
6
votes
6answers
24k views

When embedding an Excel chart on a PowerPoint slide, why does the text look awful?

I have a recurring problem with Excel 2003/PowerPoint 2003, where I have a nice-looking chart in Excel and try to embed it on a PowerPoint slide. Quite often, the text in the chart (labels, axis ...
6
votes
2answers
94 views

How do I stop excel from turning numbers and dates to # in short columns

Question I have an excel document that is being used for reports. For readability I currently have all the columns fairly narrow and am using cell overflow a lot visually. I want excel to recognize ...
6
votes
9answers
11k views

Why is Excel 2010/2013 taking 10 seconds open any file?

I have a fast Windows 7 PC with two SSDs and 16GB of RAM, so I'm used to programs loading very fast. But recently, for no reason I can figure out, Excel has started taking way too long to open Excel ...
6
votes
2answers
4k 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
4answers
6k views

Excel insists on formatting HTML

I need to copy around 15,000 rows of data from an MS SQL query to an Excel 2007 spreadsheet. Some of the cells contain HTML as plain text, and most of these include HTML tables. I want the HTML to ...
6
votes
2answers
565 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 ...
6
votes
5answers
2k views

Excel 2013: “We couldn't free up space on the clipboard. Another program might be using it right now”

Excel 2013 often complains that "We couldn't free up space on the clipboard. Another program might be using it right now" when I'm trying to copy cells. Some say it might be caused by Zone Alarm or ...
6
votes
3answers
1k views

Where is the PivotViewer collections excel addin gone and many other resources?

I am trying to get something working with the Silverlight PivotViewer control, and I am having a hard time getting any of the referenced resources (on the web). Most of the links are broken or gone. ...
6
votes
1answer
194 views

Excel spreadsheet undoes/reverts to previously saved state

A very unusual problem haunts my colleague From time to time when she works with Excel 2010 (numerous workbooks, some of them quite large), the computer "decides" to undo everything that was done ...
6
votes
0answers
8k views

How can I force Excel 2007 on Windows 7 to always open another instance of the application? [duplicate]

I want to be able to compare to large spreadsheets side by side... Since you can not natively expand to all monitors I would like to have the two documents open in two instances. These files are ...
5
votes
2answers
638 views

How to tell Excel not to evaluate a formula?

Is it possible to tell Excel not to evaluate a cell as a formula? Example cell entry: -A23 Excel wants to evaluate this as reference to a cell. But the data I am working with has another semantics ...
5
votes
2answers
186 views

How to remove ** from my cells

I have an Excel file having keys and values. The values contain **. How can I remove these asterisks when for them Find and Replace does not work? I am using Excel 2010.
5
votes
4answers
17k views

Is there a function in excel to find the max absolute value of a range?

I'm looking for a function in Excel that looks something like = MAX(ABS(A1:A10)) Except ABS() doesn't take a range of numbers. The best that I can come up with is: = ...
5
votes
2answers
1k views

Inserting static current time in Excel

I have a time log spreadsheet. I have a new sheet for each day. In each sheet, I have a transactional record of how my time was spent. When I start or end a task, I usually type in the time ("11:00 ...
5
votes
4answers
483 views

How can I record a transition from a 0 to 1 in a column in Excel?

I need to record the number of transitions from a down state (0) to up state (1) in a single column in excel and I am wondering whether there is some kind of logic like this available in Excel or ...
5
votes
8answers
3k views

Excel spreadsheet bogged down, Is there an alternative software?

I work for an organization with a yearly budget that is an Excel spreadsheet consisting of about 25 large sheets that are linked to one another. There is a big summary sheet that draws it's numbers ...
5
votes
3answers
38k 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, ...
5
votes
5answers
888 views

Does any spreadsheet allow you to create your own functions?

I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ...
5
votes
3answers
7k 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 ...
5
votes
5answers
10k views

How to tell if an Excel cell has a formula or is hardcoded?

Does anyone have a special tip (non-VBA strongly preferred) to tell systematically if a cell has a hardcoded value or is a derived formula? Am dealing with some data that has messy subtotals embedded ...
5
votes
10answers
12k 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
9k views

Excel formula to convert boolean values into {0, 1}

What is the Excel formula to convert boolean values {FALSE, TRUE} into {0, 1}? Supposing there is one shorter than =IF(cond,1,0).
5
votes
3answers
3k views

Converting decimal number of hours into time

I need to convert number of hours, such as 156.90 to 156:54 in excel 2003. All of the conversions I found did this incorrectly. The number of hours shouldn't be changed, only the decimal.
5
votes
3answers
4k views

How does one insert a newline character into a cell of an Excel spreadsheet?

How does one insert a newline character into a cell of an Excel spreadsheet? Up until now I have been copying and pasting the newline from a spreadsheet that already has one. I am using Office 2003 ...
5
votes
5answers
9k views

How to return everything between two characters in Excel?

I'm a programmer with lots of languages, but somehow I've never learned Excel macro or formula language. I'm sure there must be a simple way to do this, but I'm stumped. I have a column of file names ...
5
votes
4answers
10k views

Make Excel 2003 Open Spreadsheets in new instances

In Excel 2003, It seems to be putting each spreadsheet I open into the existing Excel application as a new window. this makes it very difficult in a dual monitor set up to put one spreadsheet on each ...
5
votes
3answers
30k views

How to group by date in excel?

I have a sheet in Excel 2007 that looks like this: Date/Time Device Model 29-Sep-2009 06:50:42 PM 9000 29-Sep-2009 06:02:16 PM 8900 29-Sep-2009 05:40:10 PM 8330 29-Sep-2009 ...
5
votes
3answers
11k views

Check if Excel cell text is numeric using formula only

I have to find out if my cells text is a numeric value and wanted to use an elegant non VBA method that doesn't impede on its current state or value. What I've found is that the ISNUMBER() function ...
5
votes
1answer
273 views

Excel formula needed

I'm not so good in excel but i "think" my problem can be solved using excel.. I've got a column with numbers and i'd like to find the best combination of using these numbers. In our case the best ...
5
votes
4answers
7k views

How to create a random string of random length from the alphabet?

I want to create a random string with random length from the alphabet in Excel. For example, "jlskdjf", "kjlk", "kljsodif", etc. How can I do that?
5
votes
3answers
920 views

Preserving Greek letters on my PC

How would convert this long table of vocabulary (one column of greek then one of english) in this document into one excel spreadsheet where the Greek characters are preserved? Whenever I try to ...
5
votes
3answers
30k views

Making line charts so the line goes through all data points

I've got data based on over 50+ years for various products. Not all products have data for each year, so the line is not always shown from point to point - Excel bug or is there a work around? I've ...
5
votes
7answers
13k 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 ...
5
votes
5answers
13k views

Excel Cell Length Limit

Excel is refusing to open some of the files I programmaticaly create. I think what is happening is that it pukes because a particular column has very long strings (up to 1850 chars), but for the ...
5
votes
3answers
7k views

How to get file extension in MS Excel?

I have a column containing file paths. I want to make another column which contain the extensions of the paths only. How can I do this in Microsoft Excel?
5
votes
1answer
292 views

Is there a useful difference between ISBLANK and =“”?

In Excel, the ISBLANK function seems to effectively behave the same as a comparator of ="". However, the former requires more than double the amount of characters that the latter does. Is there any ...
5
votes
3answers
13k views

Find missing entries from a list of sequential numbers in a column?

I have an Excel sheet containing the results of 66000 test cases. Or, at least it should... Now, because I was running the tests asynchronously and kept stopping and starting I had the foresight to ...
5
votes
1answer
51k views

How does one add an axis label in Microsoft Office Excel 2010?

As the title says: How does one add an axis label in Microsoft Office Excel 2010?
5
votes
3answers
8k views

Excel: Custom number formatting

I don't know much about the rules on custom number formatting in Excel, and I need to learn more. When I open the related window (Format Cells > Numbers > Custom), there are some predefined ...
5
votes
4answers
24k views

How to calculate hours and minutes between two time periods?

I’m working on a very simple time sheet for my work in Excel 2007, but I have run into trouble about calculate the hours and minutes between two time periods. I have a field: timestart which could be ...
5
votes
7answers
43k views

Map one column to x axis second to y axis in excel chart

I'm getting my ass kicked trying to plot simple data into a simple chart in excel (2010 beta). My data is a very simple one: Value Year ----- ---- 1 1900 5 1902 3 1912 ...
5
votes
5answers
1k views

Should I use MS Excel or MS Access? [closed]

I want to store my students' information such as marks, etc. And I need a way to make calculations on this information. I also want the application to make it easy to fill students' information (in ...
5
votes
3answers
1k views

Can I reactivate the cursor keys for modifying a cell reference in a formula?

When I enter an Excel formula by hand avoiding the mouse, I can conveniently reference cells by using the arrow keys (->,<- etc.). For example, I can enter the formula =A2&B2 in cell C2 by ...
5
votes
5answers
20k views

How to export selected columns into csv file

I want to export specific number of columns from excel into .csv file. I have around 10 columns like lname, fname, phone, address, email and so on. what should i do to export certain columns like ...
5
votes
5answers
16k views

Using excel, how can I count the number of cells in a column containing the text “true” or “false”?

I have a spreadsheet that has a column of cells where each cell contains a single word. I would like to count the occurrences of some words. I can use the COUNTIF function for most words, but if the ...