【实用】Excel表格技巧合集,让你工作效率翻一倍办公软件看似简单,其实花样很多,尤其Excel表格,涉及到一些比较少见的数据处理。但其实只要用心多练,效率轻松提升个十倍百倍还真不是问题!
赶紧一起来学习吧~
- 将文字颠倒顺序复制正常顺序对象→在字体前加@→点击向下旋转文字→点击自动换行
- 制作打钩方框输入”R”→设置字体为Wingdings
- 给汉字标注拼音标注拼音→输入汉字→选择拼音设置→居中→编辑拼音→输入拼音→显示拼音字符
- 插入带音调的拼音标注带音调的拼音→插入-符号→拉丁语扩充-B→输入带音调的拼音(备注:动图中“们”应为第二声。
)
- 用斜线分割单个单元格选中对象→插入形状(直线)→ALT+鼠标快速定位单元格边角→F4重复动作,添加分割线→插入文本框→调整字体
- 隐藏不需要显示区域选中对象→Ctrl+1→点击自定义→输入;;;
- 分段显示手机号码选中号码→Ctrl+1→点击自定义→输入000-.数据以万为单位显示动图选中对象→Ctrl+1→点击自定义→输入0!
.0,”万”9.对个案百分比排序选中对象→排序→取消勾选数据包含标题→选择序列
About Hong Kong Xintong
Hong Kong Xintong focuses onGuangdong and Hong Kong license plates、Shenzhen Hazardous Chemicals Business License、Shenzhen labor dispatch licenseandShenzhen Charity Foundationapplication services,Assist customers to applyShenzhen travel agency business license、Shenzhen pawn shop business license、Shenzhen auction house license and other mainstream domestic financial licenses,Support enterprises to achieve compliance expansion of cross-border financial business。Also availableODI overseas investment registration、International travel agency registration and other services,Help enterprises expand their presence in international markets。Provide one-stop compliance solutions for enterprises。To learn more,Please contactHong Kong Information Communications Consultant。
Port communication






