Blank row in a table

wagwan_jc

New Member
Joined
Mar 21, 2016
Messages
7
Hi,

I am trying to create a space between two rows in a table...

I have two tabs;
TAB1 : Database
TAB2 : Tables

In [Database] we have listed all the items which we use.

In [Tables] I have a table, in which each row contains an item. The items in [Tables] are all taken from [Database]. So whenever inserting an item in tables we will press [=] in the cell and click the cell from database containing the item to be inserted.

In my table all the cells are upper justified. There is no border inside the table. The objective is to create a space between each row inside the table, without inserting blank rows (which cannot be done anyways in a Table).

To accomodate for this what I have done is, insert a blank line after the text for each item in my Database. So in the cell in Database for item 1 for example, after filling in all the columns for this item, i would go to the column with the most text, and press [ALT+ENTER] to create a blank line. This will create the blank line desired between each row in my table;

But I would like to know is there a more professional way to accomplish this target?

Thanks,
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

starl

Administrator
Joined
Aug 16, 2002
Messages
5,969
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
WHY do you want blank rows? Do you just want a larger separator between rows? If so, you can do that by changing the height of the row. To get it to stick to that height, select an unused column and make the font in that column larger. This will give the illusion of an extra row without actually inserting one.
 

wagwan_jc

New Member
Joined
Mar 21, 2016
Messages
7
Hi, Thanks for the response.

Yes, the idea is to create spacing between rows, as there is no borders inside the table, and to do this without having to insert blank rows.

The problem is that each row varies in the row height depending on how many lines the text requires. Some rows have 1line of text, some 2, some 3... In a file with many tables.
Is there a way to autofit the row heights with a extra margin at the margin?
 

starl

Administrator
Joined
Aug 16, 2002
Messages
5,969
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
  2. MacOS
I get what you're saying - you want a little bit of extra space between rows, but the row height isn't consistent, so the workaround won't work...

Other than VBA, the only workaround I can think of is column pointing to the column you want driving the row height and adding a linefeed (char(10)) to the end of it
So, let's say column A is driving the row height. In another cell, I would put
=A2 & CHAR(10)

Though, you might still have to double-click to get the row height to update. And you might get more space then you want.
The VBA solution is better, but not perfect - for example, if your text ends at the end of the cell and Excel already adds a little extra space, the VBA doesn't know that and will extend it more. Code like this may work: Merged cells won't Autofit row height
 

Watch MrExcel Video

Forum statistics

Threads
1,126,948
Messages
5,621,777
Members
415,856
Latest member
jimb2k

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top