Queries - Excel 2007

1) Please let me know the how to split the spreadsheet and how to remove the split in spreadsheet in EXCEL 2007.
 

 

2)A Spread sheet in Excel 2007 has some numbers which are taken from another worksheet. The link to another sheet still exists. I would like to break this link and just have the numbers. There are many links in one sheet and I want to just have numbers in the sheets without link and I want to do this in one stroke. How to do this?

 

Thanks

 

Replies (4)

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.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details