How do I stop hidden & protected cell contents from being revealed by a copy-paste operation? Excel 2007?

Excel 2007. I have sensitive data in some cells, which form the basis of some calculations, the results of which can be shared with other users of the workbook.In an attempt to keep the sensitive data private I have hidden the rows and then protected that worksheet with a password. However, if the area in that worksheet with the hidden/protected cells is copy-and-pasted into a fresh worksheet, then all is revealed.

Is there a way to keep the hidden & protected data private?Thanks. Asked by graemewoodward 32 months ago Similar questions: stop hidden protected cell contents revealed copy paste operation Excel 2007 Consumer Electronics > Cell Phones & Accessories.

Similar questions: stop hidden protected cell contents revealed copy paste operation Excel 2007.

Consumer Electronics > Cell Phones & Accessories.

The workbook is hidden and its filename is removed from Switch Windows menu on the View tab. Why Would You Need To Protect A Workbook? There may be times when you want to keep information out of sight and safe from modification.

Imagine, for example, a worksheet that contains static data that is used in calculations. In this situation it's advisable to hide and/or protect the data (and the formulas used, for that matter). It would not useful to the viewer to see this data, as it's only used behind the scenes, and any amendments made to it may corrupt the integrity of the calculations that use it.

Here, it makes sense to both hide and protect. To this end, you can hide windows, individual worksheets or whole workbooks. Ding WorkbooksThere may be times when you want to have several workbooks open and their information available so that Excel may use it.

If you don't feel the need to have this information clutter up your screen you can hide the workbooks that you don't need by clicking View > Window > de in the appropriate workbook. How To de A WorkbookThe workbook is hidden and its filename is removed from Switch Windows menu on the View tab. Once a workbook is hidden, the unhide button becomes available, and is displayed on all open workbooks.

But suppose you have hidden several workbooks and you now click the Unhide button. How does Excel know which workbook to unhide? It doesn't, so it presents a dialog box for you to select the one you want to unhide.In this dialog box, all hidden workbooks are presented.

How To Unhide A WorkbookA word of warning! If you save a workbook whilst it is hidden, the next time you open it you won't see it. This can be very confusing, but is easy to rectify by clicking View > Window > Unhide (as we've already seen).

Protecting WorksheetsTo prevent yourself or others from accidentally changing formulas or other data, you might want to protect your worksheet. To do this, click Review > Changes > Protect Sheet.In the Protect Sheet dialog box, tell Excel what kind of restrictions you want to put in place. For example, the default restrictions allow users to select locked and unlocked cells but prevent users from formatting cells, formatting columns etc. If the action appears in the dialog box, you can allow or restrict users' access to it.

Note that you can enter a password here to password protect your worksheet. Doing so will force the user to enter the password to unprotect the worksheet. How To Protect A WorksheetUnlocking CellsEvery cell has a locked attribute that determines whether you can update its contents when the worksheet is protected.

When you protect a worksheet, all cells become locked. Should you need to make some cells available for update, you can do this by first changing the locked attribute. Select the cell or range of cells you need and then right click > Format Cells > Protection, and then uncheck the Locked check box.

Click OK. Note that this has to be performed before you protect the worksheet. Sources: http://www.msexcel07.com/protecting-workbooks.htm .

Excel 2007. " Complexity and Social Networks Blog of the Institute for Quantitative Social Science and the Program on Networked Governance, Harvard UniversityWelcome! The objective of this blog is to offer a forum for the discussion of the intertwined subjects of network analysis and complex systems theory.

David Lazer, Director« September 2008 | Main | November 2008 »30 October 2008On data growth and growing concernsAre you in favour of more efficient and effective government? Of course you are. If one counted the reasons given most often for any type of government reform, these two would score the highest marks.

