**4**

votes

**4**answers

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

**4**answers

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

**4**answers

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

**3**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**8**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**4**answers

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

**2**answers

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

**5**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**3**answers

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

**4**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**10**answers

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

**2**answers

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

**8**answers

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

**3**answers

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

**2**answers

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

**1**answer

180 views

### Minute-based stock chart in Excel?

Is there any way to make Excel stock chart show time on minute basis?

**2**

votes

**1**answer

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

**5**answers

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

**1**answer

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

**6**answers

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

**4**answers

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

**1**answer

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

**2**answers

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

**1**answer

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