Skip to content

Instantly share code, notes, and snippets.

@iguoli

iguoli/excel_tips.md

Last active December 10, 2017 06:00
Show Gist options
  • Save iguoli/5e175619564703609c00d70e973bf690 to your computer and use it in GitHub Desktop.
Save iguoli/5e175619564703609c00d70e973bf690 to your computer and use it in GitHub Desktop.
Download ZIP
Excel应用技巧, excel, office
Raw
excel_tips.md

快速选中所有数据

选中第一行，然后按Ctrl + Shift + ↓，系统会自动选中所有数据区数据。

在公式中转换单元格引用方式

在公式中可以通过按F4键，将A1快速改变为$A$1，连续按F4会在几种引用方式间切换。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment