在Excel表中设置不可修改单元格.docVIP

在Excel表格中设置不可修改单元格 时间：2011-03-04 10:29???来源：天极软件频道?? 收藏??复制分享 共有评论(0)条 点击: 1209次 　　现在我们有一个Excel表格，想要设置B2、B3、B4单元格为允许修改的部分，其余部分不可修改。 　　1、选择允许修改的区域(B2、B3、B4单元格)，点击右键，从右键菜单中选择“设置单元格格式”。 　　 ? 　　在“保护”选项卡中，去掉“锁定”前面的钩。 　　 ? 　　2、再击菜单栏上的“工具” →“保护”→“保护工作表”。 　　 ? 　　勾选“选定未锁定的单元格”，并两次输入密码。 　　 ? 　　现在我们来试验一下。 　　修改B2、B3、B4单元格，没有问题。 　　修改C2单元格，Excel弹出下图提示，提醒正在修改被保护的单元格。 　　 ? 　　如果想要解除C2单元格的修改限制，我们可以从菜单栏中选择“工具”-“保护-“撤销工作表保护”。 　　 ? 　　在弹出的对话框中输入刚才设定的密码。 　　 ? 　　现在，C2单元格数据修改成功。 　　 electricity at no cost, revenue from electricity sales. Poverty alleviation to the removal, to desperate farmers out of poverty, in conjunction with urbanization, new communities are centrally placed. Poverty in the enterprise, enterprise more powerful, more social responsibility, they should allow more people to enjoy the fruits of development. Conditions to encourage private enterprises to establish Charity Fund for poverty alleviation, employment, grants, financial aid and other forms of poverty alleviation activities, let poverty alleviation aid corporate social responsibility in the specific embodiment, the proper meaning of giving back to the community. Finally reveals to implement poverty alleviation policies, older age, incapacity, cannot be achieved through industry support and employment support, such as poverty, children and unable to support the poor, Lo-Fi policy reveals the role to play, eventually incorporated into the low range, and fundamentally solve the problem of poverty. (C) establishing and perfecting retreat mechanism. Poverty alleviation is a dynamic project, we must strengthen the farmers information management, dynamic management of poor, really poor no place to hide, poverty a timely exit, poor and return to the poor get maximum support and help. To build up the information network system of the poor, poverty the basic information and dynamic entry to the system, to implement dynamic management. According to pro-poor development, timely adjustment on elect