> For the complete documentation index, see [llms.txt](https://gyx8899.gitbook.io/blog/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gyx8899.gitbook.io/blog/office/excel.md).

# Excel 常用操作

* 拖拽列递增1

> ctrl + 左键 拖拽；

* 求和公式

> \=SUM(C2:C26)

* 表格中使某列或某行置左或置顶，滚动时一直在视窗内

> 选中行或列，“菜单-查看-冻结（当前列/行）”