Very quick Q..in excel how do u stop the Autofill(thing where u can copy formula down using that little black square in the corner of a highlighted cell) from changing the references where it gets the data..eg in a vlookup formula it keeps moving the table reference when i Autofill..
If you have to fix the reference then put a $ in front of the reference

$A1 will lock column, but not row
A$1 will lock row but not column
$A$1 locks both

Wich is better.Please give details
For programming and everything Linux.

RUN LINUX LIVE without committing yourself !

Linux is now in a position of offering a viable alternative to proprietary platforms and more than capable of offering a full desktop experience.

There are two worth taking an immediate look at and both use the GNOME Desktop Environment being Linux Mint 6 and Ubuntu 9.04 and both are very easy to use.

Linux Mint 6 Release notes
http://www.linuxmint.com/rel_felicia.php
Ubuntu 9.04 Release notes
https://wiki.ubuntu.com/JauntyJackalope/TechnicalOverview

Linux Mint 6 Download
http://www.linuxmint.com/edition.php?id=31
Ubuntu 9.04 Download
http://www.ubuntu.com/getubuntu/download

If you like either of them

Linux Mint 6 installation tutorial
http://www.howtoforge.com/the-perfect-desktop-linux-mint-6-felicia
Ubuntu 9.04 installation tutorial
http://www.howtoforge.com/the-perfect-desktop-ubuntu-9.04

You download the ISO. image of either Linux Mint 6 or Ubuntu 9.04 then you need to create a Bootable CD from the ISO. This can easily be done using Nero Burning ROM or similar software. Linux Mint 6 and Ubuntu 9.04 can also be run straight from the LiveCD you have created without touching your Hard Drive.

Screenshot of my custom LiveDVD of Mint 6 running Beryl 0.2.1
http://s266.photobucket.com/albums/ii256/Linux_Ubuntu_geek/?action=view&current=Screenshot-1.png
Screenshot of my custom LiveDVD of Ubuntu 9.04 running Beryl 0.2.1
http://s266.photobucket.com/albums/ii256/Linux_Ubuntu_geek/?action=view&current=Screenshot.png

Ubuntu has enormous Hardware Support which Linux Mint benefits from as well https://wiki.ubuntu.com/HardwareSupport/ as well as having an enormous amount of User Support and Documentation
https://help.ubuntu.com/community/

Remember you can RUN IT LIVE !

LUg.
>Windows 7 or Linux Ubuntu?

Linux is free. Windows ain't. You decide whether you want to pay for a program that functions just as well as linux. Linux, in my opinion is less user friendly (has a learning curve) and has less support for programs (games, drivers etc.)

If you can't decide… run both. Windows 7 is free (for now) and so is Linux. You can dual boot and find out which one is suited for you.

>Also wich one is better for programing.You know like .html

You're joking right?
All OS's are equally capable of programming. HTML is one of the most basic and universal languages there is.
Better for what? Each does a job. Depends on waht you an to do.

I played with both and both do wnat I want them to do.

Both are undergoing refinement. Windows more so as it is being beta tested, Ubuntu is just being fine tuned.
Widows 7 is not yet a distro, so ubuntu. html can be done in either with equal ease
If you have money then go for windows 7

Obviously I'm on a different computer since mine won't connect to the internet. Anyways, the internet was working fine the other day, but the past couple days it's not working. I'm no whiz with computers so I'm really not sure what to do. There's different networks to choose from and I can connect to a couple but I get connected with limited access and still can't use the internet. Help me?!
You should reset/restart everything…modem, router, laptop…

Hard to say what happened but this will get you back up and connected most times.

Also, if this doesn't work the first time, I repeat the sequence but I also UNPLUG/Remove the battery from my ISP modem and UNPLUG my router as well.

When you call your ISP with problems, they also suggest you go through this list and UNPLUG/Remove back-up battery as well.

by the way, if you've been piggy-backing on others networks, they may have secured them now or the signal is much weaker (they've wrapped/re-directed the signal) hence the limited access response.
That means that your not fully connected to the service. You are connected physically to the connection however you don't have enough access to actually do anything on the service. Check that you have all the correct security information from that service..most of the time if someone has secured the line and you attempt to jump onto their netwrok without the key you will have to enter that key in order to be granted acceess to do anything on that line.

When attempting to jump onto someone elses network check first to see if the line is secured or unsecured.
If you connect but with limited access that means the network you are connecting to is not getting to the outside world

can you really get free ipods with them?
The MacBooks likely won't go on much more of a sale then they already are in the education store. If you go to the Apple store and then just track down the link for the Education store you can find the student price for laptops right now. I don't expect the regular store to sell them for less this summer when the back to school rush happens.

