[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 94
  • Last Modified:

Help with sizing rows in excel file

Hi,

How do make all rows in an excel file the same height? I can't find that option from the menu.

Thanks,

Victor
0
vcharles
Asked:
vcharles
1 Solution
 
Martin LissRetired ProgrammerCommented:
In a macro this will probably do it

Rows("1:65536").RowHeight = 16 ' or whatever height you want
0
 
QlemoC++ DeveloperCommented:
Manually, you mark all rows (or cells), and then resize one row. All other rows will have the same height. This works the same with columns.
0
 
vcharlesAuthor Commented:
Thanks.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now