If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cell margins
I know I can indent text in a cell from the left and from
the right of the cell, but can anybody please tell me how to indent it from the top and bottom? I want to be able to autofit my rows to my text but leaving a gap at the top and bottom so it's not all squashed. I know I can make the rows bigger and then centre the text vertically, but this is for a very big document so I don't want to have to manually size each row. |
#2
|
|||
|
|||
Apologies if I have misunderstood, but check under Format, Cells, Vertical
Alignment, Center. I am not sur if that is what you want, but maybe.... Judy Freed Systems Development "katrina" wrote in message ... I know I can indent text in a cell from the left and from the right of the cell, but can anybody please tell me how to indent it from the top and bottom? I want to be able to autofit my rows to my text but leaving a gap at the top and bottom so it's not all squashed. I know I can make the rows bigger and then centre the text vertically, but this is for a very big document so I don't want to have to manually size each row. |
#3
|
|||
|
|||
if no one has an easier way for you, you could center the
text vertically, then use a macro to autofit the rows for you. something like this should get the job done: Sub SizeRowsandCols() ActiveSheet.UsedRange.Select Selection.Rows.AutoFit 'Selection.Columns.AutoFit End Sub if you wanted to autofit the columns also, you could simply remove the ' from in front of the Selection.Columns.Autofit line and it would do both. hope this helps. mike -----Original Message----- I know I can indent text in a cell from the left and from the right of the cell, but can anybody please tell me how to indent it from the top and bottom? I want to be able to autofit my rows to my text but leaving a gap at the top and bottom so it's not all squashed. I know I can make the rows bigger and then centre the text vertically, but this is for a very big document so I don't want to have to manually size each row. . |
#4
|
|||
|
|||
highlight all the cells
format(menu)-cells-alignment-vertical-choose one of the items. But cell height should be bigger than the entry format. to see this. On Wed, 15 Sep 2004 11:18:10 -0700, katrina wrote: I know I can indent text in a cell from the left and from the right of the cell, but can anybody please tell me how to indent it from the top and bottom? I want to be able to autofit my rows to my text but leaving a gap at the top and bottom so it's not all squashed. I know I can make the rows bigger and then centre the text vertically, but this is for a very big document so I don't want to have to manually size each row. -- Using Opera's revolutionary e-mail client: http://www.opera.com/m2/ |
#5
|
|||
|
|||
I don't think any of the respondents answered Katrina's question, and I have
the same question. Maybe if I restate it. In MS Word tables, you can set a white space margin within the cell, on each border of the text (i.e., left, right, top, bottom) to improve readability. If the text wraps to a new line, these margins are maintained. I do not see any parallel capability to do that in Excel. If you manually set the height, then wrapped text will be partially hidden. Am I right or wrong? "katrina" wrote: I know I can indent text in a cell from the left and from the right of the cell, but can anybody please tell me how to indent it from the top and bottom? I want to be able to autofit my rows to my text but leaving a gap at the top and bottom so it's not all squashed. I know I can make the rows bigger and then centre the text vertically, but this is for a very big document so I don't want to have to manually size each row. |
#6
|
|||
|
|||
Try this macro to indent left and add a blank line top and bottom then wrap
text and autofit. Note: won't work with "merged" cells. Sub Indent_Text() Dim Cell As Range Dim moretext As String Dim thisrng As Range On Error GoTo endit Set thisrng = Range(ActiveCell.Address & "," & Selection.Address) _ .SpecialCells(xlCellTypeConstants, xlTextValues) moretext = Chr(10) For Each Cell In thisrng With Cell .Value = moretext & Cell.Value & moretext .Rows.AutoFit .IndentLevel = 2 End With Next Exit Sub endit: MsgBox "only formulas in range" End Sub Gord Dibben Excel MVP On Mon, 10 Jan 2005 07:53:03 -0800, "rasty_9" wrote: I don't think any of the respondents answered Katrina's question, and I have the same question. Maybe if I restate it. In MS Word tables, you can set a white space margin within the cell, on each border of the text (i.e., left, right, top, bottom) to improve readability. If the text wraps to a new line, these margins are maintained. I do not see any parallel capability to do that in Excel. If you manually set the height, then wrapped text will be partially hidden. Am I right or wrong? "katrina" wrote: I know I can indent text in a cell from the left and from the right of the cell, but can anybody please tell me how to indent it from the top and bottom? I want to be able to autofit my rows to my text but leaving a gap at the top and bottom so it's not all squashed. I know I can make the rows bigger and then centre the text vertically, but this is for a very big document so I don't want to have to manually size each row. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a Price calculator | mariekevink | New Users | 2 | September 14th, 2004 05:53 PM |
Can I conditionally UNLOCK a cell? | Chris | Worksheet Functions | 1 | August 31st, 2004 07:47 PM |
using cell contents in pathname | Don Guillett | Worksheet Functions | 7 | January 2nd, 2004 02:11 PM |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 09:13 AM |