ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Customizing the Display of Data in an Excel Cell (https://www.excelbanter.com/excel-discussion-misc-queries/260075-customizing-display-data-excel-cell.html)

DeeDeeCee

Customizing the Display of Data in an Excel Cell
 
Hi gurus. I would like to have the cells in my spreadsheet do something
automatically, if that is possible:

I would like there to be some space between the text in a cell and the lower
border of the cell, even if there is only one line of text. This woud be kind
of like what you have in Word, where you can set each paragraph to have 6 or
12 points of space before the next paragraph. Is that possible?
Thanks.

deedeecee


FSt1

Customizing the Display of Data in an Excel Cell
 
hi
try this.
right click the cell. from the popup select format cells.
or on the menu barformatcells
on the format cells dialog, click the alignment tab.
in the text alignment frame, click th down arrow of the vertical combo back.
select center. if you don't like that....play with it.

regards
FSt1

"DeeDeeCee" wrote:

Hi gurus. I would like to have the cells in my spreadsheet do something
automatically, if that is possible:

I would like there to be some space between the text in a cell and the lower
border of the cell, even if there is only one line of text. This woud be kind
of like what you have in Word, where you can set each paragraph to have 6 or
12 points of space before the next paragraph. Is that possible?
Thanks.

deedeecee


ozgrid.com

Customizing the Display of Data in an Excel Cell
 
Why not align center vertically and adjust your row heights?



--
Regards
Dave Hawley
www.ozgrid.com
"DeeDeeCee" wrote in message
...
Hi gurus. I would like to have the cells in my spreadsheet do something
automatically, if that is possible:

I would like there to be some space between the text in a cell and the
lower
border of the cell, even if there is only one line of text. This woud be
kind
of like what you have in Word, where you can set each paragraph to have 6
or
12 points of space before the next paragraph. Is that possible?
Thanks.

deedeecee




All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com