Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 464
Default 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


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
how to set data validation on cell that display a date in Excel? SBA22000 Excel Worksheet Functions 2 July 4th 08 09:48 PM
excel cell data won't display on monitor Brad Excel Discussion (Misc queries) 6 July 10th 06 11:31 PM
Excel control cell display of data with passwords LimaSite85.us Excel Worksheet Functions 0 February 15th 06 05:18 AM
MS Excel 2000 Cell Capacity and Data Display RCM-IEWTD Excel Discussion (Misc queries) 3 August 11th 05 05:05 PM
customizing the mouse-over display in a bubble chart Mark Charts and Charting in Excel 2 August 9th 05 12:01 AM


All times are GMT +1. The time now is 01:34 AM.

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"