| Thread | Last Post | Replies |
|
| Conditional Formating | 25 Sep 2007 09:52 GMT | 3 |
Is there any way to format a column so that if any info is entered into a cell then its highlighted but if there is no info then nothing happens ex. (INFO BLAH BLAH) would be black text w gold background (blank) would be black text w no background
|
| Sending a blank e-mail | 25 Sep 2007 09:16 GMT | 1 |
Is there a way of sending a blank e-mail using VBA once a marco has run within a spreadsheet? Basically i want to run a macro and then send mails out to a user group to tell that ity has finished
|
| Microsoft Office xp Professional Front page | 25 Sep 2007 08:18 GMT | 1 |
How can I obtain Microsoft Office xp Professional with front page? I currently have excel and I also have to CD that came with my Windows xp professional. But what I need is to do add ins for my statistics class. How can I find that CD? I think I should have received it when I ...
|
| Where is the About box in excel 2007 | 25 Sep 2007 05:08 GMT | 1 |
Where is and how do you get to the "About Microsoft Excel" box in Excel 2007? The one that tells you the version number,user number etc. Secondly I see a business for an Addin that give you the drop down menu option back.Anyone have one yet? Also aren't menu ribbons a Mac thing?
|
| move multiple columns into single set of columns | 25 Sep 2007 05:08 GMT | 1 |
Excel move multiple columns into single set of column How can I automate this I have a huge sheet A B C D E F G H I --- ZZ
|
| Count if and Vlookup using a lookupsheet | 25 Sep 2007 02:54 GMT | 3 |
Hi Team, was wondering if you could help with this one. Summary Sheet : A B
|
| need help with a conditional format in regards to "date" input | 25 Sep 2007 02:40 GMT | 1 |
I have a scenario where a date is inputed in cell B2. I want cell B3 to go red if a date is not entered. Once a date is entered, I need the cell to go back to clear. Help!!! I'm out of time and am not that familiar with Excel!
|
| File download for Excel | 25 Sep 2007 02:30 GMT | 2 |
All, I'm having a problem downloading files to Microsoft Excel 2003. It gives me the option to open or save the file, the next screen is the file download screen. It stays on that screen without downloading. That screens has
|
| find and return adjacent value | 25 Sep 2007 01:26 GMT | 2 |
How would I do the following using a formula: Find the row that contains value X, then in that row find the cell that contains value Y, then return the value to the immediate right? Example:
|
| Sorting a Protected Worksheet | 25 Sep 2007 01:11 GMT | 1 |
Does anyone know how to allow sorting in a protected worksheet that has locked cells? Thanks!
|
| How do I lock a cell in Excel after a drop down list entery | 25 Sep 2007 01:01 GMT | 9 |
I have created a spreadsheet in which I have several "drop down lists", I would like to lock the cell once a selection from the drop down list has been made. This is to prevent any changes by others who will have access to the spreadsheet. Any suggestions would be helpful... ...
|
| PDF to Excel | 25 Sep 2007 00:56 GMT | 3 |
Any body know of an easy way to convert PDF files to Excel?
|
| Email *not* as attachment from Excel 2007 | 25 Sep 2007 00:42 GMT | 2 |
I checked the Help, and it tells me to add Send to Mail Recipient to my Quick Access Toolbar, which I did, and it stays ghosted, so I can't actually use it. The Knowledge Base seems to think it's because I'm not using Outlook, which I am.
|
| Why doesn't Excel save everything? | 25 Sep 2007 00:29 GMT | 1 |
I am working with a large Excel file (over 2000 lines and 20 columns) that is shared by at least five users in different offices who are likely running different versions of Excel. We are frustrated by the fact that it often seems like saved data is missing. For example,
|
| incrementing numbers with preceeding zeros | 25 Sep 2007 00:25 GMT | 8 |
How do I get incrementing numbers with prececing zero's. e.g. 001, 002, etc. e.g for printing ticket numbers. I can't find a cell format that suits. Is there a format or formula. I can't do it in page no's in word either.
|