Version excel 2003

How can I cause excel files to always view page breaks rather than having to go through 'Tools', 'Options', 'View' and select 'Page Breaks' under Window...

I know that at one time I changed the color of comment indicators in Excel--but can't find the instructions now. A friend needs a color other than green. ...

I am running 2 monitors from my graphics card. Is it possible to display one worksheet on one monitor and another worksheet on the the second monitor? I have...

When I open an excel document, excel opens the document in the same instance of excel. When you close excel, it closes all open workbooks. I would like to...

I have excel2007 and it opens when i access an existing file. I just can't find it any other way. where is it installed by default so i can make a...

I have a landscape document that has 5 seperate areas on the sheet with seperate information. I want gridlines in each seperate section but not in between...

I have a macro for an Excel spreadsheet that I used to add dates. Unfortunately I wrote it on a computer that was in the Canada region DD/MM/YYYY and when I...

Example: I have cells A1 through A70 with data in each cell in the following format 123-03-123. I need a sting of text returned that will combine the cells...

windows xp pro all updates installewd upgraded from office 2003 pro to office 2007 standard. open excel and get message Metyhod 'Add' of object...

I have a spreadsheet where I enable auto filtering. When I select a particular filter category, normally in the status bar, it says xx of yy records...

I would like to have a mixed cell format in a single cell, i.e., a label followed by the results of a formula calculated in the cell. An example would be:...

I created a macro which unfortunately applied to all workbooks.Each time i open a existing workbook, a personal xls open with it.I uninstalled office and...

I have a narrow (4 columns) but long (2200 rows) spreadsheet. I am trying to print in multiple columns on one page (i.e. "newspaper colmns") before it moves...

How do I copy macros from one workbook to another? Thanks John

From my previous post yesterday "DYNAMIC NAME"(worksheet function forum), I had just been fed by Gary's Student - single handedly- how to define a dynamic...

Hello, I have written one MS-Excel add-in. One day I modified it and saved. When I closed Excel and I found the changes are lost. They don't get saved....

When printing a worksheet, is it possible to repeat some rows at the top and some other rows at the bottom of the worksheet at the same time?

hi there, i am with a client and she is trying to protect an Excel worksheet. She creates the document, clicks on protect worksheet, enters the password. if...

I have the following data in one cell and I want it to start a new line in the same cell. 72411 Diet Clerk 2150-3, 72411 Dietitians Assistant 1706-2, 72411...