For example. I have two files: p1.xls and p2.xls In p1.xls in unknown Cells value = "AAA" or differend string.. and this file isn't open. and I would like to...

Something stupid: http://click.sat7.de

I have a basic spreadsheet for my work that keeps track of sales for a promo that we have going on. I woulds like a formula that will tell me who is rank 1, 2,...

I need to Find and Replace values in a Column Same data also exists in other columns - so I would like to restrict the Find and Replace to a specified...

I am working on a staffing worksheet and wish to highlight the rows for the weekend. I have tried conditional formatting but I dont have the know how to have...

I'm having bother with the IF function. Cell A1 contains a figure derived from another worksheet. Cell A2 contains 4895 Cell A3 is A1-A2 Cell A4 contains...

I need to format a column to accept data as elapsed time in the the format mm:ss. when I try to format a cell using custom and typing in :ss, that cell...

Hey all. Just got Excel 2003, and have a real basic question. I'm working in large files with very long cells, and everytime i click into one to edit it, it...

Hi, I've programmed access using VBA before but not excel. I'm lost and duno where to start. This is what I intend to do: To program a system to let users...

Dear.Sirs We chage the EXCEL from 2000 to 2003 new version with DELL DIMENSION8400. But somtimes the copy command and write line of its speed is too slow? Our...

does anyone know how to print on an 8-Tab sheet! I need to print out some labels!

does anyone know how to print on an 8-Tab sheet! I need to print out some labels!

Hi! Since a few days when I call Excel I must wait before I can start working as there appears a message box "Installing : MS Excel feature" which needs about...

Sorry for the newbie question, but. . .I have data in a workbook on 10 worksheets. All are formatted identically, and I would like to combine the 10...

for example. I write to cell A11 value "hello", and next: IF I click "ENTER" or IF I click mouse in any different cell (A15, B10, C1... free choice) I wont...

Hello, I have a sheet that has a set scroll area, protected and unprotected cells. I cannot tab from the last column in a row to the beginning column in...

I have a multicolumn database with text entries. I want to join the cells in Col. B with the cells in Col.C and keep all the text. For instance, B3 may be...

I am trying to sort faculty records by position in Excel and am having some trouble. The usual sort options don't seem relevent, so I have a hunch that I need...

i need to sort a column for addresses. i can get it to sort somewhat. example n 7 ave e n 7 ave w s 8 ave e s 8 ave w w 7 st s e 7 st s

Is here a simple way to format a cell which contains an email address as pure text - That is, so that clicking on the cell won't bring up the email program to...