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)

4
votes
4answers
75k views

Keyboard shortcut to change case of text in cells in Excel 2010?

Is there a keyboard shortcut in Excel for changing the case of selected cells (to lower or upper or whatever)? All my searches lead me only to functions to do this. But that is not what I want.
2
votes
4answers
958 views

Excel: How can I summarize by a field and then sort by it?

I have customer support case data like this: Customer Time Account_A 90 Account_A 45 Account_B 25 Account_B 90 Account_B 35 Account_C 100 Account_C 120 How would I summarize by customer ...
1
vote
4answers
3k views

Excel: struggling to use CF to highlight differences between columns in the same row

I have a list of vaules in column A and column B. I need to highlight where there is a difference between values that are in the same row. I've used a simpe formula in B1: $A1<>$B1 (format bold). ...
2
votes
3answers
6k views

Is it possible to have a custom data table visible underneath a chart in MS Excel?

I have a column chart with a single series of data to be shown on the chart. However, I also have another column of data that corresponds to the one being visualized, but instead of charting it, I ...
37
votes
2answers
8k views

Excel: how to undo in current file only?

Microsoft Excel's undo / redo feature behaves unlike any other program I know. The undo stack seems to be global across all open files, so that undoing sometimes switches to another file and undoes ...
9
votes
0answers
20k views

Why won't my Excel columns hold the cell format I enter? [on hold]

I have a spreadsheet which has data linked in from other tabs on the same spreadsheet. Each of the source tabs has a column formatted as a number with no decimal. The tab they're linked to has the ...
3
votes
1answer
2k views

Update Links message from MS-Excel

I have an MS-Excel Workbook that links to another for data. The links update when the book is opened, but I still get this message "This workbook contains one or more links that cannot be updated." ...
2
votes
1answer
283 views

