#1   Report Post  
TerryTutor
 
Posts: n/a
Default Margins

How do I set up margins around cells so there is more space around text in a
cell? And how do I keep this as part of my master template, and how avoid
having to add this format if I add a row or column, since excel doesnt seem
to keep formats even though I change them from the top or right for the
entire row. Everytime I add a new row or column it forgets how I changed the
sheet.

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Do you use a common rowheight for all your rows?

If yes, then select all the cells (ctrl-a, (twice in xl2003) and adjust the
rowheight of all the rows.

If no, then it looks like excel will pick up the row height from the row
directly above the inserted row.



TerryTutor wrote:

How do I set up margins around cells so there is more space around text in a
cell? And how do I keep this as part of my master template, and how avoid
having to add this format if I add a row or column, since excel doesnt seem
to keep formats even though I change them from the top or right for the
entire row. Everytime I add a new row or column it forgets how I changed the
sheet.


--

Dave Peterson
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
Excel 2003 - Footer Left/Right Margins Laura J Excel Discussion (Misc queries) 3 October 4th 05 10:46 PM
how to move header and footer within print margins excel Rohit Excel Discussion (Misc queries) 2 May 4th 05 04:52 PM
How reset margins in Excel workbook? KYgirl Excel Discussion (Misc queries) 1 April 29th 05 12:52 AM
Excel hangs computer when adjusting margins Graeme Excel Discussion (Misc queries) 1 April 6th 05 07:26 AM
xl Headers and Footers always use 3/4 inch side margins??? mr unreliable New Users to Excel 1 February 14th 05 07:55 PM


All times are GMT +1. The time now is 08:38 PM.

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

About Us

"It's about Microsoft Excel"