Row Length in Excel

[Mitch656]

So im using Excel 2010, and i making a timetable.

Right now the row going across saying period 1 2 3 they are all different sizes, some will be bigger and some would be smaller. I was wondering if there is a way to make them all the same size.


If you dont know what im talking about ask for a screenshot.

Im to busy to upload one now

 

[mickey megabyte]

do you want the rows to all be the same height?

click on the first row number on the left - shift-click on the last one to select all the rows.

then right-click on the row numbers >> row height >> type in a number...



you can do a similar thing with the columns too.

is this what you meant?

 

[Mitch656]

do you want the rows to all be the same height?

click on the first row number on the left - shift-click on the last one to select all the rows.

then right-click on the row numbers >> row height >> type in a number...

View attachment 152542

you can do a similar thing with the columns too.

is this what you meant?

My brain has just died I mean the rows? that are all grey i want them to be the same length like going across if that makes sence

 

[Golden]

Right-click the column, and choose the option "Column Width" to set it - you can also select several columns and set them to the same width at the same time.

 

[mickey megabyte]

yep - just click on the first column header (the A), shift-click on the last (I or whatever)...that'll select all the columns.

...do a right-mouse click >> column width >> type a number

exactly the same process as i explained above.