| Thread | Last Post | Replies |
|
| Printing macros | 20 Oct 2006 16:29 GMT | 4 |
I have number of macros in my files PERSONAL.XLS. Is there an easy way to print them out to file or paper Thanks pcor
|
| Scenario Permutations | 20 Oct 2006 16:12 GMT | 3 |
I am trying to work with Word Data, in Excel, whereby I would like to take a certain situations and generate different permutations. For example, category is Deposit a check and the action is Deposit a check to a savings account, or checking account, or MMA, or CD etc.
|
| Can't separate formula parameters with a comma | 20 Oct 2006 15:36 GMT | 2 |
I have a very weird problem. For some reason I cannot call any functions that require more than one parameter, because office doesn't like the comma between the parameters. Even though a comma is what you must use
|
| Add text to begining of cells within a range based on specified criteria | 20 Oct 2006 13:47 GMT | 2 |
I need to select the contents of a cell based on the contents of another cell and then I need to add that text to the begining of other cells until I reach the destination cell.
|
| Colouring locked cells | 20 Oct 2006 13:06 GMT | 2 |
I know this is probably a very basic question, but I just can't work it out. How do you set cells to automatically turn a certain colour when they are locked? I want my locked cells to be a light blue colour. Thanks
|
| how to remove multiple @ signs from email? | 20 Oct 2006 06:03 GMT | 1 |
i am new user. Currently there is email addresses in col. a, but sometimes it does not contain valid email id's, how can i remove those invalid email ids (containing no @ sign, or containing @ sign twice, contains a : or / ) how do i check to see whether they are correct?
|
| Combining Totals of like Items | 20 Oct 2006 02:08 GMT | 1 |
I am working with a multiple sheet Excel workbook. I have multiple inventory items and would like the totals of items with like UPCs and lot codes. I have many instances where items may have similar UPC but different lot codes. It is important that these items be segragated by
|
| Two points with same (X, Y) coordinates in Excel | 20 Oct 2006 01:41 GMT | 1 |
Greetings, everyone. Is there any way to have Excel draw a circle around a point on a scatterplot? I ask because I have two points with the same X and Y values, which is causing one of the points to hide under another. Thank you for your help.
|
| Excel 2003 - column widths | 20 Oct 2006 01:25 GMT | 4 |
I just came from Excel 2000. My existing spreadsheet won't hold it's column widths when I deselect the 'show formulas' option. Can you help me? I am using XP.
|
| Basic question on Freezing Row 1 | 20 Oct 2006 01:16 GMT | 1 |
I don't understand why when I highlight row 1 and go to Window and select Freeze Pane, rows 1 - 9 Freeze, I only want row 1, why would this be? Any help is certainly appreciated. Thank you
|
| Pivot Table Question | 20 Oct 2006 00:33 GMT | 3 |
I have a pivot table that looks a bit like this Month Measure Jul-06 Aug-06 Sep-06 Income 20 30 40
|
| Pasting fractions from Word; changing into dates | 19 Oct 2006 23:36 GMT | 2 |
I am trying to paste a row of fractions in a Word table into an Excel worksheet. The column is formatted as Fraction. But every Paste and Paste Special I try puts these in and converts them to dates! Is there any way around having to type these in by hand?
|
| Draw Cube using excel | 19 Oct 2006 23:15 GMT | 10 |
Is there any way to use excel to draw cube based on length, width and height. I tried using a scatter graph but was only able to adjust width and height and could not figure out how to change length. I feel I have reached the limits of my math ability. I am trying to visualize the
|
| Update data in Excel | 19 Oct 2006 23:12 GMT | 5 |
I have two reports in Access one is and output to and the other is exported. I am trying to figure out which one to use so my columns (data) will be updated when the user clicks the automated button. I noticed the export to excel does not update but the output to does. I have two ...
|
| IP address | 19 Oct 2006 22:10 GMT | 6 |
how I can fill in columns the IP address from 192.168.1.1 to 192.168.1.254 Thank you. Cheers
|