| Thread | Last Post | Replies |
|
| Print | 28 Aug 2007 11:52 GMT | 3 |
When I enter in a cell a formula that results in a FALSE result is their a way to prevent the FALSE result from printing
|
| How to Link Excel to"Contacts" Folder | 28 Aug 2007 11:32 GMT | 1 |
I have an Excel worksheet(table)exported in from Outlook Contacts Folder. Is it possible to link the two so I won't have to enter data twice? Office 2007. I do not have Business Contact Mgr installed. Thanks much for any help. Bob Levin
|
| Copy and paste problem Excel 2003 to Word 2003 | 28 Aug 2007 11:14 GMT | 2 |
I'm trying to copy and paste a block of data 28 rows 17 columns from Excel to Word. Two problems, some of the excel data is lines of an address, and the cells which contain an address like "41 High Street" seem to merge
|
| entering date/time in 1/4 or 1/2 hour increments? | 28 Aug 2007 10:31 GMT | 5 |
Does anyone have a suggestion or template with easiest way to enter date/time in excel for keeping track of project times by the hour? ie. drafting log or simple work log but in hours and not simply days... Thanks,
|
| Lock Picture in Cell | 28 Aug 2007 10:26 GMT | 2 |
I would like to be able to insert a picture in a cell and then lock it there. I know how to lock data in a cell, but I can't figure out how to do it with a picture. All the individual has to do is drag the picture around. The pictures are
|
| Do not count hidden cells | 28 Aug 2007 10:20 GMT | 2 |
Is there any way where you can not add a hidden cell once your data is filtered. I want to add or sum values in a column but only the values which is displayed once the list is filtered.
|
| 1+2+3+4+........... Counter | 28 Aug 2007 10:17 GMT | 3 |
Excel 2007 I would like to add a counter to a spreadsheet (actually several counters) I would prefer NOT to use a macro I would prefer to use an object or a clip art of something so that when I
|
| Formula Based Data Validation 4 Date To Be Inserted | 28 Aug 2007 09:28 GMT | 1 |
I want to put a data entry validation check for allowing a Account Maturity date in B2 less than Now() only if the account balance in D2 is 0, otherwise with a balance in the account a date only after Now() should be allowed. Any suggestions & advices shall be highly obliged.
|
| Protecting selected cells in a worksheet | 28 Aug 2007 09:24 GMT | 5 |
I want to be able to allow others to use an existing worksheet, to complete information, without allowing them to edit or modify certain cells
|
| Drop down list Q | 28 Aug 2007 09:08 GMT | 5 |
My drop down list, when opened for selection, always displays the last half dozen entries, therefore I have to scroll up to find the one I want, rather than scrolling down. Why would this be?
|
| Footnotes | 28 Aug 2007 09:04 GMT | 3 |
How do you enter a footnote in Excel 2007?
|
| How can I format elapsed time as "[mm]: ss" without getting "AM PM | 28 Aug 2007 09:02 GMT | 10 |
I need to format a cell as elapsed time for a run time. For example, I want to use "13:15" to designate "13 minutes and 15 seconds" and use it in an ascending array (VLOOKUP). Right now, Excel makes it into "13:15:00 AM", which doesn't help me.
|
| Importing data in excel 2003 | 28 Aug 2007 08:02 GMT | 1 |
I am trying to put data from multiple excel spreadsheets in to one workbook. The layout of the spreedsheet I want to put the data in to is different to the other workbooks. Is it possible to transfer this data across so that it automaticaly changes it to the layout I need.
|
| Combine COUNTIF & EXACT | 28 Aug 2007 05:21 GMT | 12 |
Trying to find way to combine COUNTIF & EXACT with the following example, that seems to work as is, but need to "EXACT" the same characters. thanks =IF(OR(COUNTIF(AB9:AD9,{"os","p","x"})>0),0,1)
|
| Find earliest date combined with status | 28 Aug 2007 04:14 GMT | 2 |
In column A I have several actions listed. In column B, I have for some of those actions some due dates while in column C I have a status field. Something like this:
|