Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default how can I change row height for the entire page?

Is there a way for me to change the row height for an entire excel sheet? I
want to make every row a certain size from the start, without having to
change each row with my mouse. Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 430
Default how can I change row height for the entire page?

click on the upper left hand square on your sheet (the one kitty corner to 1
and A) to select the whole sheet and then 'format' ... 'row'....'height' It
will adjust the height for whatever rows you have hilighted.

"Linds" wrote:

Is there a way for me to change the row height for an entire excel sheet? I
want to make every row a certain size from the start, without having to
change each row with my mouse. Thanks!

  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default how can I change row height for the entire page?

Click on the blank square just above row 1 to highlight the whole sheet, then
do Format Rows and set the height desired.....

Vaya con Dios,
Chuck, CABGx3



"Linds" wrote:

Is there a way for me to change the row height for an entire excel sheet? I
want to make every row a certain size from the start, without having to
change each row with my mouse. Thanks!

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default how can I change row height for the entire page?

Linda

Open a new workbook. Customize as you wish. FileSave
As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook
"BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP

On Thu, 3 Aug 2006 09:50:02 -0700, Linds
wrote:

Is there a way for me to change the row height for an entire excel sheet? I
want to make every row a certain size from the start, without having to
change each row with my mouse. Thanks!


Gord Dibben MS Excel MVP
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
How to change default page setup for pivot tables? bobs Excel Discussion (Misc queries) 1 January 5th 05 09:42 PM
Change height of row Pam MacT Excel Discussion (Misc queries) 2 January 5th 05 01:54 AM
How do I change row height to 16.0? I get choice of 15.6 (26 Pix. jlloyd Excel Discussion (Misc queries) 4 December 9th 04 04:47 PM


All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"