Search results for query: *

We have a document that has been amended by two people, therefore set by author. However there is a third colour, which appears when you insert a new paragraph, the number (style) appears in a different colour. I have looked into all the settings but cannot find anywhere that adjusts the...

Very strange, it doesn't happen in all our offices but while here in Hong Kong the secretaries have said it is happening to them with all documents. It is like it is jumping to a bookmark but I cannot see any, apart from the usual and they can be anywhere. Any ideas?

I am looking to create a Form in Word that you cannot go to the next field (eg tick box) until you have completed the previous one. Does anyone know if this is possible. Many thanks

Does anyone know a way in which you can highlight specific cells that contain a word. For example I can use conditional formatting to highlight cells containing the word Tuesday, but if the cell contains 'today is Tuesday' it won't work. Any suggestions?

I am trying to do the following and getting an error message, I am guessing brackets in the wrong place but am completely stumped. Can anyone help please? =D6-(D10:D12)

I know I have read before there is a repair you can run, but I cannot locate it anywhere. When we create a Chart (on some PCs) in Office 2003 we get the Microsoft error message and you get stuck in a loop. Does anyone have the repair to hand?

I need to count the number of days between two dates over a period of years. This should include weekends, as I need to include every single day. NETWORKDAYS - counts working days COUNT360 - Only counts days based on a year of 360 days. Does anyone know another formula? Many thanks

Hi everyone Recently I enabled the Analysis Toolpack and Analysis Toolpack VBA and got NETWORKDAYS to work. I have just gone back into my Excel spreadsheet, both were unticked, however the spreadsheet example has the formula in there working, but when I remove it and do it again it comes up...

We currently use 2000 but about to go to 2003. I've been doing some testing using Heading 1 numbering (for example in Schedules). We would have a heading Schedule 1 and this would be cross referenced (referring to heading text). This appears fine, but if we later update it, say to Schedule 2...

Someone here uses the control toolbox to create precedent documents. This is mainly for the tick box, and although they could use the basic Forms toolbar they don't want anything locked down. However when other users open the document, they have to click on the Design Mode button in order for...

to send via email (Office 2000). The file size is quite large and the email system is blocking it. Does anyone know the best way of resizinig it. Many thanks

I've been using Excel for years, using Autosum to add up a column and if you insert a new row into that column it will include it in your formula. However it has just stopped doing that (Office 2000), has anyone else come across this at all? Many thanks

I have been asked if Excel is able to work out future dates. For example by putting in the date of an AGM as 5 February, it can calculate the date of 10 business days later (which would be 19 Feb). They also asked if it would also know if there were bank holidays in that date range. I don't...

Can you use a count formula to count how many cells are filled with a particular fill colour? Many thanks

I'm really struggling with this formula. We have a PMT formula, but we need to work out one that says they can afford this much a month, over a period of years at an interest rate and we want the formula to work out how much they could borrow? Any help greatly appreciated.

Has anyone found a way of sorting Outlook folders so they are not alphabetical. I know you can sort them under Favourites but not in the main folder tree.

Apart from file, save as, saving it locally - how do yu password a PowerPoint presentation like you would a Word document?

I have searched below and it appears some people have created a mortgage calculator. I am just after a very simple calculation from the following: Current Value £150,000 Number of Payments 300 Interest Rate 4.69% Monthly Pay £800 I want to find out what fomula I need that if I change the...

I am struggling with an Excel query. I know if you want to work out the interest rate you can do =PMT(B2,B3,B1)/12 which will tell you the amount payment depending on the current value, the number of payments, the rate. I have seen somewhere a calculation where you can put in your mortgage...