Recent content by willhyde

Thank you both.

Hi, is there a way of having a cell in Excel always display the current date, preferably in a dd/mm/yy format? Ideally this would refresh each time the workbook is loaded so it is always correct. Cheers.

Hi, is it possible to edit the drop down URL list in Mozilla? I want to erase certain entries but not clear all. Thanks.

Word '97 has this option too, Thank you!

Hi All, is there any way to print tracked changes? Word 97 automatically prints out the 'correct' version of a document but I would like a hard copy showing what was deleted etc. Cheers.

I have (had) a doc named CSC.doc saved in one folder, and another doc also named CSC.doc saved in a different folder. Both docs were open simultaneously, and I inadvertantly saved one as another (essentially I now have the same doc saved in two different folders). Is there any way of recovering...

on excel 97 i have a colum of mixed upper and lower case letters can anyone please tell me how to convert it all to upper case. Thanks

xlbo - that's what I've been doing, it's more for aesthetic reasons while inputting data, just wondered if it was possible. Cheers for the suggestions though.

Ah weel, thanks for trying!

Hi all, Is it possible to freeze more than 2*2 panes in Excel (97)? For example, I want to be able to see Columns A and B on the left at all times, and columns X and Y on the right at all times, while being able to scroll left and right through columns C-W in between (and freezing Row 1 at the...

Excellent, that's exactly what i need. Many thanks, Will.

In Excel, when a cell is selected, the row and column headers are highlighted by going bold, so you can see which row and column you are in. Is there a way of actually highlighting the entire row and column of a selected cell by changing their colour? i.e. when E6 is selected, all cells in...

I have a form which is larger than a single screen, and the scollbars work fine to navigate up and down it, but the scroll wheel on the mouse moves between records rather than up and down the form. In Design View the scroll wheel works ok to scroll up and down the screen. Anyone know how to...

I have a list of addresses in cells A1:A200 in the format 66 Any Street, Somewhere, ABC123 and in cells B1:B200 the response to a question - 'yes', 'no' or 'don't care'. I need to count how many people who live in "Any" street said "yes" to the question. I suspect I need a...

Works fine - much appreciated, thanks. Will.