| Thread | Last Post | Replies |
|
| how to show 3% increase in hourly pay in each cell? | 27 Apr 2007 02:52 GMT | 2 |
want to be able to enter a hourly wage ie. $10.00 and when i enter $10.00 it will automatically show the 3% increase added to the $10.00 showing $10.30. thank you in advance.
|
| Bookmarking Excel Files from within Excel | 27 Apr 2007 02:32 GMT | 3 |
I have a bunch of files that I frequently need to open from within Excel. Is there a way to "bookmark" these files say by putting an icon for each file on the Excel toolbar? Seems like a very common need so I am hoping there is a solution.
|
| Combine variable number of columns | 27 Apr 2007 01:54 GMT | 1 |
I have a single spreadsheet with a list of clients, addresses and their product interests. This table will be used to drive a Mailmerge document. In the document, I want to be able to refer to the products in which they indicated an interest. The problem is that while one client ...
|
| picture is not showing up in Excel | 27 Apr 2007 00:52 GMT | 1 |
I have a picture that is in an Excel worksheet. I can see the handles and if I move the handles some, the picture will show up. However, it will not show up in print preview at all or page break preview. I can open the same file on another computer and it will show up fine.
|
| How do I stop Excel from changing last digit in a number entry? | 26 Apr 2007 22:34 GMT | 1 |
Whenever I try to tpye in a line of 16 numbers in my Excel Spreadsheet, Excel changes the last digit to a zero. Anyone else have that problem? If so, how did you solve it?
|
| Expand a Named Range in 2007 | 26 Apr 2007 22:08 GMT | 2 |
I'm actually an experienced user, but am now using Excel 2007 and can't find how to expand my named range. It's been changed and I'm not able to find it in the help section. HELP!
|
| Find missing item in series | 26 Apr 2007 22:01 GMT | 2 |
I have a spreadsheet showing the storage location of production tooling. Locations are identified as A051, A052, A235, B543, C234. The Series would be A001 through A200; B001 through B325, etc. I need to be able to find an open slot - that is a number that isn't used.
|
| #REF errrors using vlookup | 26 Apr 2007 21:02 GMT | 1 |
I'm getting #REF errors when using the vlookup function. It happens everywhere! All of a sudden, vlookup just won't work. Specifically, in cell Q2, I used =vlookup(P2,$A$2:$A$1000,2) and got #REF. The value in P2 is the same as the value in A2.
|
| How to split up the data in one column | 26 Apr 2007 19:56 GMT | 2 |
I have a long list of full names, Spanish names at that, that need to be separated into First Name and Last Name columns. Sometimes, there are 2 or 3 or 4 words to the names so the first thing I really need to do is figure out how to sort these so that all the names with
|
| HELP! | 26 Apr 2007 19:12 GMT | 1 |
I am working in a document where I need to input data. I would like it to tab from one cell to the next cell that needs data input. I looked at the change the default tab order for controls on a form. I appears to be what I need, however I do not know what they are talking about ...
|
| Getting rid of selection | 26 Apr 2007 18:59 GMT | 7 |
How can I get rid of the selection rectangle? It seems that it's always there, with a heavy black rectangle, or there's a light black rectangle marking where it was. I'm trying to get rid of it altogether, so I can capture an image of the
|
| Sum of coloured cells in execel 2007 | 26 Apr 2007 18:10 GMT | 2 |
Please can anyone tell me if Excel 2007 has a function that will count the number of coloured cells in a range,. I have a column with red, yellow and blue coloured cells in it and I want to count the number of each colour. Thanks
|
| conditional cells | 26 Apr 2007 15:17 GMT | 3 |
We wish to make an employee timesheet with the condition that each required cell must be completed prior to continuing to the next required cell. For example, a clients name must be typed in a cell before being able to type in the date, and then the date must be typed in before ...
|
| Help with Formula in excell 2007 | 26 Apr 2007 15:06 GMT | 2 |
I am using columns F3, H3 I3 and J3. In column J3 my formula is =max(f3,h3) which is what i need but I want a formula that if I3 has a value then J3 I3=max(f3,H3),I3_>0,blank) but keep getting errors, I also tried 0 and none where the word blank is in the previous formula. Any ...
|
| Excel 2003-Sp2 - Resize the formula box in the formula bar | 26 Apr 2007 14:23 GMT | 2 |
Resize annoying formula box, when e.g. Collumn A has very large text in fields, and the formula field drowp down and covers the 1st row or more. This were not an issue in Excel 2000 and in Excel 2007 you can hover the mouse or use CTRL + SHIFT + U and choose number of lines / the ...
|