| Thread | Last Post | Replies |
|
| Date and Time Picker | 21 Sep 2006 23:47 GMT | 2 |
Does any one know where Microsoft Date and Time Picker has gone in Excel 2007, has it gone for good?
|
| How to sort al list in random order for sampling? | 21 Sep 2006 22:50 GMT | 1 |
How can I sort an Excel list into random order to facilitate drawing a sample of the items on the list?
|
| Copy Paste... arg... | 21 Sep 2006 22:50 GMT | 5 |
I have a cell with a formula in sheet1 which points to another worksheet cell (sheet2!$A$1). Now I want to copy this cell to another cell in sheet1, but Excel keeps shifting the cell value in my formula (sheet2!$A$2)... How can I tell it to just copy paste normally without excel ...
|
| How to use validation formulas in Combobox | 21 Sep 2006 22:19 GMT | 1 |
What I want to do is for when the user selects a cell, a combo box based on the field name pops up for better viewing and autocomplete, after a couple of keystrokes the selection is complete and a {Tab} or {Enter} key will populate the cell and it will be validated and move to ...
|
| Concatenate Function | 21 Sep 2006 22:08 GMT | 3 |
I understand how to use the concatenate function to merge several cells with text into one cell. My question is this: after the concatenate function merges the specified cells into one cell, how can you then put spaces between the text strings?
|
| excel formula - possibly visual basic method | 21 Sep 2006 21:55 GMT | 2 |
I need to set up a quite a complicated spread sheet. This is the senario: say my sales figure for monday is £50 (which is my target). However my actual sales figure for monday is £40. How do i get the cell to show the difference between my forecast(target) and my actual having ...
|
| Database (or the like) from Excel Sheet | 21 Sep 2006 21:52 GMT | 3 |
I have an excel sheet that looks like the following style weight1 weight2 x 1.5 2.5 y 1.7 2.9
|
| How do you convert decimal degrees to degrees minutes seconds | 21 Sep 2006 21:38 GMT | 2 |
Is it possible to convert decimal degrees to degrees minutes seconds in Excel?
|
| conditional formating | 21 Sep 2006 21:28 GMT | 1 |
how do i set conditional formating so in the column which show gender i will have M for male and F for female
|
| percentage? | 21 Sep 2006 21:12 GMT | 2 |
my question is i am trying to find the percent of an average. ( i have a spread sheet of 14 people) I am trying to get an 'average' percent of all their combined percentages. WHen some employees are not at work then i leave thoese colums blank and i receive an
|
| Copy macro to another workbook | 21 Sep 2006 20:48 GMT | 4 |
I greatly enjoy "playing" with macro's in excel created by recording my actions; I have no programing back ground so I'm afraid Visual Basic is a mystery to me. I have recorded macros which I would like to use in other workbooks without the original workbook being available. ...
|
| Summary Sheet help with multiple sheets | 21 Sep 2006 20:40 GMT | 1 |
I have an excel workbook with multiple sheets. (Let's say that Sheet 1 is the summary sheet and sheets 2, 3 and 4 are the sheets in which data is entered) I want the information from sheets 2, 3, and 4 to come into the summary
|
| Excel 2003: Autofilter | 21 Sep 2006 20:39 GMT | 1 |
I have a spreadsheet in which I put an autofilter on one row. There are 15 columns in that row and it makes sense to only put an autofilter on one column, n ot the other 14. Is there a way to do this? Currently, all the columns in that row have this little dropdown arrow box.
|
| What does Microsoft want me to do? | 21 Sep 2006 20:37 GMT | 1 |
When I installed MicroSoft Office 2003 Teacher and Student, it did stupid things to my ability to use MicroSoft Works on my machine. One of these is a request to Register my software when I call up an XLS file for Works Spreadsheet. When I click on Register to get rid of the ...
|
| Want a column of cells to have drop down box of another text file | 21 Sep 2006 20:10 GMT | 2 |
I have this spreadsheet that I wanta column of cells to have a drop down box that would show choices froma text file that periodically gets updated. I would like the drop down box to "point" to this external file to get it's data. Is this possible?
|