When you try to make an absolute reference to a cell, you place "$" in front of the column and/or row. But can you do it more easily by, for example, selecting...

Forum, Hope you can help, I have joined today as well so be nice :cool: I am creating a worksheet that will require all of the toolbars to be removed on the...

A B C D E F G CAR NO. RUN 1 RUN 2 RUN 3 TOTAL QUALIFIER 5 6 4 ...

Hi, I have a column of data in Excel in the worksheet that is displayed as "0:00:00" and greater time values beyond 0:00:00 AM up to 2:00:00 AM. In...

I Have A List Of Names That I'd Like To Place In One Cell With A Drop Down Liet. How Would That Be Done? Thanks For...

Hello everyone... I have a column in a worksheet that finds the latest date in a column (This is the lastest paid date). Now, I want to have the amoutn paid...

I have just opend up a spreadsheet i use constantaly, now when i select a range then copy i get the message "cannot open the clipboard". i am still able to...

Hi I've setup a Shared Workbook which is being used by 3 different users on a LAN. We are all up-dating the spreadsheet at the same time but have found that...

I have a worksheet that I use to update league baseball game stats on a daily basis. Each day as many as 13 new rows are added to the bottom. I then have to go...

This is probably a dumb question, but I have looked everywhere to no avail. Is there a way to copy a picture from an excel document to a folder in it's...

Hellow all, I am really new with excel. I think this is the third or fourth time that i really opened excel. But now i have to work with it and...

Hi all, I have named a range of cells on one worksheet, say I called (A1:B10) as "My_Range" on "WorkSheet_1". And then I got another worksheet which want to...

I have the cells formatted for time and summed and I know that this actually represents a number in Excel but how do I multiply that number times rate...

I received a database from another source in cell c1 i enter =A1 and press enter nothing happens it just abbears as =A1 No formulas are working But in another...

I've already figured out how to enter employee's time, but now I want to have it return anything 40 hours and below into one cell and all hours over 40 into...

Can you please tell me if it is possible to create parent/child type sheet. I need a part number like CAT1234 with a + before or after it and the when I click...

We have a number of multi-year spreadsheets for collecting and analyzing monthly costs for a small business. Every month, we delete the oldest month and...

Is there a limit to how much data you can transpose? I am in a worksheet with 52 columns and 525 rows and it won't work. I get the error that the column width...

I am unable to use the formats $ , % from the toolbar. If I click on them, I get a message saying :"Style not found" Currently I have to go into format cells...

I would like to be able to give a cell a rating of 1-5 and colour coded but conditional formatting in excel 2002 only allows up to 3, by using 1 number as...