Search results

Hello Hui Sorry for not replying. I've just come back to this, and although I have failed to copy the formula to all the cells first off, I can still copy the first cell, and then Paste Special to all the other cells, and that works. I can't seem to apply the changing colour to all the...

Hello Hui Yes, I understand that's what it should be for each individual cell. What I'm trying to do (sorry, haven't explained properly) is apply the same formula to a range of cells. I don't want to have to change each line of my spreadsheet. Please can you advise on how to do that? Many...

Hello all I just can't seem to get my head round this. I want to do something really simple, and I just can't get it straight. I am trying to compile a list of names. This is the situation :- We have sent out an invite. We are receiving back replies. I want the spreadsheet to show green...

Hello all Very quick post to say thank you, I was snowed under for the last few days! I am off to read the information, looks like I have some work ahead! It might take some time, so I thought I'd say thank you now, and try and sort everything out later.

Hello all I am doing another chart! I've just discovered that what I'm actually doing is an Excel dashboard, which I will be taking a course for next month. However, I'm trying to do some for my boss's next meeting this month, and am stuck. I am trying to link one worksheet to another...

Hello, me again. I'm trying to create a project timing chart. I have had a look at the way this site advises to do them, but have fallen at the first hurdle. I have a table with three columns. The last two columns are labelled, "Start" and "Duration". I did have "End" as well, but it just...

Manuy thanks Hui. I have now succeeded in composing one chart and my boss has now said that he wants another department to take care of the other chart. I still don't see why Excel can't understand what I'm trying to do with the data if I have it in the format I had it, but at least I can give...

Hello Hui Sorry, I have been exasperated and left it for a moment. My only access to the internet is through work, so I have to be very careful as to which sites I go - for example, the usual suspects are denied me, like eBay etc., so could you give an example of a free upload site...

I've now completely stumped myself. I've got the axis to read what numbers I want. However, I still can't get it to show me what the total is for wach month. I can't seem to post this in here either, so I can't show you. I also can't get a sensible graph from another table. I have some...

Hello Hui Yes, that's it exactly. I've just gone in and found how to alter the percentage to read whole numbers. However, the chart can't 'see' the total of people who have called the centre in one month. I have on the X-Axis the months. To keep things simple, I have only figures in...

Hello all I am at that frustrating point of knowing something about Excel but not knowing enough. I would like to create a chart which has :- X axis is the month (to include the whole year) y axis is the number of customers that particular month - also, the column needs to be divided into...

Many thanks, I'm going away to play with these ideas, have a good Christmas all!

Thank you Hui, unfortunately the most important part, protecting the cells, advises exactly the same thing on Microsoft Help. It says to use a password, which I really don't want to do, to prevent the whole "What was the password again? Oh, she's on holiday and we can't remember it" thing. I...

Please can some let me know an easy way to protect cells within a worksheet? I am currently designing a spreadsheet which needs to be passed around several people, and it would be easier if there were no password for them to remember. I'm sure that there was a way of locking them without any...