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
4answers
24k 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
93 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
2answers
3k 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
1answer
2k views

Date based sum in Excel / Google Docs spreadsheets

I have a bunch of rows with a date and a dollar amount (expenses). I want to produce a list of the days of the month and what the balance of the expenses is. So, for example the 5th entry in the ...
6
votes
2answers
555 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
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
183 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
555 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
182 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
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
16k 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
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
5answers
879 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
3answers
35k 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
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
261 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
905 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
7answers
12k 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
281 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
12k 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
50k 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
42k 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
3answers
8k views

Use a Trendline Formula to Get Values for Any Given X with Excel

Is there an easy way to apply the trend line formula from a chart to any given X value in Excel? For example, I want to get the Y value for a given X = $2,006.00. I've already taken the formula and ...
5
votes
6answers
9k views

How do I get Excel to import a CSV file with commas in some of the content fields?

How do I get Excel to import my CSV file? File I have a file claiming to be CSV. It contains 10 fields, all of which are surrounded by double quotes (yes, even the dates and numbers.) 2 or 3 of ...
5
votes
1answer
413 views

What should I do if I see a reference in Excel cell formulas to a sheet that I cannot see in the workbook?

Similar to 'Reference Data' in the publicly accessible file described below. There is the Capacity Planning Guide spreadsheet excel file on Capacity Planning Considerations for Windows Azure Caching, ...
5
votes
4answers
8k 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
1answer
3k views

Shortcut to accept suggested formula in Excel

I'm working with a lot of formulas in Excel 2007 and I would like to know what shortcut key you need to press to accept the suggested formula. When I type in =DEG the first suggested formula is ...
5
votes
2answers
12k views

How can I make Excel fetch data from a database automatically when I open the spreadsheet?

I want to have an excel spreadsheet, that when it opens will automatically populate from a SQL database, using specific queries. Each Workbook would use a different query (or multiple queries). ...
5
votes
6answers
8k views

How to move selection in Excel?

I know how to create or extend selections, i.e., via F8 or Shift F8. When I have created the desired selection, I would like to move that particular selection a few cells to the right and/or down. I ...
5
votes
3answers
68k views

how to add an average line to the graph in excel 2007 or 2010

In OpenOffice I'm getting trend-line and average-line properties by RightClick. But in Excel 2007 I see only trend-line. Same with Excel 2010. How do you make an average-line in Excel?
5
votes
2answers
7k views

What's the difference between a Table and a Named Range in Excel 2007?

Can someone explain the difference between Excel Tables and Named Ranges in Excel 2007? It seems that in addition to having the features of Named Ranges, they're somehow marked as Tables which gives ...
5
votes
2answers
12k views

Pasting text into Excel without splitting on spaces (or other delimiter)

I recently used the Text to Columns feature in Excel to split a column of data into multiple columns based on the space character. Now when I paste text into Excel it automatically splits it into ...