Right, this might sound like a really basic question but I can't find the answer anywhere. How do I step in to a cell with data in it without either...

I have a spreadsheet from someone and it's all in CAPS. i want to change all the font to lower case. Is there a way.

I recently upgraded to Excel 2007 and Windows 7. Previously I was able to ask the program to 'open' and then go back/forward through the folders to get to...

Hi to all, I have been looking on how to get this through. I have a workbook with at least 3 sheets, that can increase to 20, 30, etc... or reduced to 3. the...

Hi, How can I use "shell" to move from Excel to the current (default) web page to copy some comma delimited text data, then open Notepad and save it there? I...

We are switching from QP to Excel. I will need to do a query and extract the data to another sheet in the notebook what I have now looks like Data Query Roll...

Wondering if there is a simple formula to concatenate row 1 values based on the criteria of "df" for each date. This formula could be placed in another...

Sorry for the lack of knowledge. I have some spreadsheets which pull data from sql database thru an ODBC connection. Since upgrading to 2007, when I "Edit...

I have a list using unique coded ref numbers. During the data entry process, if the unique code has already been entered, I use this statement...

I'm looking for some DVD movie collection templates. Can anyone help? Thanks

I want part of my excel spreadsheet to have gridlines and the other part without

THis macro seems to be clearing all items from the sheet I only need it to clear the rows i have listed Sub clear_inputs_new() ' ' clear_inputs Macro ' ...

I have a simple formula that inserts a value in a cell from one spreadsheet into the cell of another spreadsheet. If the source cell doesn't have a value,...

I want to count the number of cells that have a value greater than "0", but not use a range. The cells that will be counted are every other cell in that...

I had excel 2003 for many years, and it worked fine. When I opened mult. files it only opened up one personal.xls Now I have problem. Everytime I click on...

does any know if sampling from a set can be done until all values are selected?

Hi, can anyone help please. How can I draw a shape that has specific dimensions. Steve

I have a spreadsheet that contains locked cells. Others have to be able to type data into certain fields only, but when someone has Excel 2000, they can't...

How do i get the data to the right of slash using a formula the formula below works for data to the left of the slash thank for any help. Cell A1 - 11.25 /...

I want a formula that has a search for many different criterias: EX: Look for "Account", Int the "Account Group" ... look for "Production" In the "Production"...