| Thread | Last Post | Replies |
|
| Select filled region only in non-adjacent columns | 19 Aug 2007 15:38 GMT | 1 |
I have just selected the non-hidden cells in several non-adjacent columns. Now I want to select these columns only from row 1 to the maximum occupied row. How do I do it?
|
| One Last Newsreader Question | 19 Aug 2007 15:07 GMT | 7 |
I'm using Outlook Express for a newsreader. Is it possible to get it to show me messages only on or after a certain date, or for a certain range of dates? This would be a great help. I promise this is my last newsreader question (for a while)! TIA, James
|
| Linked cell shows formula | 19 Aug 2007 14:16 GMT | 4 |
I want to link to a cell on another worksheet in the same workbook. Instead of the value of the first cell showing in the second cell, the formula from the first cell appears in the second cell. What am I missing? Thank you.
|
| using vlookup to lookup a formula | 19 Aug 2007 13:45 GMT | 2 |
I trying a use the vlookup function to look up a couple set of formulas used to calculate the cost of my list of items. How Can I get the vlookup to read the formula and not the value of the formula? If it helps here is one of the formulas if it helps
|
| copy only filtered range. | 19 Aug 2007 13:41 GMT | 1 |
i'm using filters in 2007, then i select range inorder to copy only the filtered. but actually it copy the full list. in other computer, with 2003 it works. maybe it is a configrable problem.
|
| How do I repeat characters within a single cell in Excel? | 19 Aug 2007 13:35 GMT | 3 |
I have a left over Lotus 123 file with a cell in which a character or combination of characters will repeat to fill that cell. I have forgotten the key strokes used to create that original cell. I imported that file into Excel 2002, and it works well but the only way I
|
| Automatic refresh of pivot tables | 19 Aug 2007 12:34 GMT | 2 |
I am looking for an automatic procedure to open a file (excel 2003), refresh all pivot tables (olap cubes) and save it. thanks
|
| How Excel deleted sheet(s) can be retrieved | 19 Aug 2007 12:13 GMT | 1 |
I have in fact two questions. a) By mistake two sheets of Excel (out of three) have been deleted where we had our office records. Inspite of using "Find" option for certain dates did not solve the problem. The data is not retrieving.
|
| Rounding UP Months' Difference between 2 dates | 19 Aug 2007 10:29 GMT | 1 |
Hi every1 I want to calculate the number of months between two dates. Datedif() may be used but upon a difference of less than 15 days it rounds off the balance to 0 months.
|
| Need to trigger a warning, if any cell in a column exceeds two | 19 Aug 2007 07:02 GMT | 2 |
I need to have Excel give me a warning message on worksheet 2 ("Monday"), if any cell (19-76) in column AH, on worksheet 1 ("Roster") exceeds 2. I thought that this would work, but it doesn't: =IF(Roster!AH$19:AH
|
| Why does 'non-commercial use' appear after Small Business upgrade? | 19 Aug 2007 03:09 GMT | 1 |
I've upgraded from MS Office Home & Student to MS Office Small Business, but Excel and Powerpoint are still headed 'non-commercial use'. I don't want this heading to appear as it looks unprofessional. I thought upgrading to Small Business would remove this heading to Excel ...
|
| All worksheets will not print | 19 Aug 2007 02:18 GMT | 1 |
I have created a workbook that has 18 worksheets in it. 4 of these receive linked totals from the other 14. However, when I go to print the entire workbook, only the first 14 will print. I have even selected just the four worksheets by themselves and they will not print. When ...
|
| Keep relationship between 2 cells that both accept data | 19 Aug 2007 02:04 GMT | 2 |
I swear I saw someone who posted a trick to accomplish this... I want the value in cell A1 to always be twice the value in A2, but I want to be able to enter data into either cell (not a formula). For example, I type a 2 in cell A1 and A2 returns a 1. I then type 3 into
|
| Length of data displayed in text fields | 19 Aug 2007 00:56 GMT | 2 |
If it possible to display the data selected in the text field, when the mouse points to it? Same as we have in html, when we put our mouse on some link it shows us the desc for that link...
|
| Office 2007 Copy Paste Issue | 18 Aug 2007 21:38 GMT | 5 |
I wrote a macro in Office 2003 which does the following task. In a data Sheet names Total2, it filters Colum 2 using a keyword and then copies only the filtered data onto a new sheet called Calculation.
|