The 2003 version of Microsoft's spreadsheet application.

**7**

votes

**2**answers

94 views

### Migrating from VBA Excel 2003

I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so...
Whats the best way to implement a gui over a excel vba program (office ...

**2**

votes

**5**answers

322 views

### troublesome microsoft excel 2003

Hi I have a problem with my excel .. I want to paste one bunch of rows to another excel document and I can't do it with simple copy/paste ..
I can copy then paste to notepad then
copy again and ...

**4**

votes

**2**answers

8k views

### How to copy a single cell into multiple worksheets in Excel?

I have about 30 worksheets, and I need to put my name on the top left corner (cell A1). Is there an easy way to do this without having to write it or paste it into every worksheet?

**1**

vote

**1**answer

286 views

### How to prevent Excel from corrupting certain data when copy-pasting from Word to Excel?

I need to copy & paste a large table (54 pages of data) from Word to Excel.
Works great except when some of the cells contain ranges (1-10, etc), Excel insists on interpreting them as dates and ...

**2**

votes

**1**answer

1k views

### How to retain background colors when pasting between documents in Excel

I have a script that programatically generates excel spreadsheets - cleaning up ugly reports that are given to us from another organisation. For interests sake; I'm using PHPExcel to generate the ...

**0**

votes

**1**answer

198 views

### Default print margins on Excel 2003

How can I set the default print margins on Excel 2003? I have to do it on a localized (Italian) Execl version.

**2**

votes

**2**answers

477 views

### Excel 2003 Alphabetic Sort Order Is Not My Idea of Alphabetic

I have an Excel 2003 spreadsheet that I'm sorting on the first column, which is formatted as Text. The sort order is strange. Here's a "sorted" example. I've highlighted the anomaly.
120-BDXX
...

**2**

votes

**3**answers

3k views

### How to add URL in a cell comment using VBA?

I am using Microsoft Excel 2003 wherein i have a cell which has a comment. The comment has text as well as URL. Is it possible to create a hyperlink (URL) in comment box where user can click and it ...

**1**

vote

**1**answer

89 views

### How to make sure that the text in TextBox in an excel is found when searched using CNTRL+F?

i have made a flow chart diagram in an excel sheet using TextBox tool from drawing toolbar.
i've made entries into the text boxes.(No other data is present in the cells of the worksheet)
But now ...

**12**

votes

**5**answers

45k views

### Export an Excel spreadsheet to fixed-width text file?

Excel has the functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns.
Does it also have ...

**0**

votes

**1**answer

1k views

### calculate positive and negative times in excel 2003 (new) [duplicate]

Possible Duplicate:
calculate time differences in excel 2003
i have a goal of 2h47m00s minutes per month. if i attend let say 1h20m00s and when my excel cell format is ...

**1**

vote

**4**answers

1k views

### calculate time differences in excel 2003

I have a goal of 2h47m00s minutes per month. If I attend let's say 1h20m00s and when my Excel cell format is:
[Red]-[m]:ss;[Blue][m]:ss
...then it gives me in red color 87 minutes time difference ...

**0**

votes

**2**answers

1k views

### Opening an Excel document outside of browser with IIS 6

I have links to various Excel documents on an intranet site. I want these documents to open in Excel and not within the browser but i cannot figure out how to accomplish this.
In IIS 5 i could do ...

**6**

votes

**5**answers

29k views

### How to get time difference as minutes in Excel?

I have time values in two cells in an Excel sheet and I need the difference of
the times in minutes.
The cells in the Excel are like below:
A B C
1 6:38 8:23 1:45:00
A is ...

**0**

votes

**5**answers

604 views

### Calculate the sum of numbers in column G of MS Excel sheet

When I calculate the sum of numbers in the column G of a Microsoft Excel spreadsheet by using the formula =SUM(G1,G31) ,column G32 prints the date (0-Jan-00).
Is there any way in which the sum of ...

**2**

votes

**5**answers

3k views

### Stop MS Excel 2003 closing all open workbooks

I have noticed that when I have multiple workbooks open with MS Excel and I close one, excel will attempt to close them all. This is extremely frustrating and has resulted in me losing work on many ...

**1**

vote

**1**answer

55 views

### Having more spreadsheets displayed in the recent opened list in Excel 2003

I'm currently using Excel 2003. The list of recently opened spreadsheets accessed through the File menu contains the last four opened and edited spreadsheets.
Is it possible to change the number of ...

**1**

vote

**3**answers

6k views

### Sharepoint List Exported to Excel - Columns are readonly

From a sharepoint list, I chose Actions -> Export to Spreadsheet, saved the owssvr.iqy file, opened this file, and tried editing entries in Excel.
When I try to edit any columns, I am shown: "The ...

**8**

votes

**4**answers

21k views

### Select each nth row in Excel

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new ...

**0**

votes

**1**answer

120 views

### excel function to count occurances of text in a column

please give me the complete code for me to copy and paste in order to get the results in column B. please note that my actual spreadsheet contains a lot more than just 3 different variables for ...

**0**

votes

**1**answer

140 views

### Excel, deleted data recovery

How do I make sure that in Excel, if I delete some sensitive data and send the file around this is not recoverable?

**0**

votes

**2**answers

4k views

### Macro to open excel hyperlinks

I would like to know if anyone can help me do a macro to open a list of hyper links.
I have a list of about 600 hyper links all in a column in separate rows, i have to open each one to see if the ...

**0**

votes

**3**answers

2k views

### custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...

**1**

vote

**2**answers

2k views

### Microsoft Excel Undo Only Works Twice

I am using Microsoft Excel 2003. A major irritant is that I am unable to use "undo" more than twice. Can you not use Undo more than 2 or 3 times or am I missing something? Are there any solutions to ...

**0**

votes

**2**answers

2k views

### How to get Excel out of Select Cell mode

Looking for a tip on Microsoft Excel (2003):
If you click on a cell containing a formula, click into the formula, and click away, Excel will enter the cell or range you next select into the formula ...

**8**

votes

**1**answer

16k views

### Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).
How can you configure Excel to use the same ...

**1**

vote

**3**answers

795 views

### Excel select column

In excel, if I want to perform a function with the column to the left, how do I go about this?

**1**

vote

**2**answers

953 views

### ASCII codes appear in Excel '03 but not '07

Part I - I have a spreadsheet that was from data exported from an application. When I open it, I can see the 'boxes' that usually are from a line break or paragraph break in a cell. IF I view the ...

**1**

vote

**5**answers

576 views

### Unable to create charts for all values in an entire column in Excel 2003

My Excel data looks like this: (it's a lot bigger in fact)
code1 code2 01/08 02/08
X A 12 10
X B 8 15
Y A 52 0
Y B 5 5
Every day I ...

**2**

votes

**4**answers

10k views

### Using two conditions with a SUMIF function in Excel 2003

For a given row on Sheet1, I use the SUMIF function to see if the value from the first cell of that row is on a list of historical values in Sheet2.
That will basically summarize all the values on my ...

**3**

votes

**4**answers

5k views

### Excel formula to display a string of text and numbers

I need one column to show the following text: prxyz,(data1 here),0699,ABCD(data2 here),xxx
data1 is in column A and data2 is in column B.
the format of data1 needs to be 5 numbers (sometimes ...

**0**

votes

**3**answers

1k views

### Sum Column, but only Filtered Rows

I have a large flat file of a bunch of ungrouped primary key values.
I want to filter on a key and populate cell A1 with the value selected from the dropdown list.
In the end, I want to see a sum of ...

**2**

votes

**2**answers

17k views

### Converting excel 2007 files to excel 2003

I'm currently using a library named http://www.codeplex.com/ExcelPackage>ExcelPackage to generate a large number of excel files.
Unfortunately it saves in an xlsx format, the Excel 2007 OOXML format. ...

**5**

votes

**4**answers

10k views

### Make Excel 2003 Open Spreadsheets in new instances

In Excel 2003, It seems to be putting each spreadsheet I open into the existing Excel application as a new window. this makes it very difficult in a dual monitor set up to put one spreadsheet on each ...