I have a worksheet ("Winners Log") which has a list of JPEG numbers in column A. I want to click on any JPEG number, have Excel find that JPEG photo in the...

I am having a problem with Excel. One column in particular is a "number" formatted like “text�. Some of the cells say they are formatted as text, but...

I have a large sheet with about 1000 rows and 9 columns. I want each blank cell to be filled with a color i specify (lets say yellow). How can I do this with...

I'm trying to format my spreadsheets so that when I'm working with numbered lists, the numbers stay in sequence. If I delete or add rows or if I type a number...

How do I filter rows with duplicate information? I've downloaded a spreadsheet containing about 7,000 rows. Some of those rows contain duplicate data. I...

Is there a Delete Function I can use to delete a row IF one cell is equal to another cell minus another cell?

when i transfer an excel file that contains =convert formula when used on a pocket pc the formula is stripped away - why is this ? is there an add in for the...

When I have a large amount of data being fed into merged cells, wrapped text dissappears after roughtly 1000characters. Is there a way to change this? As...

I have a cell that contains a typical IP address in the form 123.456.789.012 (dotted decimal). I want to break each octect into a seperate cell, so that if...

What is the best way to apply conditional formatting in the following case? I have a column with validated text fields (users can select one of...

Hi , I am trying to copy an entire spreadsheet from one workbook to another workbook. But it only copies the values not the formulas and if I try the paste...

When using the VLookup function, I am using "FALSE" as the argument, for the "range_lookup" argument, because I only want an exact match; however, it returns...

While doing some auditing I noticed that the IF() worksheet function behaves differently when it is entered as part of an array formula (control-shift-enter)...

Hi I need to find how to work out the total number of months where I have a list of fixed start and end dates, always beging on the first day and end on the...

I password protected a large, multi-tab workbook so that shared users would not alter the structure. Even though I have a long history of well-documented...

I have used the INDIRECT formula many times on a particular spreadsheet. ie B1: D A1=2 C1= INDIRECT(B1&A1) A2=2 C2= INDIRECT(B1&A2) A3=3 C3=...

Try adding the following VB to a button on your master sheet In Cell B1 in Sheet2 put a 1. =========================== Set myRange = Range("A:A") x = 3 y =...

I found that when trying to apply the INDIRECT function to a Named Range that defines a multiple selection range, it doesn't work. Does anybody know anything...

Hi Everyone I import a column of numbers from a database to Excel. The column comes in as numbers. I need to convert these to text but it's not exactly...

hi, i have a spreadsheet with about 4 columns of data. while recording a macro i deleted every cell in the 4 columns of data. i then had a button and i assined...