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
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Inventory of finished goods
- Applicable TDS rate for sale of property in Nov 2024
- RCM INVOICING FROM NOV-2024
- GST Regis.
- Can we claim ITC of Feb-2024 in the month of November-2024 which was not claimed by oversight
- Sale of property furniture sale
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
- Regarding einvoice taken on nil rated sales
- Strategical investment in Public listed company
Trending Online Classes
CAclubindia
