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)

0
votes
2answers
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
1answer
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
2answers
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
3answers
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
3answers
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
1answer
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
3answers
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
2answers
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
2answers
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
6answers
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
3answers
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
3answers
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
1answer
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
1answer
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
3answers
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
3answers
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
1answer
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
1answer
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
2answers
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
3answers
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
4answers
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
1answer
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
2answers
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
5answers
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
1answer
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
3answers
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
5answers
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
1answer
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
1answer
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
10answers
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
2answers
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
2answers
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
1answer
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
9answers
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
2answers
30k views

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

I'd like to display an empty box (HTML entity &#9633 □ 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
2answers
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
1answer
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
2answers
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, ...