How do I insert rows in multiple excel tables simultaneously without vba?Excel: lock sheet, but keep tables...
What is the command to reset a PC without deleting any files
Typesetting a double Over Dot on top of a symbol
What to wear for invited talk in Canada
Is ipsum/ipsa/ipse a third person pronoun, or can it serve other functions?
Are objects structures and/or vice versa?
What causes the sudden spool-up sound from an F-16 when enabling afterburner?
Why airport relocation isn't done gradually?
How can I add custom success page
Can I find out the caloric content of bread by dehydrating it?
What is the meaning of "of trouble" in the following sentence?
Does the average primeness of natural numbers tend to zero?
Does it makes sense to buy a new cycle to learn riding?
Need help identifying/translating a plaque in Tangier, Morocco
What do the Banks children have against barley water?
Copycat chess is back
Should the British be getting ready for a no-deal Brexit?
A poker game description that does not feel gimmicky
New order #4: World
What is GPS' 19 year rollover and does it present a cybersecurity issue?
Why do UK politicians seemingly ignore opinion polls on Brexit?
How to make payment on the internet without leaving a money trail?
If a centaur druid Wild Shapes into a Giant Elk, do their Charge features stack?
What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?
Can I legally use front facing blue light in the UK?
How do I insert rows in multiple excel tables simultaneously without vba?
Excel: lock sheet, but keep tables expandableConsistantly insert rows from top of page in ExcelExpanding only selected rows in Excel using VBA MacrosExcel: Vertically ordered tables overlap when data changesExcel VBA Insert Rows above Cells with specific FormattingExcel: how to create multiple rows from oneHow to exempt specific rows from filter excel 2017?Stop Excel formula from changing when inserting/deleting rowsExcel VBA to merge filesHow do I copy formula across columns and rows, adjusting cell references and sheet names
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible?
The tables are in different sheets if that matter.
microsoft-excel microsoft-excel-2013
asked Feb 4 '16 at 16:23
SarovagaSarovaga
612
add a comment |
I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible?
The tables are in different sheets if that matter.
microsoft-excel microsoft-excel-2013
asked Feb 4 '16 at 16:23
SarovagaSarovaga
612
Welcome to Super User. Do you want to insert the row at the same point in each of the tables; i.e. insert between row 10 and 11? What have you attempted so far and where did you get stuck?
– CharlieRB
Feb 4 '16 at 16:31
@CharlieRB good answer, IMO. I didn't know that about excel :-P -- it almost seems like OP wants something formula-based (like add a row of data under certain circumstances, or something like that), which I think would only be doable with macros
– Code Jockey
Feb 4 '16 at 20:34
Unless the OP clarifies, we will never know. :-)
– CharlieRB
Feb 4 '16 at 20:52
Hi again, @CharlieRB something like what Code Jockey said is basically what I want. At the moment I can put my info on the first table and all the others update automatically, but if I add a row to the first table I need to manually add a row to each table.(The info still automatically fills in when I add rows in the other tables). What you answered charlieRB could work but its a bit tedious, especially since all my sheet tabs don't fit on one screen. I would also prefer it if it could be "Linked" to the tables instead of the position on the sheet.
– Sarovaga
Feb 5 '16 at 12:40
Your comment is far longer and more detailed than your question. I would suggest you edit your question to include what you desire and, because we are not a coding service, also include what you have attempted to resolve this yourself. As far as my answer goes, it was based on what little information you gave. It answers your question of "is this possible". BTW, all the tabs do not need to be visible for this answer to work properly. Simply click one tab, hold the shift key and select the last tab. It will highlight all in between.
– CharlieRB
Feb 5 '16 at 14:25
add a comment |
I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible?
The tables are in different sheets if that matter.
microsoft-excel microsoft-excel-2013
asked Feb 4 '16 at 16:23
SarovagaSarovaga
612
I have 12 tables, 1 for each month. I want to be able to insert a row to all tables simultaneously without vba. Is this possible?
The tables are in different sheets if that matter.
microsoft-excel microsoft-excel-2013
microsoft-excel microsoft-excel-2013
asked Feb 4 '16 at 16:23
SarovagaSarovaga
612
asked Feb 4 '16 at 16:23
SarovagaSarovaga
612
asked Feb 4 '16 at 16:23
SarovagaSarovaga
612
asked Feb 4 '16 at 16:23
SarovagaSarovaga
612
asked Feb 4 '16 at 16:23
SarovagaSarovaga
612
612
Welcome to Super User. Do you want to insert the row at the same point in each of the tables; i.e. insert between row 10 and 11? What have you attempted so far and where did you get stuck?
– CharlieRB
Feb 4 '16 at 16:31
@CharlieRB good answer, IMO. I didn't know that about excel :-P -- it almost seems like OP wants something formula-based (like add a row of data under certain circumstances, or something like that), which I think would only be doable with macros
– Code Jockey
Feb 4 '16 at 20:34
Unless the OP clarifies, we will never know. :-)
– CharlieRB
Feb 4 '16 at 20:52
Hi again, @CharlieRB something like what Code Jockey said is basically what I want. At the moment I can put my info on the first table and all the others update automatically, but if I add a row to the first table I need to manually add a row to each table.(The info still automatically fills in when I add rows in the other tables). What you answered charlieRB could work but its a bit tedious, especially since all my sheet tabs don't fit on one screen. I would also prefer it if it could be "Linked" to the tables instead of the position on the sheet.
– Sarovaga
Feb 5 '16 at 12:40
Your comment is far longer and more detailed than your question. I would suggest you edit your question to include what you desire and, because we are not a coding service, also include what you have attempted to resolve this yourself. As far as my answer goes, it was based on what little information you gave. It answers your question of "is this possible". BTW, all the tabs do not need to be visible for this answer to work properly. Simply click one tab, hold the shift key and select the last tab. It will highlight all in between.
– CharlieRB
Feb 5 '16 at 14:25
add a comment |
Welcome to Super User. Do you want to insert the row at the same point in each of the tables; i.e. insert between row 10 and 11? What have you attempted so far and where did you get stuck?
– CharlieRB
Feb 4 '16 at 16:31
@CharlieRB good answer, IMO. I didn't know that about excel :-P -- it almost seems like OP wants something formula-based (like add a row of data under certain circumstances, or something like that), which I think would only be doable with macros
– Code Jockey
Feb 4 '16 at 20:34
Unless the OP clarifies, we will never know. :-)
– CharlieRB
Feb 4 '16 at 20:52
Hi again, @CharlieRB something like what Code Jockey said is basically what I want. At the moment I can put my info on the first table and all the others update automatically, but if I add a row to the first table I need to manually add a row to each table.(The info still automatically fills in when I add rows in the other tables). What you answered charlieRB could work but its a bit tedious, especially since all my sheet tabs don't fit on one screen. I would also prefer it if it could be "Linked" to the tables instead of the position on the sheet.
– Sarovaga
Feb 5 '16 at 12:40
Your comment is far longer and more detailed than your question. I would suggest you edit your question to include what you desire and, because we are not a coding service, also include what you have attempted to resolve this yourself. As far as my answer goes, it was based on what little information you gave. It answers your question of "is this possible". BTW, all the tabs do not need to be visible for this answer to work properly. Simply click one tab, hold the shift key and select the last tab. It will highlight all in between.
– CharlieRB
Feb 5 '16 at 14:25
Welcome to Super User. Do you want to insert the row at the same point in each of the tables; i.e. insert between row 10 and 11? What have you attempted so far and where did you get stuck?
– CharlieRB
Feb 4 '16 at 16:31
Welcome to Super User. Do you want to insert the row at the same point in each of the tables; i.e. insert between row 10 and 11? What have you attempted so far and where did you get stuck?
– CharlieRB
Feb 4 '16 at 16:31
@CharlieRB good answer, IMO. I didn't know that about excel :-P -- it almost seems like OP wants something formula-based (like add a row of data under certain circumstances, or something like that), which I think would only be doable with macros
– Code Jockey
Feb 4 '16 at 20:34
@CharlieRB good answer, IMO. I didn't know that about excel :-P -- it almost seems like OP wants something formula-based (like add a row of data under certain circumstances, or something like that), which I think would only be doable with macros
– Code Jockey
Feb 4 '16 at 20:34
Unless the OP clarifies, we will never know. :-)
– CharlieRB
Feb 4 '16 at 20:52
Unless the OP clarifies, we will never know. :-)
– CharlieRB
Feb 4 '16 at 20:52
Hi again, @CharlieRB something like what Code Jockey said is basically what I want. At the moment I can put my info on the first table and all the others update automatically, but if I add a row to the first table I need to manually add a row to each table.(The info still automatically fills in when I add rows in the other tables). What you answered charlieRB could work but its a bit tedious, especially since all my sheet tabs don't fit on one screen. I would also prefer it if it could be "Linked" to the tables instead of the position on the sheet.
– Sarovaga
Feb 5 '16 at 12:40
Hi again, @CharlieRB something like what Code Jockey said is basically what I want. At the moment I can put my info on the first table and all the others update automatically, but if I add a row to the first table I need to manually add a row to each table.(The info still automatically fills in when I add rows in the other tables). What you answered charlieRB could work but its a bit tedious, especially since all my sheet tabs don't fit on one screen. I would also prefer it if it could be "Linked" to the tables instead of the position on the sheet.
– Sarovaga
Feb 5 '16 at 12:40
Your comment is far longer and more detailed than your question. I would suggest you edit your question to include what you desire and, because we are not a coding service, also include what you have attempted to resolve this yourself. As far as my answer goes, it was based on what little information you gave. It answers your question of "is this possible". BTW, all the tabs do not need to be visible for this answer to work properly. Simply click one tab, hold the shift key and select the last tab. It will highlight all in between.
– CharlieRB
Feb 5 '16 at 14:25
Your comment is far longer and more detailed than your question. I would suggest you edit your question to include what you desire and, because we are not a coding service, also include what you have attempted to resolve this yourself. As far as my answer goes, it was based on what little information you gave. It answers your question of "is this possible". BTW, all the tabs do not need to be visible for this answer to work properly. Simply click one tab, hold the shift key and select the last tab. It will highlight all in between.
– CharlieRB
Feb 5 '16 at 14:25
add a comment |
1 Answer
1
active
oldest
votes
You can make changes to multiple sheets simultaneously by selecting multiple tabs.
If you want to insert a row at the same point in all sheets, you can do the following.
- Select all of the tabs at the bottom of the workbook.
- Select the row below where you want the new row inserted.
- Right click and choose
insertfrom the menu.
You now have a new row in all the selected sheets.
NOTE: Remember to unselect the multiple sheets. Otherwise any further changes will occur on all selected sheets.
answered Feb 4 '16 at 16:35
CharlieRBCharlieRB
20.6k44493
Do I have to have that cursor set? :-P -- if so, where do I get it?
– Code Jockey
Feb 4 '16 at 20:35
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2f1035672%2fhow-do-i-insert-rows-in-multiple-excel-tables-simultaneously-without-vba%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can make changes to multiple sheets simultaneously by selecting multiple tabs.
If you want to insert a row at the same point in all sheets, you can do the following.
- Select all of the tabs at the bottom of the workbook.
- Select the row below where you want the new row inserted.
- Right click and choose
insertfrom the menu.
You now have a new row in all the selected sheets.
NOTE: Remember to unselect the multiple sheets. Otherwise any further changes will occur on all selected sheets.
answered Feb 4 '16 at 16:35
CharlieRBCharlieRB
20.6k44493
Do I have to have that cursor set? :-P -- if so, where do I get it?
– Code Jockey
Feb 4 '16 at 20:35
add a comment |
You can make changes to multiple sheets simultaneously by selecting multiple tabs.
If you want to insert a row at the same point in all sheets, you can do the following.
- Select all of the tabs at the bottom of the workbook.
- Select the row below where you want the new row inserted.
- Right click and choose
insertfrom the menu.
You now have a new row in all the selected sheets.
NOTE: Remember to unselect the multiple sheets. Otherwise any further changes will occur on all selected sheets.
answered Feb 4 '16 at 16:35
CharlieRBCharlieRB
20.6k44493
Do I have to have that cursor set? :-P -- if so, where do I get it?
– Code Jockey
Feb 4 '16 at 20:35
add a comment |
You can make changes to multiple sheets simultaneously by selecting multiple tabs.
If you want to insert a row at the same point in all sheets, you can do the following.
- Select all of the tabs at the bottom of the workbook.
- Select the row below where you want the new row inserted.
- Right click and choose
insertfrom the menu.
You now have a new row in all the selected sheets.
NOTE: Remember to unselect the multiple sheets. Otherwise any further changes will occur on all selected sheets.
answered Feb 4 '16 at 16:35
CharlieRBCharlieRB
20.6k44493
You can make changes to multiple sheets simultaneously by selecting multiple tabs.
If you want to insert a row at the same point in all sheets, you can do the following.
- Select all of the tabs at the bottom of the workbook.
- Select the row below where you want the new row inserted.
- Right click and choose
insertfrom the menu.
You now have a new row in all the selected sheets.
NOTE: Remember to unselect the multiple sheets. Otherwise any further changes will occur on all selected sheets.
answered Feb 4 '16 at 16:35
CharlieRBCharlieRB
20.6k44493
answered Feb 4 '16 at 16:35
CharlieRBCharlieRB
20.6k44493
answered Feb 4 '16 at 16:35
CharlieRBCharlieRB
20.6k44493
answered Feb 4 '16 at 16:35
CharlieRBCharlieRB
20.6k44493
20.6k44493
Do I have to have that cursor set? :-P -- if so, where do I get it?
– Code Jockey
Feb 4 '16 at 20:35
add a comment |
Do I have to have that cursor set? :-P -- if so, where do I get it?
– Code Jockey
Feb 4 '16 at 20:35
Do I have to have that cursor set? :-P -- if so, where do I get it?
– Code Jockey
Feb 4 '16 at 20:35
Do I have to have that cursor set? :-P -- if so, where do I get it?
– Code Jockey
Feb 4 '16 at 20:35
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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%2f1035672%2fhow-do-i-insert-rows-in-multiple-excel-tables-simultaneously-without-vba%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
Welcome to Super User. Do you want to insert the row at the same point in each of the tables; i.e. insert between row 10 and 11? What have you attempted so far and where did you get stuck?
– CharlieRB
Feb 4 '16 at 16:31
@CharlieRB good answer, IMO. I didn't know that about excel :-P -- it almost seems like OP wants something formula-based (like add a row of data under certain circumstances, or something like that), which I think would only be doable with macros
– Code Jockey
Feb 4 '16 at 20:34
Unless the OP clarifies, we will never know. :-)
– CharlieRB
Feb 4 '16 at 20:52
Hi again, @CharlieRB something like what Code Jockey said is basically what I want. At the moment I can put my info on the first table and all the others update automatically, but if I add a row to the first table I need to manually add a row to each table.(The info still automatically fills in when I add rows in the other tables). What you answered charlieRB could work but its a bit tedious, especially since all my sheet tabs don't fit on one screen. I would also prefer it if it could be "Linked" to the tables instead of the position on the sheet.
– Sarovaga
Feb 5 '16 at 12:40
Your comment is far longer and more detailed than your question. I would suggest you edit your question to include what you desire and, because we are not a coding service, also include what you have attempted to resolve this yourself. As far as my answer goes, it was based on what little information you gave. It answers your question of "is this possible". BTW, all the tabs do not need to be visible for this answer to work properly. Simply click one tab, hold the shift key and select the last tab. It will highlight all in between.
– CharlieRB
Feb 5 '16 at 14:25