How do I lock N left hand columns in excel so that when I want to see some right hand columns and slide the columns on the right to the left the locked columns...

Hi All Conditional formatting problem: Example A B 1 24/Sept/04 £300.00 2 25/Sept/04 £250.00 3 27/Sept/04 £275.00 4...

I get an error message whenever i try to open a file in excel. It says "Excel cannot access 'filename'. The document maybe read only or encrypted." I don't...

Hi, I know that this will be simple to do, but I've no idea how to do it! I want to look up the value of one cell, compare it to the value of another (both...

I have 6352 mailing addresses in a column, I would like to organize under Company, Adresse 1 Addresses 2, city, state zip phone etc in a row. is there a...

I have recently had to switch from QuattroPro(Corel) to Excel(MicroSoft). All I'm looking to do is create a simple spreadsheet into which myself or anyone...

I am using Excel to track the Accounts Receivables for a small business. I have added a column to track the # of days an invoice is overdue. For example, the...

This is probably very simple, but as a beginner I can't figure it out. Is it possible to creat a a button & place it at the top of my worksheet that, with one...

I need a six week cash flow template which includes the following: Beginning checking account balance Accounts Receivable: 30 day 60 day 90 day over...

Hello, I was wondering if anyone can tell me how to code or input this. What I want to do, is, when the date is input into a cell in one column, the...

i am a new to excel. i recently tried to build a page that calculate profit by agent and agents's account. our company have about 10 agents and each agents...

I a calling Tender for purhase of an item. I want to get only the basic rate plus tax structure and the end rate will automatically get calculated. Hence, i...

How to validate the Cells in MS Excel, so that when the cells are blank the sheet should not save and should warn for inserting charectors/numbers

Sorry all, just testing my newsgroup server. Thanks

When I try to import an excel file into Outlook - I get the message to go back into excel and name the ranges. I understand highlighting the area - going to...

Is it just me, or has something changed with Excel 2003? If I have a cell with wrap text, shouldn't the row size automatically increase if the text exceeds...

I know that if I want to set the row height to fit the contents, I doubleclick on the line heading between that row and the row below it. My question: ...

Another person was accessing this file and when they closed it (I don't know what procedures they used), it had (Group) after the name. Now a number...

I have one column of text and I want to convert it from mixed to UPPER Case. I thought I was following the instructions (in help) correctly, but it keeps...

I don't want any formulas to show in a document..I just want the values to show. How can I do this? Thank you.