Is Workbook.FileFormat available to the Excel UI (specifically when the file type can't be saved)

As a programmer I eventually located the file type of a .d extension file loaded successfully by Excel 2007 by interrogating Workbook.FileFormat via VBA, but can a normal user determine it is a DBF4 ...
2
votes
3answers
2k views

Excel notation that gives FIND the ability to look for multiple strings

So I've been working with a spreadsheet that has a list of schools names. I pull data from this spreadsheet to create a roster that limits the size of text in each cell. In order to get the school ...
0
votes
1answer
163 views

Excel vlookup help

=IF(N101<>"",ROUND(VLOOKUP($N101,$I$30:$U$39,12,FALSE)/(1-(U$96+U$98)),0),0) That is the current VLOOKUP in the spreadsheet that is returning the wrong data. I didn't write it, it was on a ...
2
votes
1answer
130 views

Fast replacement of a string in Excel

I am revamping an e-commerce site using a system that allows fast product upload via CSV files. I am using Microsoft Excel 2007. The manufacturers have supplied me with a spreadsheet containing the ...
23
votes
3answers
92k views

How do you change default delimiter in the Text Import in Excel?

I want to import a CSV file to Excel. The CSV file has comma separated data (go figure), but the delimiter in the Text Import Wizard is set to "Tab" by default. How can I change the default to "Comma" ...
0
votes
1answer
132 views

Updating multiple links in multiple workbooks

I have 3 workbooks. Call them A,B and C. B receives data from C via a link A receives data from B, including data B received from C I want to update all the links when I open A I get that a ...
0
votes
2answers
132 views

Excel 2007: Loading data from web; append, not replace

I made a web service that generates a data table that I periodically want to download into Excel. Because there is a huge amout of old data, I don't want to always generate everything - only data for ...
2
votes
2answers
1k views

Have a column with numbers starting with a 0. (EXCEL)

I have data that I want to import in excel. It's phone numbers from multiple country. For example: David France 0145535663 Luis Spain 62333331 Mike USA 5465555112 The numbers have different length so ...
7
votes
2answers
4k views

VBA Runtime error 1004: Method 'OpenText' of object 'Workbooks' failed

After an upgrade to Excel 2010 (from 2003), a script used for standardizing data from Access import has stopped working. It returns an error: "Run-time error '1004': Method 'OpenText' of object ...
4
votes
2answers
99 views

Duplicating rows

wonder if there's an easy way to duplicate rows in excel. An example would be: Before: 1 2 3 4 after: 1 1 2 2 3 3 4 4 I meet this issue way to often to cut/paste my way ...
23
votes
8answers
362k views

How to compare two columns and find differences in excel

I have two columns in Excel that I want to compare and find the differences between them. Suppose Col A has 50 numbers i.e 0511234567 Col B has 100 numbers in the same format
6
votes
2answers
23k views

Fit column width to text shortcut?

I know that I can double-click a column header with my mouse, but is there a keyboard shortcut to fit a column to the text width?
1
vote
1answer
957 views

How to to fill a single column of cells with a number that increments when it finds a cell that spans multiple columns? (Screenshot)

I'm trying to organize some data that was dumped out of a proprietary system into something I can use. In column A, I want to put a 'group by' number. It dumps this long, spanning row out that ...
0
votes
2answers
2k views

Excel Pivot Table Manipulations

I work for a Helpdesk and I am trying to create a pivot table that shows the resolution rate of our analysts. This is the pivot table I currently have shows each analysts name on the left and the data ...
2
votes
4answers
1k views

Excel formula re-calculating unexpectedly

Someone has sent me a spreadsheet (as an email attachment) where a simple sum formula has not been recalculated, as when I open the email from Outlook, it opens in Excel 2010 in protected view and I ...
3
votes
2answers
2k views

Need formula or lookup command to find the next highest date in a list in Excel 2003

I have an excel spreadsheet that uses a variety of formulas and returns the dates that certain events will happen - actually, dates that I need to do certain things. The spreadsheet is in no order ...
4
votes
5answers
3k views

delete row from Excel where column cell is empty

I have a list of hundreds of users in an Excel spreadsheet. I want to remove all of the users that don't have their email address in there spreadsheet entry. there's a column called 'email', so how ...
0
votes
1answer
477 views

Excel Gantt diagram - how do I highlight actual month?

Let's say I have a Gantt diagram in the following form: m1 m2 m3 m4 m5 m6 m7 m8 m9 a1 || a2 ||||||| a3 ||||||| a4 ||||| a5 ||||||||||||||| a6 |||||||||||||| and I want to ...
0
votes
2answers
2k views

Unable to Edit Excel documents in SharePoint using Firefox

I'm unable to edit Excel documents in SharePoint using Firefox. It tells me to switch to Internet Explorer. Is it not possible to use Firefox? Screenshots:
3
votes
1answer
255 views

How can I select the region that should be viewed in Word from an embedded spreadsheet object?

Embedding Excel worksheet objects directly into Word seems like a killer feature to me, but it would only be useful for publication if I could choose the "printable area" of the spreadsheet that gets ...
2
votes
1answer
843 views

Why are some blank cells seen as zero in Excel?

We have Excel documents that date back years. Some of the document sheets haven't been touched for over 15+ years (or to the very early versions of Excel). They've had a new sheet added each year - ...
0
votes
1answer
767 views

Exporting Excel file to csv generate twice as many lines

I am banging my head on this one. I have an Excel sheet with 994 lines, but when I export to CSV I get 1880 lines in text format! And of course, now that I am trying to recreate the original Excel ...
1
vote
3answers
4k views

Excel Data Validation on multiple tabs

I am aware of doing cell formatting on multiple Tabs in a Excel workbook by pressing Ctrl and clicking on required Tabs (i.e by grouping multiple tabs).Do we have any similar way of adding data ...
2
votes
3answers
688 views

Convertion of excel file with point data into .cxt file

How can I convert a excel file (.xls extension) with point climatic data into .cxt file which is a free format text file. My intention is to calculate evopotranspiration using ETo software. But when ...
2
votes
4answers
1k views

Extracting text from a cell in Excel

I have a long list of items in Column A that includes a code and descriptive text. I need to separate the code from the text description. <ABC,1122, A1> - This is the text description The ...
2
votes
1answer
6k views

How to conditionally highlight cells in OpenOffice Calc?

I have a big chunk of data in an OpenOffice spreadsheet. To make real information standout more, I would like cells with an absolute value over a certain threshold to be highlighted in red. Is there ...
3
votes
1answer
3k views

Create progress bar or milestone type graphs in Excel 2007

I want to display project progress in Excel 2007. Is there a way to show a progress bar like graph filled for completed percentage and empty until end date for a milestone or the whole project? It ...
3
votes
3answers
26k views

Embed an Excel spreadsheet inside a PDF?

Is it possible to include an .XLS file inside a PDF, so that the user could open/extract the spreadsheet from their PDF viewer? (Maybe in the same manner MS Word allows you to include a DDE object?) ...
7
votes
1answer
1k views

Where can I find guidelines for how to use Excel's “Data and Model” cell styles (specifically “Linked Cell”)?

(I originally asked for "well-known" guidelines, but got no answers. In light of that I think it's fine is anyone just wants to answer with their own guidelines or a link to some they like.) I have ...
32
votes
10answers
73k views

Formula for updated currency exchange rates in Excel or other spreadsheets?

What kind of spreadsheets support a formula like the following: =exchangeCurrency("USD"; "EUR"; 3000) The result should be 3000 USD exchanged into Euros. Possibly a date could be provided for a ...
1
vote
2answers
162 views

How do I nail down the result of a calculation in Excel?

I'm not quite sure of the terminology involved in this problem. What I have to do is calculate in column B some values dependent on the current contents of column A. This I do with a formula as there ...
5
votes
8answers
4k 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 ...
2
votes
3answers
3k views

Excel Pivot Table Date Range as Columns

I have the following data which I wish to pivot: Student JoinDate ReleaseDate John 01/05/2011 05/05/2011 James 02/05/2011 04/05/2011 I would like to create a pivot table which ...
1
vote
2answers
6k views

Paste to Excel from clipboard (plain text) : Can I make certain cells to be formatted “as such”

when preparing table data as text to be copied to Excel through clipboard, is it possible to have certain cells unformatted? (If possible, without changing Excel settings or doing a special paste). ...
0
votes
1answer
180 views

Minute-based stock chart in Excel?

Is there any way to make Excel stock chart show time on minute basis?
2
votes
1answer
1k views

Split Address in Excel Cell

I have an Excel column where each cell contains the contents of an address. What I'd like to do is split THE FIRST TWO words into a their own separate columns. For example: 123 South Bend Rd, Make ...
2
votes
5answers
44k views

How to group similar rows together in excel

I have a spreadsheet with about 2000 rows that I need to group together based on the contents of about 12 columns. The key here is that the rows may differ in a number of different columns, but for ...
1
vote
1answer
785 views

Spreadsheet formula to count consecutive values in a column

I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this: Y Y Y N Y N Y Y the desired result would be 2 Y Y ...
6
votes
6answers
21k 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
4answers
7k 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 ...
0
votes
1answer
456 views

Excel - league table, two teams on same points

I'm using Excel to build a league table. There are six teams, who place each other and can score up to 210 points each game. They play five times over the series, total of 1050 points to be won. As ...
5
votes
2answers
2k views

How to repair a corrupted Excel file

I'm trying to restore some files for a friend who messed up a USB stick by pulling it out of the computer too soon. By searching invisible partitions I was able to restore the files. All files are ...
1
vote
1answer
116 views

How to save Microsoft Excel Pagination on Mac?

I have a Protected Microsoft Excel Spreadsheet. Every time I open it and try to print, Excel wants to split into 8 pages. If I cancel the print and drag the dashed line to the right, then I can make ...