As for the iPods, potentially yes. In previous years Apple has added an iPod to the purchase to sweeten the deal. In this recession year, and with a couple of hiccups they have faced, will they still do it though? That's hard to know and Apple always keeps those things close to the chest. I would kind of expect them too, but I just don't think its a given this year because of what's happened.
they wont go into much of a sale and i dont know about the ipod with them

Thanks in advance for your answers and best answerer gets 10 points.
I have used AVG Anti Virus, Zone Alarm Firewall, I have recently added superantispyware and Malwarebytes. They are all free for personal use and I have had no trouble with Viruses Trojans Hackers etc. I have just upgraded to AVG free 8.5 and all seems good so far. Zone Alarm allows a lot of personal configuration unlike the Windows Firewall. They can all be downloaded from http://www.download.com/ I also use Windows Defender from the Microsoft site. It is safe to use two anti-spy products but never use more than one A/V as it can cause conflicts. You should run A/V and anti spy weekly. Hope this helps
Yes. Nobody would use an anti-virus if it didn't give frequent updates of all recent viruses, even if it's free.
It should
yes

I want images to resize and fit inside my table cell.

Example, my table cell is 200 width by 100 high, I want my image to fit inside but NOT resize to 200 by 100, this would difform my image.

I want my images to fit proportionately inside the cell, meaning that it will keep the same proportions it have, only it will not overflow nor resize the cell.

How can I do this ?
<html>
<head>
<script>
function autoSize(i) //to within table cell;
{
(i.width/i.parentNode.width) > (i.height/i.parentNode.height) ?
i.style.width = "100%" :
i.style.height = "100%"
};
</script>
<style>
table{ table-layout:fixed; overflow:hidden }
td{ overflow:hidden; padding:0 }
</style>
</head>
<body>
<table>
<tr><td width=200 height=100>
<img src="buddhagold.png" onload="autoSize(this)">
</table>

this works in both Firefox and I.Explorer
</body>
</html>

my vista pc's screen display changed after i unplugged a kvm switch ( used to conect 2 pc's to 1 monitor) now i have black vertical spaces on th left and right of my screen and my browser window also wont stretch to use all the 20" monitors space…how do i change this so all the available viewing space on the screen is used again??
There should be some buttons on the bottom of the screen and if possible use auto adjust if there is no such button then press the button called menu or osd and use that to change the x spread and y spread they may be called something else and play about with those settings until it fits the screen.

looking for a refurb aroound £250 but dont know the difference

does this look ok?

http://www.laptopsdirect.co.uk/Grade_A2_Acer_Aspire_5720_Laptop_A2-LX.AJS0X.090/version.asp
It obviously depends on what you want to use it for but for the money it is a very good deal.
Processer speed of 2.2 ghz, 160gb hard drive and 2 gb ram, if you are happy you want it then i'd say yes, good deal
Looked like a good offer, I don't know why it is so cheap but here is a comparison on Pricerunner for the Details they offered at your mentioned retailer page.
http://www.pricerunner.co.uk/cl/27/Laptop-Computers?sort=3&search=&a_662=Windows Vista Home Premium&a_655=gte;160.0&ref=sp&a_656=between;15.0;16.9&a_653=gte;2.2&a_661=PC&a_2547=1&q=acer aspire 5720&a_654=gte;2048&a_652=Intel Core 2 Duo

So be careful with the credibility. Otherwise it is a good offer!

Good luck!
First of I heard acer computers are the lower end of laptops which is why its 250 or something which even so they can be fine for internet and emails, however the only way to tell is use the computer you cant telll whats wrong with it or anything just by looking. Lastly, just keep in mind if you want a somewhat decent computer you really shouldnt be spending less than 800 and thats the bare minum stuff.
the CPU is quite fast for a laptop. 2.20 GHz thats good and so is the 2gb ram and 160gb hard drive for a laptop. im not sure about the graphics but i wouldnt reccomend getting it cause it has windows vista. but you can always reinstall windows xp on it if you kow how.
come with a 1 year warranty so it cant be that bad i would go for it
If that's all you're using it for then yeah
**** no
yes
its fine

When is the final release date for Vista SP2 RTM? It was said that it would be released in April 2009, but only RC is available. And also will it update to the RTM version if i install RC now?
Windows Vista SP2 release date slips
Microsoft has delayed Windows Vista Service Pack 2 (SP2) by at least a month, and will now ship it to manufacturing sometime in May or June, according to a website that has accurately predicted Windows release dates in the past
http://news.softpedia.com/news/Vista-SP2-RC-in-February-RTM-in-April-2009-98560.shtml

take a look at Stanza. its an ebook reader that can read tons of formats, including PDF.