I use column "D" for entering invoice numbers.How can I have Excel lock at all previous enteries to see if I am duplicating an entry on any other row of...

I am trying to create a book listing my record/karaoke collection in Excel, from the file names on my hard drive. So far, I went to the command prompt in DOS,...

Hi, I have a problem with excel 2007. I want to delete some columns which include some words (like as @xxx.com.au). How to delete those colums with macro? Pls...

I am trying to create a price list subject to a discount. I need the formula in order to issue a nett price list Regards Les

How do I write a formula that shows the overage of 40 hours in a cell to show overtime from another cell? ---------------- This post is a suggestion for...

How do I average a column of numbers where less than values are calculated as that number? 2 2 3 4 2 5

email worked on trail but when it was deleted lost email in purchased version student 2007 . help I have no clue how to fix this . thank you

New user Excel 2003, Windows Professional 2000. I have a file 2900 rows but just for 100 people - it repeats a name / code every entry. I want to use this...

Hi ALL, This is Vivek here.Can anybody help me in explaining; How to convert a MS word document to MS excel Sheet, manually ? ( it's not a word table i am...

Is a way that I can password protect a file so that no changes can be made to the original file, but if I want to allow someone else to view that file, they...

what i would like to do is be able to create a "gateway" leading to a new page, or new area of the current page when you click on a certain number. is there...

I would like to have Excel total the sum of a row 5 of randomly generated numbers in a 6th column, one column at a time. I have no problem generating the...

Hello, I am trying to write a macro (complete newbie) has the following function: (I used the toolbar, not forms for checkboxes) if the value ot checkbox 1...

I need to enter the following value: 1-99 Whever i enter it, excel changes it to Jan-99. I have tried formatting the cell to the general format, different...

I would like to add text to a cell just like using word. That is, being able to type a short line and hit return for the next line. Right now I can not have...

Hello all, I have an excel work sheet developed I would like to add a function that will insert a picture into a cell based on a second cell's value The...

I have a Excel worksheet having serveral duly filled in pages & duly formated. However there are few pages which are are to be printed but without filling...

The above function will not pull "each single character" from a string. I have text strings up to 27 characters. I want to pull "each character" into a...