Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Tags
format data in cell, mac, wrap text



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 08:00 AM.


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