The 2003 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

1
vote
1answer
20 views

Can a single cell in Excel extend over several pages? How?

I encountered this problem while trying to write really large chunks of text in Excel. In spite of of wrapping turned on, my text doesn't really get wrapped once it stretches over more than 12 lines (...
0
votes
0answers
13 views

Excel 2003 - How do I link sheets in different workbooks when there are path issues?

I've created several Workbooks relating to the same project and now want to create a master workbook that contains the results from each of the others. The problem that I have is that the formulas do ...
1
vote
2answers
3k views

Format Change Event for Excel VBA

I'm trying to prevent people from modifying (most) of my spreadsheet while still alowing them to use the sort function of the AutoFilter. What I've done so far is used the Worksheet_Change event and ...
68
votes
7answers
324k views

Cells not updating automatically

I have a formula in a cell which counts the values in 2 other cells. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when Enter is pressed or when ...
3
votes
3answers
2k views

Lost VBA when downgrading from Excel 2013 to Excel 2010

I am on Windows 7. In the past I was using Excel 2003. I installed Office 2013 and found that my Office 2003 was intact and I could run both versions. I made updates to some worksheets using Excel ...
1
vote
2answers
10k views

Can I use “Fill Down” to make a vertical series reference a horizontal series?

Say I have a data series going from A1 to E1. I would like to make a second copy of these cells going vertically, for instance from G1-G5. I can achieve what I want just by typing =A1 into G1, =B1 ...
0
votes
5answers
3k views

Why do 2 excel (2003) files that are exactly the same have different file size?

I have two excel files that are exactly the same (in terms of the content of the file) but differ by quite a margin on file size. One file is 37.5 KB while the other is 56 KB. The only difference I ...
0
votes
1answer
36 views

How to express a lone “\” in a file path in VBA?

I'm using a VBA script to save a file titled "month-day-hour-minute" inside of a folder titled "month-year" Anyways, excel doesn't like my code, ActiveWorkbook.SaveAs "C:\Users\" & Environ$(...
0
votes
1answer
38 views

Merge two Excel spread sheets using a common column and retaining duplicates

There are two excel sheets. I am trying to merge the two files based on the id column. For example: first excel: id var1 var2 var3 1 5 4 5 2 3 2 2 ...
0
votes
1answer
113 views

Vertical line excel chart

How is possible to draw in MS Excel (starting from 2003) charts like this Seems incredible that basic things like this be hard to do in Excel I read this article but it involves other 2 helper ...
-1
votes
2answers
26 views

How can I open a specific sheet named after a month?

I have a bunch of Month Tabs What is one way to open a specific one with VBA? I tried using this snippet: Private Sub Workbook_Open() Dim ws As Worksheet Dim mnth As String, dte As String, mday As ...
0
votes
0answers
43 views

How do I make form fill out to different sheets based on the month?

I have an exercise and diet log that I fill out every other day and I want the data to move to another sheet. Sheet 1 looks like a worksheet and I want it to move (I think the best way to do this is ...
1
vote
1answer
350 views

Excel price function not working despite adding the analysis tool pack

I am trying to price bonds using the Excel function, PRICE(..), but the intellisense doesn't come up. The help file says to install the analysis tool pack, but this doesn't resolve the problem. I have ...
1
vote
2answers
3k views

can't select the shape in excel

I have a problem today that is the first time I meet it. I have opened an old file (this file from 2005), then this contain of flowchart which made from excel's autoshape. Then I want to make some ...
4
votes
4answers
37k views

Too much text for an Excel cell — how to make the cell scrollable

What do I do when I have more text in an Excel cell than I want to show in the allocated space? Something making it "scrollable" would be preferred.
5
votes
4answers
40k 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 to a text file in Unicode format, the text which ...
0
votes
0answers
8 views

excel vs access query priority

Hi Superuser this is my question Scenario: -an Access 2003 based application to manage the stock; the application had several mask to peform the update of different .mdb table. -an Excel 2003 ...
16
votes
2answers
68k 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 ...
3
votes
5answers
56k 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). ...
2
votes
3answers
4k views

Refresh values in Excel 2003

I have an excel file with three worksheets(ws), the first two have raw data and the third one contains formula to compare the data in other two ws. For example, here is an example of my comparison ...
0
votes
0answers
7 views

UDF to make cell temporarily wider

In Excel 2003, I have the following UDF which makes a column temporarily wider. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Target....
0
votes
2answers
28 views

All Borders equivalent in Excel for a range

I would think there is a way in VBA to put the 4 wall borders for every cell in a range, but I have yet to figure out or find one. Basically I want a range such as (A1:R780) to all have their own ...
1
vote
0answers
35 views

excel 2003 support with cell formatting

Please help. I have created a borrowing excel worksheet to monitor borrowing books. I want to fill a cell (column B) with a date when an item is returned and then have that row move to the bottom of ...
1
vote
2answers
148 views

Is it possibile to enter dates from a drop-down calendar?

In Excel 2003, is it possible to enter dates in a cell from a drop-down calendar instead of entering them manually?
2
votes
1answer
33 views

Hyperlink refers to the new location of the referenced cell

