When I enter a long number, it overlaps into the next cell. However, I do not get the # sign. Instead, a type of formula appears. For example if I entered...

Hello Everybody! My problem is this: Column B / Format Cells / Custom / hh:mm B5=17:00 B5 17:00 B6=21:48 ...

Hey, Need some help with a simple problem. I currently have 3 columns. In column A, there is numbers ranging from 0 to 10. Depending on the number, I...

IN "AA6" I NEED A FORMULA IF AA7 IS BETWEEN -.03 AND .04 TRUE SUM(O6:S6)+SUM(U6:Y6) FALSE DO NOTHING

Hello, I'm wanting to change the defualt border colour of a worksheet from grey to black. Can someone please tell me its driving me nuts.

I would like to embed a hyperlink in an Excel form to a file that resides in an Outlook public folder and can't figure out how to do it. Anybody know if...

I have dozens of fields to insert into a PivotTable. I love the fact that in Excel 2007, I can simply check them off and they are inserted. My problem is...

-- Ask the right questions you get the right answers.

Element value is in A4 and the range is A5:E30 B4 is to show the location Element value may not be unique. Thanks

Hi All, I have referred to the following links of Ron: http://www.rondebruin.nl/tips.htm have already used that code.

Hi Guys, I have a strange Problem with my code. My code zips the file from File Server and then opens and reads it in excel...

Hi all, I'm currently doing some cataloging of all my cd's and DVD's, and have come across something that is a bit of a tricky thing for me. The way I'm...

I have a list that I want to transpose from right to left (not to be confused with transposing a horizontal selcetion to vertical) any quick and easy solution?

I am organizing a high school reunion and have an Excel file with most of alumni's contact details e.g. emails, telelephone numbers, etc. There is a class...

I have created a PDF file from a analysis software. I want to include the pdf file in my word document created with some introduction. when I use insert...

I have too much data to sort, cut and paste. Is there a function I can use in a formula to move data from one column to another? For instance, I need to move...

I have a problem in Excel 2003, when I open an already saved spreadsheet, the row height is doubled from when I saved it and I have to go back in and reset...

I add new information to a spread sheet each month. How do I get the existing formula to expand down to the newly added information? -- JAR

we use excel as a drawing register, with the first set being version A and the second set being Version B and so on. I want to link the second sheet into the...

I can't seem to apply themes to my excel worksheets. I click on the "Themes" button on the Layout ribbon, and nothing happens. I click other themes,...