What does it mean when someone is knighted?

i know famous musicians like Sir Paul McCartney and Sir Elton John have been knighted but i don't really know what that means. is it some high honor? is it only for musicians/celebrities? or can it be for anyone?