Unable to expand cells in Microsoft Excel

I have an odd issue that I need your help with.

Within my spreadsheet there are many cells that although contain data, do not respond when I try to automatically resize them.

I've tried auto-fit, auto-hide (turning it off) etc.

Here is an image to show you what I am talking about

The only way that works is to re-size manually or double click when the re-size button displays.

I hope you can help

Thanks

edited Sep 29 '14 at 15:59

Excellll

11.1k74163

asked Sep 29 '14 at 8:42

user3088649

111

add a comment |

I have an odd issue that I need your help with.

Within my spreadsheet there are many cells that although contain data, do not respond when I try to automatically resize them.

I've tried auto-fit, auto-hide (turning it off) etc.

Here is an image to show you what I am talking about

The only way that works is to re-size manually or double click when the re-size button displays.

I hope you can help

Thanks

edited Sep 29 '14 at 15:59

Excellll

11.1k74163

asked Sep 29 '14 at 8:42

user3088649

111

add a comment |

I have an odd issue that I need your help with.

Within my spreadsheet there are many cells that although contain data, do not respond when I try to automatically resize them.

I've tried auto-fit, auto-hide (turning it off) etc.

Here is an image to show you what I am talking about

The only way that works is to re-size manually or double click when the re-size button displays.

I hope you can help

Thanks

edited Sep 29 '14 at 15:59

Excellll

11.1k74163

asked Sep 29 '14 at 8:42

user3088649

111

I have an odd issue that I need your help with.

Within my spreadsheet there are many cells that although contain data, do not respond when I try to automatically resize them.

I've tried auto-fit, auto-hide (turning it off) etc.

Here is an image to show you what I am talking about

The only way that works is to re-size manually or double click when the re-size button displays.

I hope you can help

Thanks

microsoft-excel microsoft-excel-2010 spreadsheet

edited Sep 29 '14 at 15:59

Excellll

11.1k74163

asked Sep 29 '14 at 8:42

user3088649

111

edited Sep 29 '14 at 15:59

Excellll

11.1k74163

asked Sep 29 '14 at 8:42

user3088649

111

edited Sep 29 '14 at 15:59

Excellll

11.1k74163

edited Sep 29 '14 at 15:59

Excellll

11.1k74163

edited Sep 29 '14 at 15:59

Excellll

11.1k74163

asked Sep 29 '14 at 8:42

user3088649

111

asked Sep 29 '14 at 8:42

user3088649

111

asked Sep 29 '14 at 8:42

user3088649

111

add a comment |

1 Answer
1

active

oldest

votes

Select the rows surrounding them and then right click and Unhide.

answered Sep 29 '14 at 16:18

Mr. Mascaro

36518

Thanks for the recommendation, doesn't work sadly

– user3088649
Sep 29 '14 at 17:10

Aha! got it - you need to re-hide them all and then unhide and it works. Thank you

– user3088649
Sep 29 '14 at 17:13

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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f818126%2funable-to-expand-cells-in-microsoft-excel%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Select the rows surrounding them and then right click and Unhide.

answered Sep 29 '14 at 16:18

Mr. Mascaro

36518

Thanks for the recommendation, doesn't work sadly

– user3088649
Sep 29 '14 at 17:10

Aha! got it - you need to re-hide them all and then unhide and it works. Thank you

– user3088649
Sep 29 '14 at 17:13

add a comment |

Select the rows surrounding them and then right click and Unhide.

answered Sep 29 '14 at 16:18

Mr. Mascaro

36518

Thanks for the recommendation, doesn't work sadly

– user3088649
Sep 29 '14 at 17:10

Aha! got it - you need to re-hide them all and then unhide and it works. Thank you

– user3088649
Sep 29 '14 at 17:13

add a comment |

Select the rows surrounding them and then right click and Unhide.

answered Sep 29 '14 at 16:18

Mr. Mascaro

36518

Select the rows surrounding them and then right click and Unhide.

answered Sep 29 '14 at 16:18

Mr. Mascaro

36518

answered Sep 29 '14 at 16:18

Mr. Mascaro

36518

answered Sep 29 '14 at 16:18

Mr. Mascaro

36518

answered Sep 29 '14 at 16:18

Mr. Mascaro

36518

Thanks for the recommendation, doesn't work sadly

– user3088649
Sep 29 '14 at 17:10

Aha! got it - you need to re-hide them all and then unhide and it works. Thank you

– user3088649
Sep 29 '14 at 17:13

add a comment |

Thanks for the recommendation, doesn't work sadly

– user3088649
Sep 29 '14 at 17:10

Aha! got it - you need to re-hide them all and then unhide and it works. Thank you

– user3088649
Sep 29 '14 at 17:13

Thanks for the recommendation, doesn't work sadly

– user3088649
Sep 29 '14 at 17:10

Aha! got it - you need to re-hide them all and then unhide and it works. Thank you

– user3088649
Sep 29 '14 at 17:13

add a comment |

draft saved

draft discarded

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.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Bdtyktl