I'm using Excel 2003. I have a hyperlink in cell E4 in worksheet406R to cell E4 in worksheet104S. When I move E4 in worksheet104S to another location (E16) or sort the data in this worksheet, the ...
0
votes
0answers
25 views

Count unique values [duplicate]

I need help for a formula to count unique values in column A that are blank in column D ...and also to count unique values in column A that are not blank in column D. I dont use filters
1
vote
1answer
2k views

Unable to add, create, or remove drop downs on an Excel 2003 spreadsheet

In Excel 2003 the Validation option under Tools is grayed out for a specific workbook. The sheet is not locked or protected, but it is shared. Even the author of the sheet has the Validation grayed ...
0
votes
3answers
71 views

Highlight birthday in a referenced cell

in Excel 2003 in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday in cell A1 date of Birth in cell B1 age with the formula: =DATEDIF($A1,TODAY(),"Y") &...
0
votes
0answers
15 views

Right click and menu bar drop down list not visible when clicked

It would be great if anyone could solve this for me. When I click on the Menu Tab or right click the list doesn't drop down. I can just about see a faint outline where the list is supposed to drop ...
3
votes
9answers
42k 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 ...
7
votes
4answers
29k views

Why is Excel removing leading leading zeros when displaying CSV data?

I have a CSV text file with the following content: "Col1","Col2" "01",A "2",B "10", C When I open it up with Excel, it displays as shown here: Note that Cell 2A attempts to display "01" as a ...
2
votes
2answers
2k views

Macro name being changed in Excel

I am creating VBA macros in my Excel spreadsheet. I notice that from time to time (after saving the spreadsheet and reopening it, usually) one or more of the macro names is being changed from sheet1....
0
votes
1answer
4k views

Excel Shapes Disappear When I Move or Copy a Sheet

I have a sheet in an Excel 2003 (xls) workbook that has numerous textbox shapes in. If I move the sheet or copy it to another workbook, the textboxes don't move with the sheet. Everything else ...
8
votes
8answers
32k views

Excel's date format without a year

I'm putting in employees' birthdays, but they come without years for sensitivity reasons. But when I put the month and day in, Excel automatically adds 2012 as the year! Obviously this is not right. I ...
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 ...
0
votes
1answer
308 views

Broken ActiveX in Excel 2003

I hope this is the correct forum to post this, I believe this to be an Excel issue. Ever since I upgraded to Win 7 (64 bit), whenever I try to add an ActiveX control to a worksheet in Excel 2003, I ...
4
votes
2answers
12k views

Restrict and validate date format in Excel

I'm trying to put together a 'Data Validation' formula which restricts the user to entering a date in the following format: dd-mm-yy. From the research I've done, I've come across what I thought ...
1
vote
1answer
6k views

How to create an Excel SUMIF formula that can compare different date formats

For my source data I have a column of dates in the dd/mm/dddd format, and a column of values next to it. eg 03/02/2014 5 17/02/2014 4 03/03/2014 5 17/03/2014 4 On a summary sheet I have a ...
4
votes
2answers
5k views

Excel 2003 - how do I dock\fixate a row\column?

how do I create a docked row\column so that when I scroll down\right, I can still see that row?
2
votes
1answer
110 views

Currency Values Pasted From Firefox Becomes Text in Excel 2003

New here. This is a commonly asked question but cannot seem to find the answer specific to my issue. Just got a refurbished computer Windows 7 Professional 32bit. Installed Office 2003 and Firefox 41....
0
votes
2answers
64 views

How to put comma into digits like eastern (especially Indian) style by using a formula in M S Excel?

Friends I want to put comma automatically into the digits like this- 10,00,000 Or 1,00,000 For this I want to use a formula. I also know that I can do this by format cell>number>use 1000 separator (,...
2
votes
2answers
114 views

How to extract remainder of a match of 5 digits in 9

I am trying to extract the "remainder" (the non-matching portion) of a search using Excel 2003. I tried using various combinations of functions but it seems that there's no specific function that can ...
55
votes
3answers
15k 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 ...
0
votes
1answer
52 views

Most recent date for ID in Excel 2003 Pivot Tables

I'm trying to automate a process in our office with pivot tables. I have multiple customer numbers per vin. For my process to work I need a 1:1 ratio of customer numbers to vin numbers. Only the most ...
16
votes
1answer
45k views

Limit an Excel cell to one of two possible values

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell. How could I do this?
0
votes
0answers
94 views

Excel 2003 - Matching and summarising data across multiple worksheets

I am looking for help regarding my roster calculations. I have built a roster over 13 worksheets plus a calculation worksheet. On each sheet column D has a list of names populated from an offset ...
0
votes
1answer
57 views

How to fill up gaps in excel

My data in excel has for example the following data in columns A and B: A B 1 4 2 6 5 88 9 67 12 45 and so on. I would like to transform it as following: A B 1 4 2 6 3 0 4 ...
5
votes
2answers
23k views

How to change font color in Excel based on cell value?

How do you change the font color of a column of cells based on their entered value? I've got a column with the heading at row 1 and the values starting at row 2 going on down. I want to change font ...
0
votes
3answers
14k views

How do I stop a mail merge from adding zeros to the end of amounts of currency?

I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. When I complete the merge, the amounts have ...
10
votes
2answers
36k 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 ...