| Thread | Last Post | Replies |
|
| Change Excel Column Headings from A,B etc to names? | 22 May 2008 18:34 GMT | 2 |
I want to import an excel csv file of e-mail addresses ito googlemail but I do not know how to change the column headings from A, B etc into name and addres etc column headings which google will accept
|
| Excel 2007 3 Traiffic Light Conditional Formatting | 22 May 2008 18:31 GMT | 1 |
Does anyone know how to get this to work using the 3-light conditional formatting in Excel 2007 using the reference to another cell? I need it pretty much the same way as listed above, but it is not working for me. Here is the set up I currently have.
|
| Macro not running anymore | 22 May 2008 18:01 GMT | 2 |
I use the following macro and it used to run fine - until yesterday. Then, I had to manually stop it (using the windows task manager). Now, t's not working anymore. Well, it seems as if it's still working, but the output file is not created.
|
| Check for hyperlink | 22 May 2008 18:00 GMT | 2 |
Is there anyway to check if a cell contains a hyperlink? Regards Jan
|
| Excel at Work | 22 May 2008 17:59 GMT | 2 |
How do you make it to where you can insert data onto one of the worksheets and if you copy and paste to another and then go back and update it on the original and it automatically changes it on the other worksheets
|
| In Excel 2007, how does one view horizontal and vertical rulers? | 22 May 2008 16:59 GMT | 2 |
When I try to click on rulers (it is checked but grayed out), I cannot get my vertical ruler or horizontal scroll bar to appear. What am I doing wrong? Thanks!
|
| Printing inventory | 22 May 2008 16:41 GMT | 4 |
I have an inventory sheet that I use for reordering parts,I only want the items on the sheet with a number to print. I can make it print just the items needed but they are spread out over multiple pages ( some with a single item) when printed. It probably is simple but beyond me.
|
| Excel 2002 copy multiple rows to another worksheet | 22 May 2008 16:38 GMT | 5 |
I have a database with 2000 rows of data, I want to copy and paste 25 non contiguous rows to another worksheet. I select the rows I want and when I press copy I get an error message that you connot copy multiple rows. Is there a work around method I can use so I do not have to ...
|
| Excel workbook | 22 May 2008 16:32 GMT | 4 |
I have created a workbook with around ten worksheets . I would like to know if it is possible to set print guidlines so that when i with to print of the work book it only prints the work sheets i require. ie instead of printing all ten only print 4 of them. if it is can it be ...
|
| Color Index Code, is there any thing like that? | 22 May 2008 13:56 GMT | 3 |
I have a question regarding the color in Excel. In normal time, if I want the negative number shown in Red color, then I will formate a cell with【#, ##0;[Red] (#,##0)】. My question is that what happen if I want some other color apart from the mainstream color (e.g black, green ...
|
| copy vanishes | 22 May 2008 13:41 GMT | 2 |
I copy something from a workbook. Then I close that, open another workbook and try and paste but the stuff I copied has vanished. It's gone completely. I can't even paste it to word or anything. What happened?
|
| Automatic Calculate Does Not Work ! | 22 May 2008 05:39 GMT | 3 |
This happened to a spreadsheet that i used very often once. A formula which has link to cell in in other sheet suddenly does not auto-calculate after i changed the input value in other sheet. I got to select the cell with formula and press F2 to force it update the calculated
|
| How make cells defaulted to zero | 22 May 2008 05:04 GMT | 1 |
Have a data set with many blanks. How can I make these blanks read as zero, rather than blank. Currently done by hand... Maybe automate a macro?? something must be easier.. Thanks for the help....
|
| Visually Surpressing A Macro | 22 May 2008 02:26 GMT | 4 |
I run Excel 2000 I was wondering if there is some code that I can use to visually supress a macro when it runs. When I presently run a macro that initiates a number of various tasks the
|
| If Statement - no idea where to start! | 22 May 2008 00:51 GMT | 4 |
I'm trying to develop a formula to calculate a sales team incentive bonus. A bonus amount is calculated based on sales made, but then is adjusted 3 months later based on the criteria below. Less than 50% of sales still on the books 0% payable
|