Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2014, 10:26 PM
jdorin jdorin is offline How to add whitespace above/below text in a cell? Mac OS X How to add whitespace above/below text in a cell? Office for Mac 2011
Novice
How to add whitespace above/below text in a cell?
 
Join Date: Feb 2013
Location: Atlanta, GA USA
Posts: 9
jdorin is on a distinguished road
Default How to add whitespace above/below text in a cell?

How to have space automatically appear before and after the text in a cell? I use (check) the Wrap Text button for all cells in a selected column, and it satisfactorily adjusts the height of all rows requiring vertical adjustment for the wrapped text.



The resultant row height is JUST high enough to accommodate the wrapped text, but when I Wrap Text for an entire column, all row heights are tightened so close that it's difficult to read the wrapped text.

I know I can adjust each row's height manually, achieving the desired before/after spacing, but the worksheet contains too many rows to make this practical .. all rows tighten up again each time I Wrap Text on an entire column.

What I'm looking for is something similar to MS Word's paragraph formatting, where you can specify the space to appear before and after text in a paragraph.

I'm using MS Office for Mac 2011.
Reply With Quote
  #2  
Old 07-10-2014, 12:45 AM
macropod's Avatar
macropod macropod is offline How to add whitespace above/below text in a cell? Windows 7 32bit How to add whitespace above/below text in a cell? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could try using a font that has more leading. For example, the Garamond font has relatively small characters compared to, say, the Calibri font. If you use the Garamond font and increase the point size to use approximately the same linear length as the Calibri font, the row heights will increase, giving you more whitespace above & below each line. FWIW 12pt Garamond approximates 11pt Calibri for overall character widths. Anything fancier would require a macro, but that would only serve to increase the space before the first line and after the last line in a cell.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-10-2014, 07:07 PM
jdorin jdorin is offline How to add whitespace above/below text in a cell? Mac OS X How to add whitespace above/below text in a cell? Office for Mac 2011
Novice
How to add whitespace above/below text in a cell?
 
Join Date: Feb 2013
Location: Atlanta, GA USA
Posts: 9
jdorin is on a distinguished road
Default Alter font & size to achieve interline spacing

Thanks, Paul. I'm afraid that your sugg is all that's available to alter vertical space in text in a cell. As you mentioned, greater space between all lines will give the desired space at the cells' tops and bottoms, but the same extra space between each line would be undesirable.

I'd considered a macro solution but, yes, it would require constant maintenance.

I couldn't think of a convenient solution, and it's reassuring that someone with your skills & experience codifies my conclusions.
Reply With Quote
Reply

Tags
format data in cell, mac, wrap text

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add whitespace above/below text in a cell? VBA code to select one word from a text in a cell and place that word in next cell Shinaj Excel 2 05-01-2014 01:50 PM
How to add whitespace above/below text in a cell? Table with text that flows from cell to cell hwrigley Word Tables 7 02-18-2014 02:59 AM
How to add whitespace above/below text in a cell? How to input the text of a cell into another cell automatically ? Juliet Excel 1 03-15-2013 03:25 AM
Borderless printing still produces whitespace JSmith Word 4 06-15-2012 02:50 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft