Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Row Length in Excel

03 May 2011   #1
Mitch656

Windows 7 Professional 64bit
 
 
Row Length in Excel

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


My System SpecsSystem Spec
.
03 May 2011   #2
mickey megabyte

ultimate 64 sp1
 
 

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...

Row Length in Excel-xl.jpg

you can do a similar thing with the columns too.

is this what you meant?


My System SpecsSystem Spec
03 May 2011   #3
Mitch656

Windows 7 Professional 64bit
 
 

Quote   Quote: Originally Posted by mickey megabyte View Post
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...

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


Attached Thumbnails
Row Length in Excel-untitled.png  
My System SpecsSystem Spec
.

03 May 2011   #4
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

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.
My System SpecsSystem Spec
03 May 2011   #5
mickey megabyte

ultimate 64 sp1
 
 

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.
My System SpecsSystem Spec
Reply

 Row Length in Excel




Thread Tools




Similar help and support threads
Thread Forum
Max file name length
I have a question regarding files. How many levels of subfolders can there be? I've seen the max amount of characters is 260, does this include the path with slashes? I remember back in the day when files could only be 8 characters long and I had to make shorthand notations to remember what the...
General Discussion
USB cord length
Anyone know if there's a working restriction on a length for USB 2 cord im running A 20FT cord, I have a touch screen on my media center screen as I use as the control for Media, Video, music and my big screen, any how it seems to work for about 15mins and then goes a little flakey and stops...
Drivers
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
Excel 2003 - Multiple Excel Open
Hi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:16.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App