Excel 2007 help
This query is : Resolved
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
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
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.
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.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- GST REFUND ISSUE ON PURCHASE OF PLANT AND MACHINERY
- WRONG GSTR7 ENTRIES ACCEPTED ERRONEOUSLY
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
