Home |
Search |
Today's Posts |
#1
|
|||
|
|||
set cell margins
Does anyone know how to set cell margins in Excel? I'm preparing a long list
of items for a committee review, and I think it would be more user/reader friendly with some white space. The columns are mixed numbers, dates, and text, but the largest cells are text. |
#2
|
|||
|
|||
June
FormatCellsAlignment. Look at the various options in "Horizontal" and "Vertical" Top, bottom, centered, justified, right indent, left indent and a gang of others. Also row heights and column widths can be manipulated. Gord Dibben Excel MVP On Sun, 5 Dec 2004 10:35:28 -0800, "Junebug" wrote: Does anyone know how to set cell margins in Excel? I'm preparing a long list of items for a committee review, and I think it would be more user/reader friendly with some white space. The columns are mixed numbers, dates, and text, but the largest cells are text. |
#3
|
|||
|
|||
"Junebug" wrote in message
... Does anyone know how to set cell margins in Excel? I'm preparing a long list of items for a committee review, and I think it would be more user/reader friendly with some white space. The columns are mixed numbers, dates, and text, but the largest cells are text. Not too sure what you mean here. You can increase the "white space" between rows of cells by increasing the height of the rows. Similarly you can increase the space between columns by increasing the widtth of the columns, however, your text will wrap to the new width, so perhaps formatting the horizontal alignment to Left(indent) and set the number of characters to indent may be the way to go. Ian |
#4
|
|||
|
|||
I think what she (and I) are looking for is functionality similar in Word
Tables - I want to specify space above and below my text in the cell. Autoheight doesn't leave enough space between rows. I can't specify a determined height because rows in my spreadsheet have a different number of text lines in them - one line of text I might want at 17.25, but lines with more text in a cell need to more like 38.25. So, is there a feature in Excel where I can specify points above and below - cell padding, in essence. "IC" wrote: "Junebug" wrote in message ... Does anyone know how to set cell margins in Excel? I'm preparing a long list of items for a committee review, and I think it would be more user/reader friendly with some white space. The columns are mixed numbers, dates, and text, but the largest cells are text. Not too sure what you mean here. You can increase the "white space" between rows of cells by increasing the height of the rows. Similarly you can increase the space between columns by increasing the widtth of the columns, however, your text will wrap to the new width, so perhaps formatting the horizontal alignment to Left(indent) and set the number of characters to indent may be the way to go. Ian |
#5
|
|||
|
|||
David
Excel doen't have a cell-padding function as a full-blown word processing app would have. You can run this macro to insert a CR above and below the text in a cell to give white space. Sub Add_Pad() Set myRange = Range(ActiveCell.Address _ & "," & Selection.Address) _ .SpecialCells(xlCellTypeConstants) For Each Cell In myRange Cell.Value = Chr(10) & Cell.Value & Chr(10) Cell.Rows.AutoFit Next Cell End Sub Don't know how practical it would be. Gord Dibben Excel MVP On Wed, 16 Feb 2005 17:01:07 -0800, "David" wrote: I think what she (and I) are looking for is functionality similar in Word Tables - I want to specify space above and below my text in the cell. Autoheight doesn't leave enough space between rows. I can't specify a determined height because rows in my spreadsheet have a different number of text lines in them - one line of text I might want at 17.25, but lines with more text in a cell need to more like 38.25. So, is there a feature in Excel where I can specify points above and below - cell padding, in essence. "IC" wrote: "Junebug" wrote in message ... Does anyone know how to set cell margins in Excel? I'm preparing a long list of items for a committee review, and I think it would be more user/reader friendly with some white space. The columns are mixed numbers, dates, and text, but the largest cells are text. Not too sure what you mean here. You can increase the "white space" between rows of cells by increasing the height of the rows. Similarly you can increase the space between columns by increasing the widtth of the columns, however, your text will wrap to the new width, so perhaps formatting the horizontal alignment to Left(indent) and set the number of characters to indent may be the way to go. Ian |
#6
|
|||
|
|||
Thanks Gord.
Can I assume that '10' stands for point size so that I can increase or decrease as necessary? - dmt "Gord Dibben" wrote: David Excel doen't have a cell-padding function as a full-blown word processing app would have. You can run this macro to insert a CR above and below the text in a cell to give white space. Sub Add_Pad() Set myRange = Range(ActiveCell.Address _ & "," & Selection.Address) _ .SpecialCells(xlCellTypeConstants) For Each Cell In myRange Cell.Value = Chr(10) & Cell.Value & Chr(10) Cell.Rows.AutoFit Next Cell End Sub Don't know how practical it would be. Gord Dibben Excel MVP On Wed, 16 Feb 2005 17:01:07 -0800, "David" wrote: I think what she (and I) are looking for is functionality similar in Word Tables - I want to specify space above and below my text in the cell. Autoheight doesn't leave enough space between rows. I can't specify a determined height because rows in my spreadsheet have a different number of text lines in them - one line of text I might want at 17.25, but lines with more text in a cell need to more like 38.25. So, is there a feature in Excel where I can specify points above and below - cell padding, in essence. "IC" wrote: "Junebug" wrote in message ... Does anyone know how to set cell margins in Excel? I'm preparing a long list of items for a committee review, and I think it would be more user/reader friendly with some white space. The columns are mixed numbers, dates, and text, but the largest cells are text. Not too sure what you mean here. You can increase the "white space" between rows of cells by increasing the height of the rows. Similarly you can increase the space between columns by increasing the widtth of the columns, however, your text will wrap to the new width, so perhaps formatting the horizontal alignment to Left(indent) and set the number of characters to indent may be the way to go. Ian |
#7
|
|||
|
|||
David
The CHR(10) inserts a carriage return to add a new line which would be the same number of points as the current font in that cell. To designate number of points of white space would take more VBA knowledge than I am capable of providing. Gord On Thu, 17 Feb 2005 07:53:06 -0800, "David" wrote: Thanks Gord. Can I assume that '10' stands for point size so that I can increase or decrease as necessary? - dmt "Gord Dibben" wrote: David Excel doen't have a cell-padding function as a full-blown word processing app would have. You can run this macro to insert a CR above and below the text in a cell to give white space. Sub Add_Pad() Set myRange = Range(ActiveCell.Address _ & "," & Selection.Address) _ .SpecialCells(xlCellTypeConstants) For Each Cell In myRange Cell.Value = Chr(10) & Cell.Value & Chr(10) Cell.Rows.AutoFit Next Cell End Sub Don't know how practical it would be. Gord Dibben Excel MVP On Wed, 16 Feb 2005 17:01:07 -0800, "David" wrote: I think what she (and I) are looking for is functionality similar in Word Tables - I want to specify space above and below my text in the cell. Autoheight doesn't leave enough space between rows. I can't specify a determined height because rows in my spreadsheet have a different number of text lines in them - one line of text I might want at 17.25, but lines with more text in a cell need to more like 38.25. So, is there a feature in Excel where I can specify points above and below - cell padding, in essence. "IC" wrote: "Junebug" wrote in message ... Does anyone know how to set cell margins in Excel? I'm preparing a long list of items for a committee review, and I think it would be more user/reader friendly with some white space. The columns are mixed numbers, dates, and text, but the largest cells are text. Not too sure what you mean here. You can increase the "white space" between rows of cells by increasing the height of the rows. Similarly you can increase the space between columns by increasing the widtth of the columns, however, your text will wrap to the new width, so perhaps formatting the horizontal alignment to Left(indent) and set the number of characters to indent may be the way to go. Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |