excel100个基础工作表（学习笔记十一Excel工作表和行列的基础操作）

excel100个基础工作表（学习笔记十一Excel工作表和行列的基础操作）工作表的基本操作1Share your interests spread your joy grow your insights and leave your beauty behind!Dear you this is LearningYard Academy.Today I bring you "Learning Notes (XI) | Excel worksheet and the basic operation of the row" welcome to visit.

分享兴趣，传播快乐，增长见闻，留下美好！

亲爱的您，这里是LearningYard学苑。

今天小编为大家带来“学习笔记（十一）|Excel工作表和行列的基础操作”，欢迎您的访问。

Share your interests spread your joy grow your insights and leave your beauty behind!

Dear you this is LearningYard Academy.

Today I bring you "Learning Notes (XI) | Excel worksheet and the basic operation of the row" welcome to visit.

1

工作表的基本操作

按住Ctrl键不放左右移动鼠标进行工作表的复制。

工作表的新建，删除，重命名，设置标签颜色等都可以通过单击右键进行解决。

Hold down the Ctrl key and move the mouse left and right to copy the worksheet.

Worksheet creation deletion renaming setting label colors etc. can be solved by right-clicking.

2

行列的基本操作

行列的移动：按住shift键不放将鼠标移至边框线进行移动。

行列取消隐藏：选中包含隐藏行列的行列，右键选择取消隐藏即可。

行高列宽的调整：选中行列，双击两行/列中间，即可实现根据内容自动进行高列宽的调整。

技巧：

按住Ctrl键不放进行不连续的选择

Ctrl shift 方向键进行连续选择

Row movement: Hold down the shift key and move the mouse to the border line to move.

Rows and columns can be unhidden: select the rows and columns containing hidden rows and columns right click and select unhide.

Adjustment of row height and column width: select the row and column double-click the middle of the two rows/columns to achieve automatic adjustment of the height and column width according to the content.

Tips.

Hold down the Ctrl key for discontinuous selection

Ctrl shift direction keys for continuous selection

今天的分享就到这里，如果您对今天的文章有独到的见解，欢迎给我们留言，让我们相约明天，祝您今天过得开心快乐！

Today's share is over here if you have unique views on today's article welcome to leave a message for us let us meet tomorrow I wish you a happy and happy today!‍

参考资料：文字：百度；图片：微博；翻译：百度翻译

本文由LearningYard新学苑原创，部分图片文字来自网络，如有侵权请联系。