| Thread | Last Post | Replies |
|
| Data series conversion | 16 Mar 2008 12:21 GMT | 2 |
I need to multiply a complete column of data. I don't need to keep to original data only the results. I've been using a new column and then cutting and pasting the data back to it's original position. Is there a method of doing this that will just overwrite the original data ...
|
| Recipies of South INDIA | 16 Mar 2008 06:42 GMT | 3 |
Do you want to know to how to make mouthwatering,spicy foods? If you want to know how to make delicious South Indian foods please visit http://recipesoftamilnadu.blogspot.com/
|
| Freeze pane issue | 16 Mar 2008 04:31 GMT | 2 |
This should be easy but it seems to be confounding me. I am using Excel 2007 and I want to Freeze all row above row 8 (so the always remain visible as I scroll down). I select row 8 and select View and Freeze Panes my only option seems to be to Freeze the Top Row, and that is
|
| Learning VB for Excel | 16 Mar 2008 01:52 GMT | 10 |
I am brand new to this group and could really use some advice. I consider myself to be about an intermediate level Excel 2003 user (that's the only version the company I work for uses). I have no programming experience. I've been told that I need to understand enough Visual ...
|
| Conditional Formatting | 15 Mar 2008 20:42 GMT | 3 |
I'm new to conditional formatting, and only have Excel 2003. I don't have a problem getting my 3 desired rules entered and functioning. Red if a value <800
|
| When any cell in row 19 (eg K19) equals X I want the cell in row 25 3 cells before K19 (i.e. H25) to eqaul Y. | 15 Mar 2008 20:34 GMT | 2 |
Any tips will be greatly appreciated. Cheers!
|
| Column alignment | 15 Mar 2008 19:05 GMT | 1 |
I've been asked to design a "ticket" in Excel (Office 2000) which has quite a lot of pre-existing text, and several boxes which the person issuing the ticket must fill in. Some of the boxes will contain formulae which will be calculated based on the numbers that the user types in ...
|
| Date Formatting | 15 Mar 2008 18:09 GMT | 7 |
Please can somebody help me. I need to disable date formatting in Excel 2003 & 2007. Excel's "helpfullness" is being VERY unhepfull at the moment. It is changing my style codes to dates, and if you format the cell to text then it applies
|
| Printing names | 15 Mar 2008 17:08 GMT | 8 |
There is a View option to see formulae, so I can print the formulas. What about names? I can write code to list the names, put I'd rather print with names displayed.
|
| how to use the function sorting in excel | 15 Mar 2008 17:08 GMT | 2 |
can you help me on how to use the function sorting in excel. thank you
|
| Conditional Formatting - Date Initiated | 15 Mar 2008 16:19 GMT | 6 |
I have the sum of £900 in cell D4 (and other cells with sums) which I want to read zero on the 1st March 2009. Is there a formula I can use to return a cell to zero on a specific date? TIA
|
| locating duplicate records in a 300,000 record file | 15 Mar 2008 16:03 GMT | 6 |
I previously had help with writing a macro to eliminate duplicate records, and it worked great which told me there are two duplicate records. Now I need to quickly identify them. There is one column of numbers, sorted in numeric order. I just need
|
| open excel | 15 Mar 2008 15:43 GMT | 4 |
whenever I open excel the new workbook has 2 sheets named as sheet 2 and sheet3 why not sheet1 and 2 and 3. afd
|
| Excel 2003 / Windows Explorer (XP) sort order differs - How to fix? | 15 Mar 2008 13:32 GMT | 7 |
In Excel 2003, mpeg2_MP@H1440_1280x720p_29.97fps_CBR_40Mbs_openGOP_zzscan.mpv comes before mpeg2_MP@H1440_720x576i_25fps_CBR_45Mbs_closedGOP_alternatescan_LFF.mpv
|
| Merge adjacent columns? | 15 Mar 2008 13:31 GMT | 1 |
Using Excel 2007, I have three text columns right next to each other. Can I merge these three columns into one? Thanks.
|