Changing line insert default formatting
When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the row below instead?
microsoft-excel microsoft-excel-2003
edited Aug 16 '13 at 13:27
Excellll
11.2k74164
asked Aug 16 '13 at 13:06
WALLYWALLY
21112
add a comment |
When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the row below instead?
microsoft-excel microsoft-excel-2003
edited Aug 16 '13 at 13:27
Excellll
11.2k74164
asked Aug 16 '13 at 13:06
WALLYWALLY
21112
add a comment |
When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the row below instead?
microsoft-excel microsoft-excel-2003
edited Aug 16 '13 at 13:27
Excellll
11.2k74164
asked Aug 16 '13 at 13:06
WALLYWALLY
21112
When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the row below instead?
microsoft-excel microsoft-excel-2003
microsoft-excel microsoft-excel-2003
edited Aug 16 '13 at 13:27
Excellll
11.2k74164
asked Aug 16 '13 at 13:06
WALLYWALLY
21112
edited Aug 16 '13 at 13:27
Excellll
11.2k74164
asked Aug 16 '13 at 13:06
WALLYWALLY
21112
edited Aug 16 '13 at 13:27
Excellll
11.2k74164
edited Aug 16 '13 at 13:27
Excellll
11.2k74164
edited Aug 16 '13 at 13:27
Excellll
11.2k74164
11.2k74164
asked Aug 16 '13 at 13:06
WALLYWALLY
21112
asked Aug 16 '13 at 13:06
WALLYWALLY
21112
asked Aug 16 '13 at 13:06
WALLYWALLY
21112
21112
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
The Insert Options button - which is displayed when you insert a row and the adjacent cells have different formatting - is the only mechanism that Excel provides for controlling how inserted rows are formatted.
If the button is not being displayed, activate it by clicking the File tab on the ribbon and then clicking Excel Options. Click the Advanced tab, then check-mark the Show Insert Options buttons in the Cut, copy, and paste section and click OK.
answered Aug 17 '13 at 1:59
chuffchuff
3,12411017
Despite the KB article states that this applies to Office 2013 too, I highly doubt that. My insert button looks like this.. Any ideas what might be wrong? (sry for the non-english screenshot, but there is no option likeFormat Same as Below, onlyClear formatting)
– nixda
Aug 17 '13 at 8:21
1
Not sure, @nixda. I have 2010, and the Insert Options button shows up right after I've done the insertion.
– chuff
Aug 17 '13 at 16:13
add a comment |
Unless you want to venture into VBA programming, it's not possible to change the default.
FYI: in VBA you can use code like:
Rows("2:2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
' default is xlFormatFromLeftOrAbove
edited Dec 26 '17 at 21:56
condiosluzverde
6212922
answered Aug 19 '13 at 18:55
SeanCSeanC
3,33421426
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%2f632721%2fchanging-line-insert-default-formatting%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The Insert Options button - which is displayed when you insert a row and the adjacent cells have different formatting - is the only mechanism that Excel provides for controlling how inserted rows are formatted.
If the button is not being displayed, activate it by clicking the File tab on the ribbon and then clicking Excel Options. Click the Advanced tab, then check-mark the Show Insert Options buttons in the Cut, copy, and paste section and click OK.
answered Aug 17 '13 at 1:59
chuffchuff
3,12411017
Despite the KB article states that this applies to Office 2013 too, I highly doubt that. My insert button looks like this.. Any ideas what might be wrong? (sry for the non-english screenshot, but there is no option likeFormat Same as Below, onlyClear formatting)
– nixda
Aug 17 '13 at 8:21
1
Not sure, @nixda. I have 2010, and the Insert Options button shows up right after I've done the insertion.
– chuff
Aug 17 '13 at 16:13
add a comment |
The Insert Options button - which is displayed when you insert a row and the adjacent cells have different formatting - is the only mechanism that Excel provides for controlling how inserted rows are formatted.
If the button is not being displayed, activate it by clicking the File tab on the ribbon and then clicking Excel Options. Click the Advanced tab, then check-mark the Show Insert Options buttons in the Cut, copy, and paste section and click OK.
answered Aug 17 '13 at 1:59
chuffchuff
3,12411017
Despite the KB article states that this applies to Office 2013 too, I highly doubt that. My insert button looks like this.. Any ideas what might be wrong? (sry for the non-english screenshot, but there is no option likeFormat Same as Below, onlyClear formatting)
– nixda
Aug 17 '13 at 8:21
1
Not sure, @nixda. I have 2010, and the Insert Options button shows up right after I've done the insertion.
– chuff
Aug 17 '13 at 16:13
add a comment |
The Insert Options button - which is displayed when you insert a row and the adjacent cells have different formatting - is the only mechanism that Excel provides for controlling how inserted rows are formatted.
If the button is not being displayed, activate it by clicking the File tab on the ribbon and then clicking Excel Options. Click the Advanced tab, then check-mark the Show Insert Options buttons in the Cut, copy, and paste section and click OK.
answered Aug 17 '13 at 1:59
chuffchuff
3,12411017
The Insert Options button - which is displayed when you insert a row and the adjacent cells have different formatting - is the only mechanism that Excel provides for controlling how inserted rows are formatted.
If the button is not being displayed, activate it by clicking the File tab on the ribbon and then clicking Excel Options. Click the Advanced tab, then check-mark the Show Insert Options buttons in the Cut, copy, and paste section and click OK.
answered Aug 17 '13 at 1:59
chuffchuff
3,12411017
answered Aug 17 '13 at 1:59
chuffchuff
3,12411017
answered Aug 17 '13 at 1:59
chuffchuff
3,12411017
answered Aug 17 '13 at 1:59
chuffchuff
3,12411017
3,12411017
Despite the KB article states that this applies to Office 2013 too, I highly doubt that. My insert button looks like this.. Any ideas what might be wrong? (sry for the non-english screenshot, but there is no option likeFormat Same as Below, onlyClear formatting)
– nixda
Aug 17 '13 at 8:21
1
Not sure, @nixda. I have 2010, and the Insert Options button shows up right after I've done the insertion.
– chuff
Aug 17 '13 at 16:13
add a comment |
Despite the KB article states that this applies to Office 2013 too, I highly doubt that. My insert button looks like this.. Any ideas what might be wrong? (sry for the non-english screenshot, but there is no option likeFormat Same as Below, onlyClear formatting)
– nixda
Aug 17 '13 at 8:21
1
Not sure, @nixda. I have 2010, and the Insert Options button shows up right after I've done the insertion.
– chuff
Aug 17 '13 at 16:13
Despite the KB article states that this applies to Office 2013 too, I highly doubt that. My insert button looks like this.. Any ideas what might be wrong? (sry for the non-english screenshot, but there is no option like
Format Same as Below, only Clear formatting)– nixda
Aug 17 '13 at 8:21
Despite the KB article states that this applies to Office 2013 too, I highly doubt that. My insert button looks like this.. Any ideas what might be wrong? (sry for the non-english screenshot, but there is no option like
Format Same as Below, only Clear formatting)– nixda
Aug 17 '13 at 8:21
1
1
Not sure, @nixda. I have 2010, and the Insert Options button shows up right after I've done the insertion.
– chuff
Aug 17 '13 at 16:13
Not sure, @nixda. I have 2010, and the Insert Options button shows up right after I've done the insertion.
– chuff
Aug 17 '13 at 16:13
add a comment |
Unless you want to venture into VBA programming, it's not possible to change the default.
FYI: in VBA you can use code like:
Rows("2:2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
' default is xlFormatFromLeftOrAbove
edited Dec 26 '17 at 21:56
condiosluzverde
6212922
answered Aug 19 '13 at 18:55
SeanCSeanC
3,33421426
add a comment |
Unless you want to venture into VBA programming, it's not possible to change the default.
FYI: in VBA you can use code like:
Rows("2:2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
' default is xlFormatFromLeftOrAbove
edited Dec 26 '17 at 21:56
condiosluzverde
6212922
answered Aug 19 '13 at 18:55
SeanCSeanC
3,33421426
add a comment |
Unless you want to venture into VBA programming, it's not possible to change the default.
FYI: in VBA you can use code like:
Rows("2:2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
' default is xlFormatFromLeftOrAbove
edited Dec 26 '17 at 21:56
condiosluzverde
6212922
answered Aug 19 '13 at 18:55
SeanCSeanC
3,33421426
Unless you want to venture into VBA programming, it's not possible to change the default.
FYI: in VBA you can use code like:
Rows("2:2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromRightOrBelow
' default is xlFormatFromLeftOrAbove
edited Dec 26 '17 at 21:56
condiosluzverde
6212922
answered Aug 19 '13 at 18:55
SeanCSeanC
3,33421426
edited Dec 26 '17 at 21:56
condiosluzverde
6212922
edited Dec 26 '17 at 21:56
condiosluzverde
6212922
edited Dec 26 '17 at 21:56
condiosluzverde
6212922
6212922
answered Aug 19 '13 at 18:55
SeanCSeanC
3,33421426
answered Aug 19 '13 at 18:55
SeanCSeanC
3,33421426
answered Aug 19 '13 at 18:55
SeanCSeanC
3,33421426
3,33421426
add a comment |
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%2f632721%2fchanging-line-insert-default-formatting%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
