| Thread | Last Post | Replies |
|
| determine if date range falls within date | 06 Sep 2006 19:35 GMT | 1 |
Ok, this one is driving me crazy! Seems like it should be simple, but no luck so far. Here is what I've got: a2 start date 2/10/06
|
| Cell Reference Formula Outside Workbook | 06 Sep 2006 18:37 GMT | 1 |
I am trying to reference a cell outside of my current spread sheet. I am using a cell in my current sheet as an input for the extension of the file I would like to look in. So I have this defined as LINK. And the value of link is something like C:\\Myfolder\ready.xls
|
| .jpg or .bmp into faceid | 06 Sep 2006 18:28 GMT | 1 |
Is there a way to make my own faceid? Can I turn a jpeg or a bmp into a faceid? It would be sooooo cool... Thanks,
|
| Autofilter - SUM | 06 Sep 2006 18:20 GMT | 2 |
I'm using one excel document with Data >- Filter >- Autofilter function. I'd like to put autosum command but it doesn't work with autofilter's columns. Please help.
|
| Filter mode | 06 Sep 2006 17:53 GMT | 1 |
I have a worksheet with autofilter set to on. In the bar just above the taskbar, on the far left, I notice that it says "Filter mode", and if I right-click on that I can select options Average, Count, etc.
|
| Bypass New Workbook pane | 06 Sep 2006 17:51 GMT | 2 |
Excel 2003. Is there a way to bypass the New Workbook pane when opening templates on this computer. So you would just click File, New and it would open the Templates window at once. If not, is there a way to have more "recent" templates in the New
|
| Filling in a column with text | 06 Sep 2006 17:48 GMT | 3 |
I tried doing some searches on my problem, but it is so hard to summarize in a few keywords. The subject, above, is not very accurately descriptive, either. Here is my issue:
|
| Checkbox Problem on Locked Worksheet | 06 Sep 2006 17:31 GMT | 5 |
I am having a problem on a worksheet I created to track employee time. The problem is with the checkboxes. The employee can check the boxes, and you will see the days field at the bottom automatically update. With the sheet protected, the checkboxes go crazy. If you play with
|
| Paste Special | 06 Sep 2006 16:27 GMT | 2 |
Sometimes when copying data from one spreadsheet to paste into another, I get a different "Paste Special" dialog box that seems to be treating the data as an Object or Picture etc. (rather than the "normal" dialog box which offers the options of 'Values', 'Formulas' etc.). I've ...
|
| I do not have the List-create a list option on my data toolbar ?? | 06 Sep 2006 14:10 GMT | 2 |
I am trying to arrange my data in a list and I do not have this opition on my data toolbar
|
| faceid on menu bar | 06 Sep 2006 09:43 GMT | 1 |
Hello. How can I add a FaceId to a new popup on the menu bar? Thanx, Albert
|
| Excel VBA/Macro programming for beginners | 06 Sep 2006 06:29 GMT | 9 |
I know a bit VB 6.0 programming. Will it help me to write exce vba/macro(same thing?).can anybody help me by providing some fre websites where i can have informations/codes for VBA/macro. Please tell me how could i make a *command Button * in a cell in th
|
| Is it possible to get text values in a pivot table? | 06 Sep 2006 05:03 GMT | 2 |
From this: ROW COL VAL A HD1 X B HD2 Y
|
| Count weekdays from NOW() to a future date. | 06 Sep 2006 02:19 GMT | 8 |
Is there a formula I could use to count the number of weekdays from today until a future date? If I use DATEDIF I can get the number of actual days, but I'd like to get the number of weekdays from today (i.e. NOW()) to a future date, say December 13th, 2006. Can Excel do ...
|
| Make the #N/A invisible | 06 Sep 2006 00:06 GMT | 5 |
I have specified some formula in my Excel worksheets. But, when the cells are empty(with no data), it shows this sign #N/A in the cells. How I could make it invisible so that when a user print the sheet, it will only display the cells that contain data?
|