How do I automatically insert a blank row when I add a new table row in Excel?
up vote
0
down vote
favorite
I have an Excel table that goes from Row 1 to Row 4. Row 7 has other data that I'd like to not overwrite.
I have it set up so that, when I add data to the row just below that table ("Row 5"), Row 5 becomes part of the table. This is good. However, I'd like to insert a new blank row automatically ("Row 6") so that the data in Row 7 and downward doesn't get overwritten as the table grows. Is this possible without VBA and without a macro?
microsoft-excel
asked Nov 13 at 16:40
KDP
991
add a comment |
up vote
0
down vote
favorite
I have an Excel table that goes from Row 1 to Row 4. Row 7 has other data that I'd like to not overwrite.
I have it set up so that, when I add data to the row just below that table ("Row 5"), Row 5 becomes part of the table. This is good. However, I'd like to insert a new blank row automatically ("Row 6") so that the data in Row 7 and downward doesn't get overwritten as the table grows. Is this possible without VBA and without a macro?
microsoft-excel
asked Nov 13 at 16:40
KDP
991
1
No, if you want it conditionally, you will need a VBA macro. You can insert a complete row or paste insert, but then it won't overwrite existing rows. If you want the overwriting to happen, you then also have to do the insert of a row yourself too.
– LPChip
Nov 13 at 16:49
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have an Excel table that goes from Row 1 to Row 4. Row 7 has other data that I'd like to not overwrite.
I have it set up so that, when I add data to the row just below that table ("Row 5"), Row 5 becomes part of the table. This is good. However, I'd like to insert a new blank row automatically ("Row 6") so that the data in Row 7 and downward doesn't get overwritten as the table grows. Is this possible without VBA and without a macro?
microsoft-excel
asked Nov 13 at 16:40
KDP
991
I have an Excel table that goes from Row 1 to Row 4. Row 7 has other data that I'd like to not overwrite.
I have it set up so that, when I add data to the row just below that table ("Row 5"), Row 5 becomes part of the table. This is good. However, I'd like to insert a new blank row automatically ("Row 6") so that the data in Row 7 and downward doesn't get overwritten as the table grows. Is this possible without VBA and without a macro?
microsoft-excel
microsoft-excel
asked Nov 13 at 16:40
KDP
991
asked Nov 13 at 16:40
KDP
991
asked Nov 13 at 16:40
KDP
991
asked Nov 13 at 16:40
KDP
991
asked Nov 13 at 16:40
KDP
991
991
1
No, if you want it conditionally, you will need a VBA macro. You can insert a complete row or paste insert, but then it won't overwrite existing rows. If you want the overwriting to happen, you then also have to do the insert of a row yourself too.
– LPChip
Nov 13 at 16:49
add a comment |
1
No, if you want it conditionally, you will need a VBA macro. You can insert a complete row or paste insert, but then it won't overwrite existing rows. If you want the overwriting to happen, you then also have to do the insert of a row yourself too.
– LPChip
Nov 13 at 16:49
1
1
No, if you want it conditionally, you will need a VBA macro. You can insert a complete row or paste insert, but then it won't overwrite existing rows. If you want the overwriting to happen, you then also have to do the insert of a row yourself too.
– LPChip
Nov 13 at 16:49
No, if you want it conditionally, you will need a VBA macro. You can insert a complete row or paste insert, but then it won't overwrite existing rows. If you want the overwriting to happen, you then also have to do the insert of a row yourself too.
– LPChip
Nov 13 at 16:49
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1375081%2fhow-do-i-automatically-insert-a-blank-row-when-i-add-a-new-table-row-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
No, if you want it conditionally, you will need a VBA macro. You can insert a complete row or paste insert, but then it won't overwrite existing rows. If you want the overwriting to happen, you then also have to do the insert of a row yourself too.
– LPChip
Nov 13 at 16:49