| Thread | Last Post | Replies |
|
| text | 18 Apr 2007 23:54 GMT | 1 |
Working in Excel 2007, I have a cell designated for text. If text is entered, I would like it to show up in another cell also. If there is no text entered, I'd like the other cell to be blank. Using a formula like "=b12" results in a zero in the second cell if the first is ...
|
| patterns to cell | 18 Apr 2007 22:34 GMT | 1 |
I have an excel spread sheet that I want to assign colors to my 17 numbers but condional formating only goes to 4 colors how can I assign a cell 17 different colors when I select a certain number
|
| IF statements across Worksheets | 18 Apr 2007 22:18 GMT | 2 |
Novice excel user here. I am trying to use the insert function feature to insert a IF statement to make a cell a 1 or 0 based on the value of a cell on a different worksheet. The command I am using is as follows:
|
| template | 18 Apr 2007 21:22 GMT | 2 |
If I save a template how do I use it without losing it. If I use it to fill in blanks and need to save it. How do I know the template will stay in its file and not change? Kim
|
| How do I set up a running balance worksheet ? | 18 Apr 2007 20:31 GMT | 2 |
I am trying to set up a worksheet where i put data into one cell and it is added to the balance using only one cell continously. How can i do this and have a running total daily and weekly/
|
| clipboard wont paste | 18 Apr 2007 20:04 GMT | 1 |
I have the items on the clipboard to paste. Use it often but it will not paste today.
|
| In exel what function does "^" perform? | 18 Apr 2007 19:36 GMT | 2 |
For example: (0.0532+1)^(1/12)-1=0.0043
|
| How do I Import worksheet into a word doc.? | 18 Apr 2007 19:14 GMT | 1 |
I want to import a worksheet in to a word document. In this case the worksheet will be an entire page. It will also be useful to be able to add text and graphics on the same page as the worksheet.
|
| Pick From Drop-Down List... | 18 Apr 2007 18:58 GMT | 3 |
I have created a list in cells A2 thru A13. A1 has text 'Month & Yr' entered. When I right-click in A14, I do not have the option of Pick From Drop-Down List... appear. I have this in another file that was converted over from Excel 2000 & it works fine. What am I missing in ...
|
| Changing the sorting order... | 18 Apr 2007 18:54 GMT | 5 |
Is there anyway to change to default sort order? I am trying to sort in a list percentage change from prior year, but in the case when there is no prior year information the display is "N/A", which is fine, but I need it sorted to the bottom of the list when I sort descending. ...
|
| Calculation Speed | 18 Apr 2007 18:36 GMT | 1 |
Anyone have tips on how to speed up the calculations in a workbook? I've moved most calculations, where possible, to take place in the same sheet as the data resides as I seem to recall a tip that this would speed up calculation. Is there anything else anyone can suggest?
|
| Removing concatenated colums after using them? | 18 Apr 2007 18:19 GMT | 2 |
I used the concatenation formula to join first and last names together into a new cell. However, I now need to delete the two original cells for submission to a printer. Of course, when I do that, I get "REF" in the third cell because the references used to perform the ...
|
| Inserting Number | 18 Apr 2007 17:55 GMT | 5 |
How do i insert number "Zero 0" in front of multiple numbers 7775644619 7764856857 7932085127
|
| Conditional Formatting? | 18 Apr 2007 17:50 GMT | 2 |
I am trying (unsuccessfully) to apply conditional formatting to a column of dates It needs to identify dates less than a fortnight old e.g. Formula is <=TODAY()-14
|
| Protecting portions of worksheet | 18 Apr 2007 17:40 GMT | 1 |
I have an excel worksheet that is used to calculate chemical quantities. The worksheet needs to have all the cells with formulas completely locked - so no one can delete/change the contents of the cell. I actually have a very(relatively) small range of cells that I want to have ...
|