You can perform BLAST search to find out similarity/identity of your query sequence to database sequences through MEGA software. It has an inbuilt module which can directly access BLAST. See this link for a tutorial:
Depending on the number of sequences, it could be of use to install a local version of BLAST. This would be the preferred route of course, only if you have a large number of sequences.
For a small number of query sequences simply run BLAST on the NCBI servers through this website:
1) Go to nucleotide blast or protein blast at http://blast.ncbi.nlm.nih.gov/Blast.cgi
2) Look for "Align two or more sequences" which does "Enter one or more queries in the top text box and one or more subject sequences in the lower text box. Then use the BLAST button at the bottom of the page to align your sequences."
You can find this kind of pairwise table with CLUSTALW.
After aligning all sequences you can find different results generated by clustalw. One of them will be pairwise comparison and scores of your aligned sequences.
In BLAST (NCBI) you have this option when you can compere your own 2 sequence, in clustalw you can align more then 2 sequences in the same time, but in the summary table you can't find the similarity and identity of sequences only score for alignment. So the best way is use blast and compere the pairs of sequences.
Blast and aligning are the best way to inform yourself about similarities. However, you may also want to know the percentage of conservation. If for example you want to determine any functional properties/implication of a mutation. Such an analysis can be performed on http://bental.tau.ac.il/new_ConSurfDB/
I tried it is very hard to select the sequences and copy them to excel and then to word as in word the table will lose the format and help is appreciated.
Does sequence similarity information conform with phylogram information on the same sequences? I mean if 2 sequences have 90% nucleotide or aa similarity are also placed in the same clade when phylogenetic analysis were done?
yes. In Phylogenetic trees, high sequence identity sequences are clustered together or closely clustered. If the similarity is low then the sequences will be far apart from each other in a phylogram.!