The 2003 version of Microsoft's spreadsheet application.

**2**

votes

**2**answers

601 views

### Rearranging a 15 X 25 Excel matrix into three columns

In Excel I have data in cells from A1 to O5 (15 X 25).
I wish to rearrange things such that I have the following
[A1][B1][C1]
[D1][E1][F1]
[G1][H1][I1]
[J1][K1][L1]
...

**0**

votes

**2**answers

236 views

### Microsoft Excel file versions

We have a user here who uses Word 2003 and Excel 2003 as his primary tools. He needs to keep different versions of his files over the time so he can rollback to a previous version at any time. ...

**1**

vote

**1**answer

81 views

### Microsoft Excel 2003 formulas

I am trying to make a formula most of it works this is what I have so far =100%-(D62/C62) this part is great, but if D62=0 I want it to stay 0. How do I add to this formula to work?

**1**

vote

**1**answer

2k views

### How to use multiple criteria with COUNTIF?

INPUT:
This is the format of the OUTPUT desired:
OUTPUT for example INPUT:
The problem is, I don't know how to use COUNTIF with several criteria.
The "dream function" [that doesn't work] ...

**0**

votes

**2**answers

238 views

### Conditional Formatting Non Contiguous Ranges

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting
Cell Value is equal to =G7, colour ...

**0**

votes

**2**answers

254 views

### Template is working for Excel2003 but not for Excel2007

I created an Excel worksheet (Book.xlt) under
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
with my own setting.
That settings are occurring only for Excel2003(.xls) ...

**0**

votes

**1**answer

421 views

### Disply zero value in cell in excel

Is there any other way to display zero value in excel without using ' before zero.
with zero before ' then it show zero in excel

**2**

votes

**7**answers

16k views

### Adding more than 15 digits in Excel

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

**0**

votes

**2**answers

384 views

### Properties of cell editor in excel

How to make excel cell editor property as text by default in excel.
Actually cell property is general.How can i make that as text in excel
(Right click on excel cell editor
click on format cell
...

**5**

votes

**4**answers

57k views

### How to open ods files in Excel?

What is the best way to open ods files in Excel 2003?
Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)?
The file I ...

**1**

vote

**1**answer

826 views

### How to dynamically link a spreadsheet to another

I have two spreadsheets in the same workbook. Users are entering data in a table of the Sheet1 and I would like to duplicate that same table in the Sheet2 dynamically. In other words, I don't want to ...

**1**

vote

**2**answers

3k views

### Link two excel workbook located in different computers

I have two excel workbook
The first one located in one computer (i.e. "\192.168.7.1\Shared\book1.xls")
The second one in another computer (i.e. "\192.168.7.2\Shared\book2.xls")
With both spreadsheet ...

**0**

votes

**2**answers

1k views

### Remove duplicate rows in excel when not all the columns are the same

How can I automatically remove duplicate rows in Excel when data->filter doesn't work, because the columns aren't all the same?
I believe the picture explains what I need, but I can probably supply a ...

**1**

vote

**2**answers

375 views

### How could I get the text defining an Excel formula for one cell into another cell?

In other words, if the value of a cell, say A1, is =Date(), then displayed in cell A1 I will see the date, but then I want B1 to be =FuncText(A1), then I want to see 'Date()' displayed in cell B1.
To ...

**6**

votes

**2**answers

22k views

### Merge two excel files using a common column

I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg.
The first excel, the 2nd excel
1 t 1 tes1
2 5 3 ...

**0**

votes

**1**answer

112 views

### How to chart different shifts run times in Excel 2003

I have the following as an example.
Date Duration Shift
4-Dec 60 1
4-Dec 40 2
5-Dec 45 1
5-Dec 55 2
5-Dec 30 3
I am trying to map these ...

**0**

votes

**1**answer

503 views

### Why is Edit->Links disabled when I open my sheet?

I want to use the function to see what other spreadsheets a particular file, says MySS.xls, is linking to. But somehow the 'Link...' is disabled.
I have unprotected MySS.xls.
Why is it so? How can ...

**0**

votes

**1**answer

38 views

### Double-Click URL to Follow in Microsoft Excel 2003?

I want to automatically follow a hyperlinked cell when double-clicked, not single-clicked.
Can I configure this?

**0**

votes

**1**answer

710 views

### Download direct image links in Excel 2003

I have a list of about 6,000 direct links to images in an excel sheet, and I need to download them all automatically onto my computer into a directory keeping the same file names. How do I do this?

**2**

votes

**1**answer

1k views

### Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...

**4**

votes

**5**answers

12k views

### How to avoid double quotes when saving Excel file as Unicode?

I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text".
When I save the Excel file in Unicode format, the text which contains the double ...

**2**

votes

**1**answer

93 views

### In Excel, how do I highlight all rows that do not contain “,2”?

I'm verifying the FormatCurrency function is written properly in ASP code and I put everything in Excel from "find results".
I want to highlight only the ones that do not contain ",2" in them.
...

**0**

votes

**2**answers

51 views

### copy worksheet to several workbook

I created a worksheet/spreadsheet with functions and references to cells in other worksheets/spreadsheets within same workbook to create a report of other worksheets within the same workbook.
I have ...

**1**

vote

**1**answer

792 views

### Can the Selected Excel Custom View be determined

I know I can show a custom view in excel with vba. What I need to do is determine which custom view was selected by a user, to alter a column header based upon that selection.
They are using this to ...

**1**

vote

**1**answer

53 views

### Take two characters from a cell

In Cell A1 I have a date format: 22-12-2011 (dd-mm-yyy).
Now in A2 I want to have only the dd of A1.
So I want to have 22. How can I do this?

**2**

votes

**1**answer

1k views

### How to create a XY (scatter) chart with three columns of data?

I have the following data:
Date Name Value
1/1/2011 FOO 10
1/1/2011 BAR 12
2/1/2011 FOO 16
3/1/2011 BAR 21
5/1/2011 FOO ...

**0**

votes

**0**answers

767 views

### Recover data from corrupt excel file

a friend has a corrupt excel file. When you attempt to open it in excel it says "File format is not valid". None of the tricks here work.
The file is Excel 2003 format. She sometimes edits it on ...

**0**

votes

**2**answers

141 views

### Excel Multiple Conditions Summing

I have Column A to A1600. In that column I have two project names "CP" and "GFI", in column B I have Project Phase 1-8, in column C I have the hours worked in each phase. The projects intertwine so ...

**1**

vote

**1**answer

321 views

### How to calculate the total sum of hours with automatic filter

I have an Excel sheet where I sum hours to get the total amount of my work.
It works without problems, but if I add an automatic filter I'd like the calculations to be done only on the portion of ...

**2**

votes

**1**answer

574 views

### Is there a keyboard shortcut to circularly switch sheets in Excel?

In this question, he was asking about keyboard shortcut to switch tabs. But this shortcut moves the sheet backward or forward, which means that pressing Ctrl+PageUp on the last sheet doesn't move the ...

**5**

votes

**2**answers

5k views

### How do I force a user to use a specific format when entering time data?

I need to ensure the users of a particular spreadsheet are entering the time data in military time. I'm finding some folks are omitting the colon, and it's causing problems. Is there a way to force ...

**2**

votes

**2**answers

19k views

### How to get excel row numbers to skip the header

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there some way to have it start counting from the real line one (the line after the header). ...

**0**

votes

**2**answers

2k views

### Converting a formula from MS Excel 2010 to MS Excel 2003?

In Excel 2010 the forulma I am using is:
=_xlfn.IFERROR(INDEX(K$76:K$2044,MATCH(Q23,P$76:P$2044,0),1),INDEX(K$76:K$2044,MATCH(Q23,L$76:L$2044,0),1))
But I need to convert it to excel 2003. I have ...

**1**

vote

**1**answer

217 views

### How to create a Pivot Graph that only looks at the Day in Month instead of Full Date?

I have an Excel spreadsheet that is defined the same way as in this question.
01/10/2010 0.99
02/10/2010 1.49
02/10/2010 0.99
02/10/2010 0.99
02/10/2010 0.99
03/10/2010 1.49
03/10/2010 1.49
...

**1**

vote

**2**answers

1k views

### Excel 2003: Disable Drag and Drop on all sheets without VBA

Is there any way to disable drag and drop of cells on all sheets without a script. I know you can do it globally, there is a setting in the Excel program that disables it locally on your machine. ...

**1**

vote

**2**answers

1k views

### Excel 2003 opening files on network

The network is laid out with an XP Pro computer as the server hosting files, then 3 XP computers connecting to it for filesharing, all on it's own router. One computer can open .xls files no problem, ...

**0**

votes

**2**answers

815 views

### Excel files with passwords not responsive from network drive

I have a couple decent sized excel files (one 18,442 KB, another 11,088 KB) that have passwords. Yesterday I could open them without problems. Today I found my computer had restarted itself after a ...

**4**

votes

**3**answers

10k views

### Excel 2010 data validation warning (compatibility mode)

We have some legacy worksheets that were created in Excel 2003, which are used by LabVIEW-based test automation software. The current LabVIEW software can only handle the legacy .xls format, so we're ...

**1**

vote

**1**answer

448 views

### How to disable Flash games in Excel 2003?

Some students in my college computer lab are playing Flash games that have been embedded in Excel 2003 spreadsheets. How can I disable Flash being used in this way in Excel 2003?

**0**

votes

**1**answer

236 views

### How do I sort two columns against one in Excel 2003?

I need to produce a method of moving the B and C columns to match up with A so:
with a macro or formula it should produce:
Column 1(A) should be unchanged but 2(B) and 3(C) moved; 2 and 3 will ...

**29**

votes

**2**answers

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

**3**

votes

**1**answer

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

**2**

votes

**3**answers

2k 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

**3**answers

817 views

### How do I use a linked cell in Excel in a formula?

I am trying to create a formula using a cell that holds data linked from another tab in the same spreadsheet. When the source cell is blank, the linked cell shows "0". Is there a way to have the ...

**2**

votes

**1**answer

798 views

### Random Excel bug when referencing a different sheet

I am getting a very strange error anytime I try to use a formula pointing to a cell in a different sheet from the active one (even as simple as "=Sheet2!A1"). This started happening all of a sudden, ...

**1**

vote

**1**answer

1k views

### Drag-and-drop a new series onto an Excel chart

In Excel 2003, I can select a new data series and drag it onto an existing chart to add it to that chart. In Excel 2007 I can't. Does anyone know if this functionality was removed or if it is ...

**2**

votes

**1**answer

166 views

### Make dates appear on the X-axis and the color category appear on the Y-axis

There is probably a fairly straight forward answer out there but I can not seem to find a solution online.
I have a table marked up like this (column names are in bold)
audit date | blindness
...

**0**

votes

**1**answer

556 views

### VBA xlColumnDataType in Excel 2003

When importing a txt file into excel, I need to specify data types for the columns.
I'm currently using Excel 2003 (upgrade to 2010 is for later in the summer).
I have been able to find enumerations ...

**0**

votes

**1**answer

1k views

### In Excel VBA Macro does ActiveWindow.Scroll change ActiveCell at all

I'm cleaning up and extending some excel VBA macros (written and currently running in Excel 2003), and I have a question about how far I can go in cleaning up without modifying the output.
There are ...

**3**

votes

**1**answer

2k views

### Excel 2003: open spreadsheet and run macro from command line

The need: run a macro within an excel 2003 file every week, automatically, than save the file.
The approach: add an action to task manager for every week, calling the file with command line ...