Excel Spreadsheets
 

Can someone help an old dummy please? How can I set all the lines(rows) and
or columns to the same height for rows and width for columns. I have been
dragging each individually and there has to be a way to set all at once
thanks in advance.

Select the rows you want to change by clicking on the first row
header, hold down the SHIFT key and click the last row header you
want to change. Then, right-click on the row header, and choose
"Row Height".

If you want to change the *entire* spreadsheet, click the Select
All button (the gray area above the "1" row header and to the
left of the "A" column header), then right-click a row header
and choose "Row Height".

The procedures for changing columns widths are essentially the
same; just use the column headers rather than the row headers.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"wolfmanjack81" wrote
in message
...
Can someone help an old dummy please? How can I set all the
lines(rows) and
or columns to the same height for rows and width for columns. I
have been
dragging each individually and there has to be a way to set all
at once
thanks in advance.

Click on the square above and to the left of "A1" then Format|Column|Width
and Format|Row|Height

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"wolfmanjack81" wrote:
| Can someone help an old dummy please? How can I set all the lines(rows)
and
| or columns to the same height for rows and width for columns. I have been
| dragging each individually and there has to be a way to set all at once
| thanks in advance.