调整EXCEL行内边距 梅鸿楼 2020-04-20 1,321 阅读1分钟 打开要设道置单元格上下边距的文档,按alt+F11,打开VBA编辑器,双击左侧树形内图中的“Thisworkbook”,在右侧的窗口中输入下面的程容序段:sub userset() Dim i&, r As Range Set r = Range("a1") For i = 1 To 10 r.Cells(i).RowHeight = r.Cells(i).RowHeight + 5 Next i End Sub点击运行