It is widely recognised that the characteristics of information and communication technologies (ICT) have strong impact on both. Government was thus among the first to utilise ICT.In the early days, punch-card machines were used for the census, and electronic databases replaced large amounts of data stored in non-digital form (for example, in files) throughout government once the technology was available. Because information drawn from data is at the core of everything government does - analysis, decision-making or verifying eligibility for access to public services, to name just a few - the proliferation of databases, data mining and ICT in general is unsurprising.

However, it is this increase in databases, the kind of data being gathered, the way that data is protected (or rather the opposite) and the way it is used internally and externally, that has come under increased scrutiny and been criticised by many civil libertarians. But the criticisms are not just about civil liberties. When governments implement ICT, outcomes vary.

Large-scale projects such as the FBI's Virtual Case File, the UK's C-NOMIS or Germany's FISKUS either failed completely or largely exceeded their estimated budgets, wasting billions of taxpayers' money. There are, of course, also successful projects but, by and large, the expected impact of eGovernment in moving into a brave new world of efficient, effective and citizen-focused government administration has not happened. The power of ICTICT has characteristics that need to be understood before carrying out any impact assessment.

These characteristics underline why digital data and databases will continue to grow in the future, and why it is necessary to find balanced governance mechanisms for ICT, for the organisations they are embedded in, and for us - the individuals using them. ICT allows information processing, coordination and flows to be structured without the common boundaries of roles, organisational relationships and operating procedures found in government. As a consequence, the relationship between information and the physical factors of organisational size, distance, time and costs are altered.

Digital information makes geographical dispersion irrelevant, allowing for new forms of collaboration and networks. Information technologies facilitate the speed of communication and more selectively control access to, and participation in, information exchange. Interestingly, the standardisation, routinisation and formalisation of information sharing are not only technical requirements for shared databases to be effective; they are also typical traits of bureaucracies.

Organisational memory that was once hidden in non-digital forms or an individual's memory can be stored, managed and analysed in digital form to improve knowledge or facilitate decision-making - helped by the fact that information storage, provision and search costs are virtually zero once information is digitised. Moreover, the human constraints of processing large quantities of information are reduced (for example, through the use of search engines), and software applications make it possible to combine and reconfigure data so as to provide new information. This has been spurred by the rise of Web 2.0 applications such as social networking sites, mash-ups, tagging, and wikis, with the underlying philosophy that comes with it - i.e.

Mass collaboration and data sharing - further facilitating the growth of data. The public has followed this trend on a scale that no one imagined. Younger people in particular store and share data about their activities, location, buying behaviour or personal lives like no other generation before, and periodical incidents of security breaches, identity theft and fraud have not reversed this trend.

Often, this behaviour is based on a conscious decision: millions of users joined corporate loyalty programmes (offered by, for example, airlines, hotels or shops) in return for personalised services, rebates or points that can be used in various ways. People may also just be following an intrinsic desire to share and connect. Wikipedia is one of the prominent examples of the powerful force of collaborative peer production.(REF URL http://www.iq.harvard.edu/blog/netgov/2008/10/).

Sources: http://www.iq.harvard.edu/blog/netgov/2008/10/ .

" "how do I automatically transfer data in one cell to another cell on same sheet in Excel 2007" "Excel - when I add a formula, hidden columns are revealed. How do I fix that?" "How do I copy a horizontal row of data in Excel and have to come up vertically in a cell? " "How can I place multiple hyperlinks inside one cell as part of a text sentence in MS Excel 2007" "Do your cell phones stop working?

" "Excel 2007, selecting find, want the cell it finds to highlight in a different color then the default grey?" "I have hidden cells on an excel sheet that cut and paste to a new worksheet. How do I stop that? " "cell phones.

How do I automatically transfer data in one cell to another cell on same sheet in Excel 2007.

Excel - when I add a formula, hidden columns are revealed. How do I fix that?

How can I place multiple hyperlinks inside one cell as part of a text sentence in MS Excel 2007.

I have hidden cells on an excel sheet that cut and paste to a new worksheet. How do I stop that?

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.