**0**

votes

**2**answers

81 views

### Excel cell autoformatting

I am trying to type the name "True" in a cell and it keeps turning it into a function "TRUE" and I cannot turn off the autoformatting no matter what I try. Help!

**0**

votes

**1**answer

594 views

### Mac Excel SUMIF #NA problem

A formula from a Windows based Excel sheet doesn't work on Excel for OS X:
=SUMIF(P2:P453,"<>#N/A")
The problem seems to be with the "<>#N/A" part.
How should that be written in Excel ...

**4**

votes

**2**answers

3k views

### How can I alternate grid background color in excel when a value of a single column changes?

How can I alternate grid background color in excel when a value of a single column changes?
Such as this:
I would want to do this with conditional formatting, but I can't figure out how to.

**0**

votes

**3**answers

4k views

### Move markers of line chart/ Format legend

I have a combination chart with a bar chart and 2 line graphs on secondary axis. have to exactly match the formatting in the screenshot attached ( I do not have the actual excel file. just have a ...

**1**

vote

**3**answers

9k views

### How can I merge multiple workbooks into one?

Say I have a directory with the following files:
Workbook1.xlsx (Contains Sheet1, Sheet2 and Sheet3)
Workbook2.xlsx (Contains Sheet4 and Sheet5)
Workbook3.xlsx (Contains Sheet 6)
How can I create ...

**0**

votes

**1**answer

409 views

### Embed web component (text) in excel?

All,
I want to insert some text and number from a given URL into an Excel spreadsheet. Is there a good way to do that?
More specifically, I want to incorporate some of the info in the table ...

**1**

vote

**1**answer

705 views

### Does anyone know if ExcelPackage is still in development?

I was looking for something to read excel in and I found this excel package I am wondering if it is still under development as I don't see it support excel 2010.
Thanks

**0**

votes

**1**answer

231 views

### Excel: while merging column contents using ampersand I “lose” zeros

I need to merge different columns like:
AB 0054 00000137
I do it this way
=A1&B1&C1
It works but my Zeroes get lost.
The text in my columns has been formatted in "personal" with zeroes ...

**3**

votes

**1**answer

4k views

### Excel (.xls) files not opening in Excel when launched from Explorer

I appear to have done something to Excel (2003) whereby whenever I double-click on an Excel file (.xls) in Windows Explorer, Excel launches OK, but the corresponding workbook doesn't open, and I'm ...

**3**

votes

**3**answers

5k views

### 255 Character limit on VLOOKUP

Using excel 2003, the formula:
=VLOOKUP(D1 ,A1:B135, 2)
fails if the length of D1 exceeds 255 characters (i.e. the list has some text longer then 255 characters, D1 has the same text value, and ...

**2**

votes

**1**answer

776 views

### How to filter out data between two columns?

I have data in my excel sheet in the below format
A B
1 2
2 3
3 5
4 8
5
6
7
8
9
i.e colA has values 1 through 9 and colB has 2,3,5,8. Now what I need in ...

**1**

vote

**3**answers

8k views

### Big Excel File Freezing/Running Slowly

My co-worker has a very large Excel file (over 7 MB) that suffers from the problems of (A) running slowly (B) taking forever to open/save/close and (C) freezing the computer, requiring a restart.
I ...

**3**

votes

**2**answers

634 views

### Number format for text export from Excel

Basically I am exporting a block of columns from Excel to text file.
that might look similar to this in Excel:
0 34.3 22.555 56.8970 34
Now I want that to look in the text file as:
0.000 ...

**3**

votes

**2**answers

349 views

### How can I regress a downward trending number series in Excel?

I'd like to use these data to derive an equation using Excel.
300 13
310 12.6
320 12.2
330 11.8
340 11.4
350 11
360 10.8
370 10.6
380 10.4
As x goes up, y goes down. Seems straightforward. But ...

**40**

votes

**6**answers

220k views

### How do you auto resize cells in Excel?

I have copied some data into Excel 2010. I have found that some of the cells need to be widened to allow the data to fit. How do I automatically adjust the height of the cells to fit the content?

**7**

votes

**3**answers

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

**12**

votes

**3**answers

7k views

### How to insert a date into an Excel spreadsheet?

I want to insert date and time into a cell of an Excel spreadsheet. NOW() and TODAY() don't fit my needs. These functions insert dynamic date. But I want static: if I insert the date it won't change ...

**2**

votes

**1**answer

618 views

### Key command for move cursor to next different value in column in Excel

Some Excel jockey told me how to do this once, but I've forgotten.
Basically I have a huge list sorted by a STATUS column. I'd like to press the down key and go to the next changed value in the ...

**2**

votes

**1**answer

814 views

### How to change a function/formula in a whole column where I also have empty cells

I have a column with a formula/function that has other cells as parameters. However in the column, every few rows I have a subtotal and blanks, for readability.
Now I decided to change the ...

**1**

vote

**3**answers

4k views

### Combine 3 columns into one in Excel 2011 for Mac

I am trying to manipulate a bunch of string elements I have put in columns in Excel. I then filled the preceding column with data, and then the following column as well. Now I want to delete the ...

**0**

votes

**3**answers

2k views

### Annotating Graphs From Textual Data

I have a graph that was generated from a data set that contains:
(date, value, annotation)
The annotation is a constant value [its either there or is blank] and I would like to add in the third ...

**0**

votes

**1**answer

4k views

### Excel: convert text string to date/time format

I have a column with date/time info in following format stored as text:
03.01.2011 09:55.
How can I convert it to Date/Time format?

**0**

votes

**1**answer

1k views

### “excel stopped working” message on Windows 7?

We faced serious problem with Excel 2003. A message "excel stopped working" is displayed and excel just restarts. We start it with compatibility option for Windows XP, and I turned off user account ...

**4**

votes

**2**answers

4k views

### Excel 2007 transpose/combine multiple rows into one

I have data like so:
1001NCCN 3618127
1001NCCN 208478
1001NCCN 207316
1001TEMN 409889
1001TEMN 801651
1001TEMN 273134
1001TEMN 208478
1001TEMN 207316
I need to ...

**1**

vote

**3**answers

3k views

### How to set printer specific info on all sheets in workbook

We have a 53 page workbook in excel. It is instructed to print this in greyscale and with one page per sheet of paper. The only way I have been able to accomplish this is this way:
I select the ...

**1**

vote

**4**answers

12k views

### Add more than 20 digits in Excel without an exponential sign

I want to add more than 20 digits in an Excel cell. The current format of the cell is general, and it converts the number to an exponential format. I tried with a number format and accounting, but ...

**1**

vote

**1**answer

409 views

### Format Million on Excel 2007

I would like to change the format predefined with Excel 2007 for million in the previous versoin I could do that but havent found a way to do this.
For example I have this:
1,235,000,00
and I ...

**1**

vote

**2**answers

397 views

### Get date in Excel and print as plain text in cell

Is there a way in Excel to get today's date, then convert it into plain text so it can't be changed again when you open the file at a later date?

**0**

votes

**5**answers

4k views

### Is there any virus that affects Excel contents?

Sometimes I get some errors with Excel files.
When I try to open the file excel says that it found unreadable content. and asks if I want to recover the contents of the file and blah, blah..
so do ...

**1**

vote

**1**answer

843 views

### Excel Chart not displaying X Axis

I've got a chart in a spreadsheet in Excel 2010 which is using A chart = "Stacked Column in 3-D"
I have defined the Horizontal (Category) Axis Label in the Select Data Source window and it is ...

**2**

votes

**1**answer

1k views

### Changing default width/size of the auto-filter popup in Excel 2007

In Excel 2007 autofilter, is it possible to change the default width of the popup? I'm working with spreadsheets that have rather long values in some cells and I always have to resize the box before ...

**1**

vote

**1**answer

562 views

### Fill a column with the current date when user add or change other columns

I'm trying to find a way to fill a column (let's say A) with the current date, or TODAY() function, when a user adds or changes the same row.
For instance, A1 will get filled with 2/7/11 if I add ...

**2**

votes

**2**answers

8k views

### Is there a way to automate goal seeking formulas in Excel?

I have to use the following formula:
=POWER(b,(d+1))-N*(b-1)-1
I need to find b, so every time I run this I have to select the values for d and N, and then goal seek to make b the calculated ...

**3**

votes

**2**answers

4k views

### Excel chart won't update, based on calculated cells

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values
The calculated values never change directly, but only as a result of ...

**0**

votes

**1**answer

913 views

### Excel, round down to nearest .95?

I have a request to create a cell with a formula that is 50% of another cell, rounded down to the nearest .95 (basically it's a clearance price).
How can I do that in excel?

**1**

vote

**1**answer

5k views

### Prevent Excel Chart Data Labels overlapping

I have an Excel dashboard with line charts containing data labels. Specifically, we are only using the data labels at the rightmost end of the lines, and the labels consist of the Series name and ...

**0**

votes

**1**answer

278 views

### Gather information from a web page to the desktop?

Does anyone know a way to gather a bunch of information from a web page (like Excel does) to display it right into a widget or anything easy readable on the desktop?
Example : ...

**0**

votes

**3**answers

5k views

### Dates not recognized as dates in pivot table pulling directly from SQL Server

My pivot pulls from an external data source with a date column. Excel doesn't see this column as a date and the 'Format Cells' option panel doesn't change how the dates are displayed. The cell data is ...

**2**

votes

**5**answers

2k views

### Excel not properly recalculating values

I have an Excel sheet with values in it (this sheet is generated by a custom perl script, but I don't think that's where the problem lies). In it, I have a formula:
...

**4**

votes

**1**answer

2k views

### Query Parameters Cell Reference not Saved

I have a sheet which uses a data connection to obtain data for a pivot table from an external database using a SQL query. The user can set parameters for the SQL by completing a few cells in the ...

**1**

vote

**1**answer

845 views

### Excel crashes after loading file

After loading a excel sheet excel crashes.
No special errormessage in the screen.
If the same sheet is loaded on another computer it also crashes.
Is there a program to repair this excel sheet ?

**53**

votes

**10**answers

183k views

### Convert a column into a comma separated list

I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this:
1234
123461
123151
11321
And make them into a comma-separated list in another cell ...

**0**

votes

**2**answers

5k views

### How do I find first and second differences in Excel?

Is there any way to calculate the first and second differences of a column of numbers in Excel? My spreadsheet is not enormous but sufficiently large that typing in a formula in each row is not an ...

**1**

vote

**2**answers

1k views

### Excel 2003: convert a numeric cell into time for calculations

I have some data in excel, all numeric, like:
9.00
10.35
19.10
I need to do calculations like:
I got at work at 9.00, I got out at 10:00 = I've worked 1 hour
How can I achieve this if all my ...

**0**

votes

**1**answer

880 views

### Office 2010 Trusted Locations not working after restart

In Excel 2010, on Windows XP, I am unable to open files - through the open dialog box - from a network drive. The sever has already been added to the Trusted Locations and now most security settings ...

**2**

votes

**9**answers

20k views

### Create PDF with internal hyperlinks

I have an Excel workbook with an index page containing a series of images, that are each hyperlinked to different worksheets.
Can anybody suggest how I can publish this to PDF so that the hyperlinks ...

**2**

votes

**2**answers

30k views

### Displaying a value only if another cell has a value in Excel

I'd like to display an empty box (HTML entity □ □ or any other similar box will do) in Excel in a cell if and only if another cell has a value.
I've tried =IF(ISBLANK(C8),,□), but that ...

**0**

votes

**2**answers

7k views

### Excel macro: Replace enitre cell contents; replace 1 but not 10, 11, 21 etc

I need to replace a large amount of numbers with words in an Excel spreadsheet.
Eg:
1 = hello
12 = goodbye
4 = cat
etc. I can do it with the standard search and replace, but i have a large list to ...

**0**

votes

**1**answer

2k views

### Excel error “This workbook contains Excel 4.0 macros or Excel 5.0 modules”

I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this ...

**0**

votes

**2**answers

918 views

### multiple count Pivot table in Excel

I'm trying to put togeter a pivot table from an Excel spreadsheet. The spreadsheets look similar to the following:
DeptHead, Emp, Increment
x, A, 2.5%
x, B,
y, C, ...