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
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
- CLOSING STOCK QUERY
- Exiting partner in partnership firm in gst portal
- TDS _Long term Capital Gain ref.sec 214 Table 2
- CASH GIFT FROM BLOOD RELATIVE
- TDS offline utility
- Due Date Clarity
- Can a single LLP in India legally operate multiple unrelated businesses (Travel, Cloud Kitchen, Ecom
- Taxability of credit in canara bank ET & T section (NRO)
- ITR-3 File/Error Found
- Loss of interest in PF transfer from EPFO to Trust
- Query regarding Item 61/62/63 vs Item 64 in ITR-3
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
- TDS on property - Form 141 query
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
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
