**6**

votes

**2**answers

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

**3**answers

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

**9**answers

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

**4**answers

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

**4**answers

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

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

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

**9**answers

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

**2**answers

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

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

**2**answers

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

**5**answers

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

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

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

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

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

**2**answers

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

**4**answers

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

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

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

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

**3**answers

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

**5**answers

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

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

**5**answers

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

**10**answers

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

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

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

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

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

**3**answers

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

**7**answers

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

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

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

**3**answers

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

**1**answer

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

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

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

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

**5**answers

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