everytime a open a certain spreadsheet? I would like to search if several particular account numbers are on a certain worksheet and then highlight it with...

I need to link 2 excel files. Let's call them file 1 and file 2 I need to insert rows in file 1 so that it inserts the same amount of rows in the same position...

Hi In Excel is it possible to hide or lock a formula e.g. =IF(A2=Rate_30,A2,"") so members of staff don't mess with it or delete it by accident - often have...

I have to create a PC order form for customers to order new PC equipment. I have only done simple excel spreadsheets. What I am looking to do is once...

I am VERY new to spreadsheets! Is there a formula that will calculate the % change in my investments from one entry to the next? In other words, if January's...

good job ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion,...

I have a spreadsheet with a series of formulas in various columns. I now want to insert more rows that will follow the formula rules of the existing columns....

I want to show numbers beginning with 0 (zero) in a cell e.g. 0123456. Whenever I enter anything, I lose the zero. Help please for a beginner! kgm

can i put a page subtotal in a footer...

How do I continue a formula into inserted rows?

Hi, I am fairly new to excel and would like to be able to catalogue my Drivers Collection. I would like to do this by 1st by Manufacture, then by...

Why does outlook open when I edit a cell in Excel?

Hello. I have a function that allows me to calculate the length of time between...

Hi, My formula: IF($H$37MONTH(3)*YEAR(2005),"",$H$37+3) IF H37 is less than or grater than March 2005 (not in March) then, display nothing, elae (if it is in...

Not sure if anyone can help me with this or even if it's feasable. What I'm trying to do is keep an inventory for ebay. I want 2 sheets in the workbook say...

Hi I'm using an Excel sheet for pricing items customers purchase. In A2 I could enter any of 4 prices e.g. £30 , £15, £10, £5 In B2, C2, D2, E2, I have...

I can't right click in Microsoft Excel 2000. Even open new documents & restart pc the problem still remain.. I really need help..

How do I put footers and dates on all Excel worksheets in just one go? Have several XLS files that have 10's of worksheets.

Here is my situation. Every month export two reports from QuickBooks into Excel. Report #1 is on one sheet and report #2 is on sheet two. I then set up...

I have a user form using columns A-V in Excel which scrolls down to Row 200. Each row contains customer details in the colums A to V e.g, Name/Address/ Contact...