| Thread | Last Post | Replies |
|
| Find worksheet | 23 May 2008 17:19 GMT | 1 |
I have a workbook that is constantly having sheets added. I would like to run a macro where clicking on a button goes to the sheet before "last sheet". Is this possible? Thanks in advance
|
| how to convert number of days to months | 23 May 2008 16:24 GMT | 3 |
Greeting, I have 63 days, the Question is How to convert it to 2 months and 3 days?? Thank You
|
| How do I undo a sort? | 23 May 2008 16:12 GMT | 3 |
I sorted a column A to Z in a very large spreadsheet and saved the file, but I wish to cancel the sort. Is there any way I can do this? Thanks, Teresa
|
| Look up from spreadsheet based on 6 criteria | 23 May 2008 15:55 GMT | 8 |
In Excel 2003, I have a page where my people will put in 6 criteria; Style, Min Sq Footage, Max Sq Footage,# Bedrooms, # Baths, Garage stalls. I need to search thru the plans data base to list the plan numbers that match ( or ><) all 6 criteria. Can anyone please tell me how to ...
|
| Advanced Text to Columns?? | 23 May 2008 15:41 GMT | 5 |
I wonder if anyone can help me (again!) I have an excel sheet which has 500+ rows of data which has come from a database - one of the colums is a size column and has data like the bit below: 3.803 X 3.327 X 0.391
|
| Excel - conditional formatting issue | 23 May 2008 15:36 GMT | 3 |
Hai, I have an issue in Excel 2003 wherein i am not able to highlight cells that contains a particular word, checkout the example below, im looking forward to highlight cells which has "vip"
|
| Date Question | 23 May 2008 15:30 GMT | 2 |
I am finding it very difficult to change a series of American date format to British dates format in Microsoft excel 2003 worksheet. Help.
|
| counts | 23 May 2008 15:28 GMT | 3 |
Can i pull out the count of more than 1000 out of a range of numbers? Please help...
|
| Inserted raster image prints distorted | 23 May 2008 14:51 GMT | 2 |
I am inserting a raster image in Excel 2003 on PC. It looks fine on screen but it prints elongated (by 5% or so it seems). I tried JPEG, PNG, TIFF (all in RGB) with same results. Page Setup ensures adequate margin. To complicate things, 2 printers distort the image more and a 3rd ...
|
| 2003 - 2007 custom macro and custom button restore. | 23 May 2008 14:41 GMT | 11 |
i have a number of macros and custom buttons in Excel 2003 that I would like to update to 2007. How may I accomplish this? Operating systiem is XP Professional. I did use the "Microsoft Office 2003 Save My Settings Wizard" before the
|
| Advanced filter criteria | 23 May 2008 14:37 GMT | 2 |
How can I set up an advanced filter criteria to indicate that I want only those rows that do not have an empty cell in a particular column? EG: LOGONS USERIDS LPAR
|
| Conditional Formatting Colour in a Column Graph (Excel 2003) | 23 May 2008 14:07 GMT | 8 |
I have created a column graph, and I know I can manually colour the columns to reflect their values. I was wondering though if I can get them to automatically colour based on the values being used
|
| Dynamic File Name Problem | 23 May 2008 14:00 GMT | 3 |
The case is: I have created a dynamic graph. It works fine. But today i recognize that the file name which is excel using gets crashed. Let me explain. I have 2 formulas with names one is "stock" and the other is "year". In the
|
| Formatting Date Field | 23 May 2008 13:38 GMT | 5 |
Good day, i have a problem where i have imported some data with dates and time, the problem is i need to modify the time part of the date to a specific time like 18:00:00. The dates came in as follows 05/09/2008 18:00:00 10/10/2008 18:00:00
|
| carriage return in text cell in excell | 23 May 2008 13:27 GMT | 2 |
If I have a text cell, and have formatted as wrap text, how do I enter a carriage return to help make the text more readable
|