Excel prepends extra line (but not carriage return) in mult-line cells
up vote
2
down vote
favorite
Sometimes I use ALT + ENTER to make multi-line cells.
However, Excel often appears to prepend an extra line for some reason, even though it's not an actual carriage return. Usually, you can adjust the size of the cell and make the apparent extra line go away. Sometimes you can't, or it requires adjusting things that don't make sense.
How can I get rid of the visible extra line at the beginning of a cell when it's not a carriage return from something like ALT + ENTER?
I've been dealing with this for many years through many versions of excel, so I don't think a specific version is warranted in the tag.
The usual work around
Usually, you can autoadjust the size of the column and then autosize the row and that takes care of it. Sometimes you have to make the column much more wider than the contents of the cell, autosize the row, and then can autosize the column.
Artificial Example Screenshots
This is an artificial example, but happens to show the white space I am referring to, albeit much more than I get when there's a problem. I made this by typing the lines, at which point Excel made it a very tall cell. I autosized the column on the X axis, and this is what was left. Similar but different to what I do when I encounter the problem. Since the problem is not very repeatable, there's no way for me to force a natural screenshot.
This is what it looks like after I auto size the row:
microsoft-excel
asked Nov 30 at 15:55
YetAnotherRandomUser
84331230
add a comment |
up vote
2
down vote
favorite
Sometimes I use ALT + ENTER to make multi-line cells.
However, Excel often appears to prepend an extra line for some reason, even though it's not an actual carriage return. Usually, you can adjust the size of the cell and make the apparent extra line go away. Sometimes you can't, or it requires adjusting things that don't make sense.
How can I get rid of the visible extra line at the beginning of a cell when it's not a carriage return from something like ALT + ENTER?
I've been dealing with this for many years through many versions of excel, so I don't think a specific version is warranted in the tag.
The usual work around
Usually, you can autoadjust the size of the column and then autosize the row and that takes care of it. Sometimes you have to make the column much more wider than the contents of the cell, autosize the row, and then can autosize the column.
Artificial Example Screenshots
This is an artificial example, but happens to show the white space I am referring to, albeit much more than I get when there's a problem. I made this by typing the lines, at which point Excel made it a very tall cell. I autosized the column on the X axis, and this is what was left. Similar but different to what I do when I encounter the problem. Since the problem is not very repeatable, there's no way for me to force a natural screenshot.
This is what it looks like after I auto size the row:
microsoft-excel
asked Nov 30 at 15:55
YetAnotherRandomUser
84331230
Can you provide some screen caps showing this behaviour?
– cybernetic.nomad
Nov 30 at 16:15
Have you ever tried Backspace!! What I did,, entered word pressed ALT+Enter then One more word,, ALt+Enter few times,, and used Backspace, Excel then removes white spaces.
– Rajesh S
Dec 1 at 6:41
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
Sometimes I use ALT + ENTER to make multi-line cells.
However, Excel often appears to prepend an extra line for some reason, even though it's not an actual carriage return. Usually, you can adjust the size of the cell and make the apparent extra line go away. Sometimes you can't, or it requires adjusting things that don't make sense.
How can I get rid of the visible extra line at the beginning of a cell when it's not a carriage return from something like ALT + ENTER?
I've been dealing with this for many years through many versions of excel, so I don't think a specific version is warranted in the tag.
The usual work around
Usually, you can autoadjust the size of the column and then autosize the row and that takes care of it. Sometimes you have to make the column much more wider than the contents of the cell, autosize the row, and then can autosize the column.
Artificial Example Screenshots
This is an artificial example, but happens to show the white space I am referring to, albeit much more than I get when there's a problem. I made this by typing the lines, at which point Excel made it a very tall cell. I autosized the column on the X axis, and this is what was left. Similar but different to what I do when I encounter the problem. Since the problem is not very repeatable, there's no way for me to force a natural screenshot.
This is what it looks like after I auto size the row:
microsoft-excel
asked Nov 30 at 15:55
YetAnotherRandomUser
84331230
Sometimes I use ALT + ENTER to make multi-line cells.
However, Excel often appears to prepend an extra line for some reason, even though it's not an actual carriage return. Usually, you can adjust the size of the cell and make the apparent extra line go away. Sometimes you can't, or it requires adjusting things that don't make sense.
How can I get rid of the visible extra line at the beginning of a cell when it's not a carriage return from something like ALT + ENTER?
I've been dealing with this for many years through many versions of excel, so I don't think a specific version is warranted in the tag.
The usual work around
Usually, you can autoadjust the size of the column and then autosize the row and that takes care of it. Sometimes you have to make the column much more wider than the contents of the cell, autosize the row, and then can autosize the column.
Artificial Example Screenshots
This is an artificial example, but happens to show the white space I am referring to, albeit much more than I get when there's a problem. I made this by typing the lines, at which point Excel made it a very tall cell. I autosized the column on the X axis, and this is what was left. Similar but different to what I do when I encounter the problem. Since the problem is not very repeatable, there's no way for me to force a natural screenshot.
This is what it looks like after I auto size the row:
microsoft-excel
microsoft-excel
asked Nov 30 at 15:55
YetAnotherRandomUser
84331230
asked Nov 30 at 15:55
YetAnotherRandomUser
84331230
edited Nov 30 at 16:34
asked Nov 30 at 15:55
YetAnotherRandomUser
84331230
asked Nov 30 at 15:55
YetAnotherRandomUser
84331230
asked Nov 30 at 15:55
YetAnotherRandomUser
84331230
84331230
Can you provide some screen caps showing this behaviour?
– cybernetic.nomad
Nov 30 at 16:15
Have you ever tried Backspace!! What I did,, entered word pressed ALT+Enter then One more word,, ALt+Enter few times,, and used Backspace, Excel then removes white spaces.
– Rajesh S
Dec 1 at 6:41
add a comment |
Can you provide some screen caps showing this behaviour?
– cybernetic.nomad
Nov 30 at 16:15
Have you ever tried Backspace!! What I did,, entered word pressed ALT+Enter then One more word,, ALt+Enter few times,, and used Backspace, Excel then removes white spaces.
– Rajesh S
Dec 1 at 6:41
Can you provide some screen caps showing this behaviour?
– cybernetic.nomad
Nov 30 at 16:15
Can you provide some screen caps showing this behaviour?
– cybernetic.nomad
Nov 30 at 16:15
Have you ever tried Backspace!! What I did,, entered word pressed ALT+Enter then One more word,, ALt+Enter few times,, and used Backspace, Excel then removes white spaces.
– Rajesh S
Dec 1 at 6:41
Have you ever tried Backspace!! What I did,, entered word pressed ALT+Enter then One more word,, ALt+Enter few times,, and used Backspace, Excel then removes white spaces.
– Rajesh S
Dec 1 at 6:41
add a comment |
active
oldest
votes
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%2f1379778%2fexcel-prepends-extra-line-but-not-carriage-return-in-mult-line-cells%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1379778%2fexcel-prepends-extra-line-but-not-carriage-return-in-mult-line-cells%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
Can you provide some screen caps showing this behaviour?
– cybernetic.nomad
Nov 30 at 16:15
Have you ever tried Backspace!! What I did,, entered word pressed ALT+Enter then One more word,, ALt+Enter few times,, and used Backspace, Excel then removes white spaces.
– Rajesh S
Dec 1 at 6:41