**6**

votes

**4**answers

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

**6**answers

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

**2**answers

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

**2**answers

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

**4**answers

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

**1**answer

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

**2**answers

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

**3**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**4**answers

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

**8**answers

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

**5**answers

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

**3**answers

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

**3**answers

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

**3**answers

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

**3**answers

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

**3**answers

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

**5**answers

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

**4**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**4**answers

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

**3**answers

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

**7**answers

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

**5**answers

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

**3**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**3**answers

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

**4**answers

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

**7**answers

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

**5**answers

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

**3**answers

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

**5**answers

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

**3**answers

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

**6**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**2**answers

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

**6**answers

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

**3**answers

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

**2**answers

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

**2**answers

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 ...