Easy Office
LCI Learning

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


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.

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

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries




Answer Query