#1
|
|||
|
|||
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# Last edited by Pecoflyer; 02-08-2019 at 08:02 AM. |
#2
|
|||
|
|||
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.
|
#3
|
||||
|
||||
@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 |
#4
|
||||
|
||||
@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 |
#5
|
|||
|
|||
I thought I was answering to jdorin's thread! Now I checked dates and did see it was an antique one!
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
white letter instead off space | merletcollege | Word | 3 | 09-27-2018 01:19 AM |
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 |
white space | seeker62 | Word | 12 | 07-16-2013 09:54 PM |