| Thread | Last Post | Replies |
|
| How can one set up a survey form in Excel | 22 Sep 2006 08:54 GMT | 6 |
How can one set up a survey form in Excel? is there anywhere where there are clear instructions? Thanks. Janev
|
| Fomula to copy every third cell in col | 22 Sep 2006 06:20 GMT | 2 |
I have a list of business addresses and phone numbers in 1 column. Ideally I would like Col A the be name. Col B address and c phone number. Here is the format I have right now. Please help. Ultimate Staffing
|
| how do i remove % from a colum | 22 Sep 2006 04:23 GMT | 7 |
i wanted a percntage in one box of a colum but now every box in that colum comes as a percentage how do i stop this i havetried hitting the % button again but to no avail please help its recking my head
|
| How to restore F2 functions | 22 Sep 2006 01:19 GMT | 2 |
Lately, I am unable to outline, when entering edit mode in a cell, the cell's formula-related cells. I used to, upon pressing F2, see a cell's formula and, highlighted in differing colors, the cells referenced by the formula to be edited/viewed.
|
| go to the top of page in exel | 22 Sep 2006 00:56 GMT | 2 |
how to navigate back to cell A1 or A3 or any other in the worksheet bu using keyboard
|
| Retrieve Deleted Worksheet | 22 Sep 2006 00:53 GMT | 8 |
I did something very stupid. I deleted a worksheet from a workbook. I thought to myself: there are too many worksheets in this workbook. That one is blank, so I'll delete it. Unfortunately, there are some important macros stored in that worksheet and I don't have another copy
|
| Underline with accounting format | 21 Sep 2006 23:27 GMT | 4 |
Preface: If you use the accounting format and the underline you get a great underline that is just a little less than the width of the cell. Problem: It does not underline the right parenthesis in negative numbers. Question: Is there any way to create a customized version of the ...
|
| Make a pivot table from an existing pivot table | 21 Sep 2006 23:10 GMT | 2 |
I'm trying to make a completely new pivot table out of an existing pivot table where the existing table is actually the source data (not the original data table). The problem I have is that this intermediate pivot table has 3 columns of unique values (with over 1000 rows) before
|
| Remove Date Timestamp in Excel? | 21 Sep 2006 21:35 GMT | 2 |
I was wondering if someone can help me out. I am using a csv file and want to calculate if things were done on time or not. Example: In the A column I would have "Date Expected"
|
| Formatting decimal Number as text | 21 Sep 2006 21:11 GMT | 1 |
I want to show a number (really a dollar amount) as you would write on a check 10.95 as "Ten and 95/100". I wrote a function, but it's tricky. Anyone know a way to use just straight EXCEL formatting BTW I use Excel 200 with Win XP.
|
| mystery background color | 21 Sep 2006 20:18 GMT | 9 |
In some worksheets that I've inherited, I noticed that there seems to be a way to give sheets a background color other than Format/Sheet/Background (which uses an image) and Format/Cells/Patterns.
|
| Macro chaning | 21 Sep 2006 19:39 GMT | 4 |
I currently use the following macro: Selection.AutoFilter Field:=1, Criteria1:="<>" How can I change thus macro so that the "1"in field would be changed to the cell that is selected.
|
| Stop Sum blanks | 21 Sep 2006 17:20 GMT | 3 |
I am using the Sum function. My range has blank cells. I am entering 0 for No. If I get a Sum of 0 then I have an answer of False. But how do I stop Excel from displaying 0 when the range of cells is left blank?
|
| excel spreadsheet | 21 Sep 2006 16:12 GMT | 1 |
How do I delete columns from my spread sheet? When I right click the word "delete" isn't highlighted, so it doesn't work.
|
| find a sum number from 300 numbers in Excel | 21 Sep 2006 15:39 GMT | 3 |
I have 300 numbers and 1 number. I want to know whether that 1 number is the sum of the combination of those 300 numbers and which several numbers in these 300 numbers sum up to produce that 1 number. Some of these 300 numbers are same. Can I use Excel to work out that question?
|