| Thread | Last Post | Replies |
|
| NOW() help in xl could use some | 27 May 2008 09:49 GMT | 1 |
may seem small enough of a suggestion, was a major problem that did not know how to ask / never could get a correct answer. problem: need to be able to figure if input was over "x" hours old, by date/time in column, from NOW(). using HOUR() in a formula finally figured
|
| How do I show the current month in a date field? | 27 May 2008 09:23 GMT | 5 |
I wish to set an automatic update for the MONTH in a date column in a monthly expense worksheet, so those date fields will change each time I open the worksheet. Is there a way to do this in Excel 2007?
|
| get HOUR check from NOW() cell | 27 May 2008 09:21 GMT | 5 |
hi, not good with date, times, cannot get out of help, want to test for cell is x hours past cell that has been updated with NOW(). e.g.: cell M9 with NOW(): 2008-05-27 2:00:00 AM
|
| Merged cells/wrap text | 27 May 2008 09:16 GMT | 1 |
Entering long amounts of text into merged cells and have chosen the wrap text option. However part of my text is being cut off, even if I manually resize the cell it still gets cut off - any idea why?
|
| Validation Filtering | 27 May 2008 04:04 GMT | 1 |
I want to use a drop down menu in a cell that will look up a list that will have different categories in it. My question, can I filter these categores in the drop down menu : i.e Paint (cat name)
|
| sheet tabs cannot be seen | 27 May 2008 02:36 GMT | 2 |
On worksheet, sheet tabs disappear from view, - in normal view or any other view. Horizontal scroll bar is ticked. If I click on Full screen view I can see the sheet tabs, but not the toolbars at the top of the page. Any suggestions please?
|
| Dual Sided Printing | 27 May 2008 02:02 GMT | 4 |
How do I print a workbook dual sided? I've got a large workbook, 30+ pages and I'd like to print dual sided since my HP L7590 all in one will allow me to. Help Please.
|
| HELP ! Can Excel automatically do "Grouping"? | 27 May 2008 01:34 GMT | 1 |
I have excel data, which I want to group by a number of conditions. I know I could do this automatically in Access, but is there a way to do this in Excel ? Pivot Tables might do this, but the only problem I face is that I need the
|
| freeze pane: freeze from two worksheets? | 27 May 2008 01:17 GMT | 4 |
is it possible that when you freeze panes, the left part frozen is the part from let's say "worksheet 1), but then the left part is from any worksheet you click? i'm doing a summary which involves categories, so i had to make different
|
| disable key combination | 27 May 2008 00:09 GMT | 2 |
i have a tempalte, that works but has one flaw. users can use the ctrl c or ctrl x to copy or cut from one cell to another. when this happens, the formatting that is used to reference the cell formulaes is lost. is it possible to disable the key combinaiton CTRL + C or CTRL + V ...
|
| all General formats of the workbook changed to date format suddenl | 26 May 2008 21:24 GMT | 1 |
i'm working with excel 2007, did not change any definition of the style, and susddenly all the "General" formats of the workbook changed to date. my range includes several types: Dates, numbers, general... only the general formats changed into date. i can not change the whole ...
|
| Update values in WkBk1 from WkBk2 | 26 May 2008 21:19 GMT | 1 |
Trying to update cells in Workbook1 from Workbook2 based on a match between values in Col A in both Workbooks. The value of Col B IN Workbook2 is to be added to the value in Col O in Workbook1 for each match. Seems simple. Easy in Access as a query but Excel syntax is very ...
|
| Error: The macro 'FreezeHeader' cannot be found | 26 May 2008 21:11 GMT | 1 |
When I go to Windows -> Freeze Panes, I encounter this error. Any idea on how to solve it? Thanks.
|
| thanks mike and gtvto6 but still stuck ; | 26 May 2008 20:57 GMT | 2 |
 Signature im entering serial numbers digits leters and numbers ,but for some reason it seems to calcualte it ,when i change the formatting after i enter on what ive written it turns into hash marks;######### ,,alternatitively the other way
|
| received excel spreadsheet by e-mail, howd i open without excel my | 26 May 2008 20:08 GMT | 1 |
 Signature Totconfus
|