Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2019, 03:34 AM
Willby Willby is offline Add white space between rows Windows 10 Add white space between rows Office 2016
Novice
Add white space between rows
 
Join Date: Feb 2019
Posts: 1
Willby is on a distinguished road
Default Add white space between rows

I don't know of any native way to add white space between rows, but this simple macro does the job. It prompts the user to input a value for the extra space (which is created by increasing the row height of each row by a certain amount greater than the 'auotfitted' height):



Code:
#Sub RowHeight()

Dim rngRows, rngCell As Range
Dim h, n As Single

n = InputBox("Space to add:", "Add space between rows", 15)

Set rngRows = Range(Range("B2"), Range("B2").End(xlDown))
rngRows.Rows.AutoFit

For Each rngCell In rngRows
    h = rngCell.Height
    rngCell.RowHeight = h + n
Next


 End Sub#
Edit Mod : related to https://www.msofficeforums.com/excel...text-cell.html

Last edited by Pecoflyer; 02-08-2019 at 08:02 AM.
Reply With Quote
  #2  
Old 02-07-2019, 07:29 AM
ArviLaanemets ArviLaanemets is offline Add white space between rows Windows 8 Add white space between rows Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Instead letting Excel to decide, when start with new row, you can force the new row with Alt+Enter. Doing so twice gives you additional empty row between text rows. I have used this to group entered text sometimes.
Reply With Quote
  #3  
Old 02-08-2019, 12:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Add white space between rows Windows 7 64bit Add white space between rows Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@Willby
Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
I will create a thread for you this time
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 02-08-2019, 12:56 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Add white space between rows Windows 7 64bit Add white space between rows Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@Arvi
Please don't encourage hijacking by following up

Thank you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 02-08-2019, 06:33 AM
ArviLaanemets ArviLaanemets is offline Add white space between rows Windows 8 Add white space between rows Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by Pecoflyer View Post
Please don't encourage hijacking by following up
I thought I was answering to jdorin's thread! Now I checked dates and did see it was an antique one!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add white space between rows white letter instead off space merletcollege Word 3 09-27-2018 01:19 AM
Add white space between rows Eliminate weird white space puff Word 7 03-12-2018 12:51 AM
Unwanted white space sassiebrat Word 2 10-03-2016 08:53 PM
Removed white space within same page. johnatanasoff Word 7 01-04-2016 07:44 AM
Add white space between rows white space seeker62 Word 12 07-16-2013 09:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 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