text entry

Hi all, I am relatively new to Excel. I have figured out how to use named ranges as lists and use INDIRECT Data Validation to have a list's selection made in one cell populate a new list in an adjacent cell. However, I have a situation I cannot figure out to save my life. A1 contains a list...

I have a spreadsheet with a named range ("Names") that contains a list of business names. I want to find out how many businesses have names starting with the letters specified in an interval. For example, I want to answer a question like: How many businesses have names that start with letters...

Dear Smart people: i'm using excel 2007, and i've seen Bill select a rectangular group of cells with his mouse, then type a word in the upper-most top left cell (which is white), then all the other cells automatically populate with that same word. i can't get this and searching 'autofil' in...

Hello everyone! Help! I have created combo boxes in several tables in which I need to assign a numerical value to each option chosen so I can calculate a numerical “score” based upon what each user has selected. For example: Not Applicable = 0 Introduced = 1 Emphasized = 2 And so...

I've created a change order workbook which requires an input of text into each change order sheet. In order to make it easier and more user friendly, I'd love to be able to format a merged section of cells into a text editor much like this comment box so that I can use tab functions, return key...