| Thread | Last Post | Replies |
|
| One big column to lots of small columns | 01 Jul 2006 00:00 GMT | 7 |
Howdy Excel experts, I have one big column of data, each chunk of values separated by a space of blank cells. I'd like to take all the data chunks and put them each in their own column, beginning at the top of the worksheet.
|
| Copy the "Title" Field from windows explorer to excel? | 30 Jun 2006 21:58 GMT | 1 |
Im trying to copy the "title" field along with the "filename" into excel. Im able to copy the filename field via a batch file using the Dir command, but it doesnt allow you to copy the other fields that are in the explorer window. Is there a a way to do this?
|
| Make a 'Print button' | 30 Jun 2006 21:57 GMT | 2 |
How would I make a cell into a 'print button' (radio button?) I need to be able to mouseover and either click or press enter on cell, and doing so would cause a range of other cells to be printed. S cell A1 would be my button, click on it or hit enter once it wa
|
| count the number of caracters in a cell | 30 Jun 2006 21:32 GMT | 2 |
How can I count the number of caracters including spaces in a microsoft excel worksheet
|
| Separated data in one column to multiple columns | 30 Jun 2006 21:00 GMT | 2 |
Howdy Excel experts, I have one big column of data, each chunk of values separated by a space of blank cells. I'd like to take all the data chunks and put them each in their own column, beginning at the top of the worksheet.
|
| Import from scanned page into excel | 30 Jun 2006 20:49 GMT | 1 |
I have been asked to take a printed document that contains a list o phone numbers, scan it, and import the list into excel. What is th easiest way to do this? Thanks,
|
| 0ffice 2003 Objects Shift? | 30 Jun 2006 20:47 GMT | 1 |
I just got office 2003, and I am noticing that when I have an arrow in an excel file, that it sometimes shifts when I print it out. It looks fine on screen, but for some reason, it is in a different location when i print? Has anyone else experienced this?
|
| Looking up corresponding entry in table? | 30 Jun 2006 20:25 GMT | 2 |
I am wondering if I can combine the MIN()/MAX() and *LOOKUP() functions to perform the following task. Suppose I have a table of data (2D) and want to use the MIN()/MAX() functions to pick out the min and max values in the Y-column respectively. Furthermore, suppose I want to
|
| Activating a Macro | 30 Jun 2006 19:46 GMT | 5 |
How do I activate this Macro? Sub sigma_to_cell() Selection.Font.Name = "Symbol" Selection.Value = "S"
|
| alias for the INDIRECT function | 30 Jun 2006 19:41 GMT | 10 |
Gang - I'm using the INDIRECT function lots of times in my cell formula and it is taking up a lot of space. Is there a way to assign an alias "IND" e.g., to a function and use that in a cell reference instead of the actual function name?
|
| Formula for determining number of hours? | 30 Jun 2006 19:23 GMT | 1 |
Does anyone have a formula which would determine number of hours like for 9:00-12:30, or 1:30-3:00 etc. so that I could use result and multiply it times number of days and have total hours? Guess it would involve conversion to 24 hr clock?
|
| This should be simple | 30 Jun 2006 18:41 GMT | 3 |
I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not contain values. If only one of the cells contains a value, I want this value to appear in B1. How can this be done?
|
| locking excel documents in a folder | 30 Jun 2006 17:49 GMT | 1 |
Is it possible to have a folder with numerous excel documents in it; that can be accessed by anyone and modified by anyone, but No-one can remove them from the folder? Regards
|
| Auto change formula in cells when source is changed | 30 Jun 2006 17:13 GMT | 5 |
Good day experts; If specific cells have the same formula for example: C1 = Product( A1;B1) C16 = Product(A16;B16)
|
| Change fill color after input automatically | 30 Jun 2006 15:37 GMT | 2 |
Do you have any suggustion for the following task. I will make new entries to the excel list frequently. I hope that after I input something in column A, the fill color of the entire row will change automatically to indicate that it is a new enter. And before I close the
|