Search results for query: *

What a lot of potential work for a simple problem solver. You will need a yellow Post-it and a pencil. Write on the sticker, "Before starting work on an Excel spreadsheet, Press Ctrl - Home" and stick the sticker on your monitor. Actually you could use any colour Post-it!

Assuming that all your rows, where they contain data, have something in every field (column), highlight all your data, turn on the data filter (auto). Click on one of the drop-down arrows and select "non-blanks." This will close up all your data, simply cut & paste to a new location. Once you...

I've had this problem for a while but could not find a solution. Unchecking the Background Printing worked for me as well.

I presume you have created a drop down-list from the control box tool pallete, in which case, there is a set of cells (specified by you when you set up the drop-down) a range that contains the words "Sometimes", "Always" etc., a cell that contains the value 1,2,3....n...

Reason for problem found but problem not solved. It is an issue caused by Zone Labs and the latest edition of Zone Alarm (free). They have not replied to my e-mail but I found out from other sources that they have created the problem during the upgrade. They will not be issuing a patch but we...

Have you tried using the Template Wizard to create yourself an entry form? Check out the help. You may need an add-in before it will work.

Like bkpchs237, I'm not sure exactly what you're trying to do and how you've arranged your formulae but VLOOKUP will do exactly what you say depending on whether you've sorted your data, sorted it up, sorted it down or quite frankly my dear, don't give a darn which way it is sorted. It will...

Thanks for replying Kento. Yes, I've checked (first thing I looked at!) ZA for auto updates and it is set for manual. I ran Adaware (sorry should have put that in my original post) after the problem started occurring and before I ran Adaware, I updated the reference file to 24_09_02. I use...

Well I know this was a while ago but I've only just seen it. I assume that the 76 comes from summing the rows above. I used the following formula in cell B1. =A1/$A$4 which gave 21.05% just by formatting the cell as percentage to 2 decimal places. I then copied it down from B1 to B4. This...

Where should it match the number in column D? Are you trying to find any number in either of the columns C & D? Which number should be transferred to K2. You cannot transfer a whole column into one cell. Do you mean that if the info in L2 = D2, transfer the info from C2 into K2? You don't...

I have a list of what starts up, when I boot. What I don't have is something to point me towards the call for the dial up box. Thanks for trying to help anyway.

Since upgrading to Zone Alarm 3.1.395 my PC has developed the annoying habit of opening the dial-up box at boot up. If I allow it to connect, it does not connect to any specific site, nor are there any bytes sent or received. If I kill the box, processing continues as normal. I have searched...

Use MATCH. Beside your first column (say B1:B50) of figures add the formula in A1 - MATCH(lookup_value,lookup_array,match_type) where lookup_value points to the first number in the master column (B1:B50), lookup_array points to the range of figures in your second column (say C1:C50) and match...

Well they are hidden rows not hidden columns so the advice on unhiding columns won't work. Presumably you've tried highlighting a row above to a row below and going to unhide. Is it the case that the row height has been set to zero as suggested earlier? You can find your data. Simply set up...

Go to HELP and look at a function called FV. This will give you the ability to calculate compound interest monthly, yearly or wheneverly. Read it carefully, it took me a while to work it out but it does work and will do exactly what you want.

Click on the tab for Sheet 1, hold down SHIFT and click on tab for Sheet 2. You have grouped the worksheets togeter. Whatever you type into a cell on Sheet 1, will show in the same cell on Sheet 2. BE WARNED. Do not forget to ungroup when you've finished otherwise all your worksheets will be...

Aslo check out a thread called "Bizzare Windows Error" Good Luck

Also check out a thread "Bizzare Windows Error" Good Luck

!.....an error log is being created." What does it say? Have you located and read it? It might just give us a few clues.

In your slide from where you want to switch, insert an object, preferably an auto shape. If you don't want to see it, make the fill colour and the line the same colour as the background BUT remember where it is or you will not be able to see it during your presentation. Now, with the object...