| Thread | Last Post | Replies |
|
| Excel: cells prepare to copy how I remove it | 23 Aug 2007 16:30 GMT | 3 |
When I select cells to copy with: Selection.Copy What I must do to remove this selection? I think it's easy but I cannot find how I remove this selection.
|
| Display issues | 23 Aug 2007 16:29 GMT | 4 |
Ok, I've set up multiple work sheets in a work book and have referenced cells from, we'll call it worksheet 1, on worksheet three. I have them showing up in the cell, however I am referencing three different cells from worksheet 1 into one cell in worksheet three and I am not ...
|
| Validation note to comment note | 23 Aug 2007 16:27 GMT | 1 |
Is there a way to copy validation notes to a comment. When you right click a high lightd text it doesn't give you a copy option oldjay
|
| Format Control dialog box control tab | 23 Aug 2007 16:26 GMT | 1 |
I can not get the Control tab in the Format Control dialog box of a combo box. How do I get my missing Control tab?
|
| How to write/Remove some text (Like Page Number/ Confidential) @ s | 23 Aug 2007 16:16 GMT | 3 |
Hi, As mentioned in subject.... I have to remove from one of my worksheets the text Page 1 ,Page 2 etc... which are appearing in background over the content in the sheet.
|
| calculation | 23 Aug 2007 16:09 GMT | 6 |
Hi there, Sometimes the formula in the cell dissapears eg =890/1000 I get 0.89 instead. but I would like to see the formula so I can refer to in
|
| Type in one cell and data copies into another cell | 23 Aug 2007 16:02 GMT | 2 |
I have two worksheets that will be holding the same information, but in a different order. I would like to be able to type the data into worksheet1 next a specific heading and on worksheet2 it copies next to the same heading (although its on a different row). Hope ya can help!
|
| nested ifs not enough | 23 Aug 2007 15:58 GMT | 1 |
I have results in random days. This next formula works perfectly when i have a maximum "hole" of 7 days. The problem is when i have gaps of more than 7 days. E157=IF(D157=0;"";IF(D157-D156<D157;D157-D156;IF(D157-D155<D157;D157-D155;SE(D157-D154<D157;D157-D154;IF(D157-D153<D157 ...
|
| Macro | 23 Aug 2007 15:42 GMT | 3 |
I have a workbook with two worksheets. Worksheet 01 is the summary Worksheet 02 is the form template. I have a form button on Worksheet 02, I have tried to record a macro for the
|
| Validation list boxes not working | 23 Aug 2007 15:22 GMT | 1 |
I have been setting up a spreadsheet using validation list boxes and for some reason the validation is being set up but it does not give you usual dropdown list. It was working first of all, but I have since set up check boxes and a combobutton and now my validation boxes do not ...
|
| List of numbers seperated by a colon | 23 Aug 2007 15:07 GMT | 8 |
I would like to transpose a vertical range of cells into a single cell so that each number is seperated by a colon. Here is an example: A B C 1 50 50:45:30
|
| standard deviation | 23 Aug 2007 15:06 GMT | 2 |
i don't know how to find standard deviation for grouped data. this is for my add maths project. pls help me. explain to me step-by-step coz i really don't have a clue how to find it using excel. thnx.
|
| Alternate selection methof for many tabs | 23 Aug 2007 15:03 GMT | 8 |
I have a workbook that will have about 30 or so sheets. Using that little scroll bar to choose various worksheets within is a pain in the but. 1) Is there a way to sort these tabs alphabetically and automatically? 2) Is there any way to pull up a list of them where one can be ...
|
| FORMULA HELP any body | 23 Aug 2007 14:40 GMT | 4 |
I have the data with sales volumes of each customerwise for a financial year. I have designed a format that is having three excel sheets. In "sheet1", i have created a button and in that all months (i.e., apr-2007, may-2007, like wise upto mar-2008)
|
| Anniversary of a date | 23 Aug 2007 14:38 GMT | 4 |
Hi - I need a formula that will return the date of this years anniversary of a date in the past. My data is set out as follows: a b c 1 B Smith 25/10/02 25/10/07
|