banner_ad

Excel 2007 help

This query is : Resolved 
Profile Image

Profile Image

(Querist)
01 December 2009 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
Profile Image

Ram Avtar Singh

Profile Image

Ram Avtar Singh (Expert)
03 December 2009 1:

go on view and click on freez pane and then unfreez

2:

copy all you want to remove link click on right button of mouse click on past special and value.
Profile Image

Anil

Profile Image

Anil (Querist)
03 December 2009 Thank you very much sir.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
ARTICLESHIP 04 June 2026
Article

Rakhecha & Co.

New Delhi

CA Inter

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 17 May 2026
CA Article /Trainee

Malik Sunil & co

New Delhi

CA Foundation

View Details