Queries - Excel 2007

Hello mr. anil,

regarding ur first question u can split the worksheet got to window - split, just select area which u wanna to split before splitting,& then window - remove split (when u want to remove)

second question

just copy that cell which have link from another worksheet, & then paste the same cell at that same place,by right click, paste special- values-ok.

ALL YOUR QUERIES ENDS HERE :

/community/display_com.asp?np_com_id=1927

THANKS
 

As asked in question (1) if you are working in MS Office 2007, just click the 'View' menu form Menu pad and find the split button and give a click and that's it.