自动调整Google表格中的列大小 [英] Automatically resize columns in Google sheets

问题描述

我希望Google表格上的列自动调整大小以适合我的文本，而无需在每次输入后都手动调整它们的大小.我该怎么做?

I would like to have columns on google sheets automatically resize to fit my text, without me having to manually resize them after every entry. How do I do this?

推荐答案

仅供参考-对于那些不想深入研究脚本，但又想更快地完成脚本工作的人，可以在以下位置自动调整所有列的大小:手动一次:按下Cmd + A(或Windows中的Ctrl + A)以选择所有内容，然后将鼠标移至任意两个列标题之间的边框上(就像您要手动调整该标题的大小一样)，光标将变为箭头...，然后双击.在此处找到了这个技巧.

FYI -- For those who don't want to delve into scripting, but want a way to do it faster, you can auto-resize all the columns at once, manually: Hit Cmd+A (or Ctrl+A in Windows) to select everything, then move the mouse to the border between any two column headers -- as if you wanted to resize that one manually-- the cursor changes to an arrow... and double click. Found this trick here.

这篇关于自动调整Google表格中的列大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！