I have two spreadsheets. In ss 1 there are names that are linked from ss 2. When I use ctrl+f to find the names, they are not found, even though I can see...

Hi there, Want to enter column a1..a26 alphabetically. I'm sure I can do it using fill on the edit dropdown, but can't seem to get it to work. Any solutions...

i want to create a column (A1) where i can choose from a list of clients How do I create this list and keep it hidden?

I am trying to copy a cell on Sheet 2 onto Sheet 1 and all I get is the formula not the text. Help please?

We are doing a vlookup for a date cell in both workbook which is in column D this is the formula =VLOOKUP(B10,'C:\Documents and Settings\Administrator\My...

People, i need help with some spreadsheets regarding construction industry supply of materials, verifications etc, if any one has a spread sheet available, any...

I've recently obtained Office 2003 for my work laptop, and to say the least it is getting on my nerves! When I want to access Help, I want a nice little...

Columns A, J, K and L are visible. Columns B to I are hidden. When I select a few rows using the shift key, click "visible cells only," click copy icon and...

On sheet 3 of my workbook I have created a button (button 62) and a text box (textbox 63). What I want to do is use the button to toggle the text box on and...

I have created a spreadsheet requiring data to be entered in a set order. By that I mean the first entry will be in the first blank cell in column "B". On...

I am really new at excel and I used page breaks to make a log in sheet how I need, now it says Page 1, and i filled up the name column how do I add another...

Hi Everybody, Starting to draw out a new database and in the past I have had problems in certain areas of the database seeing the whole field name. I can see...

I have a table with over 5000 rows. However, only about 2500 rows contain info, the rest are empty rows (one row with info, next empty, etc). I deleted a few...

I would like to use if and then statements to recognize P, O, or C if the cell has P, O, or C I want the row to change colors Blue, Green, Red Is this possible

Shortcuts keys in Excel are always assigned based on the first letter of the menu item. For example. to open a new file the shortcut is CTRL + N, N is...

I have many cells with descriptive text, does anyone know of a formula where I can take for instance a cell with 500 characters and take only the first 30 and...

Help ! Ive copied a price list of a PDF file and need to put it back into original columns in an Excel file. I tried Text to columns but as the descriptions...

Hi ppl, (first post so forgive obvious mistakes) I am after the code, formula (not sure what it's called) to be able to for example put in cell 1 a number in...

Could i get the SQA results 0f 2006.Thanks.