Ask Your Question

View the number in a cell displaying "###" without making cell wider? [closed]

asked 2017-06-13 06:04:56 +0200

appreciatethehelp gravatar image

updated 2020-08-10 13:43:35 +0200

Alex Kemp gravatar image

In a spreadsheet I am working on, there is only one cell with a number large enough to make the cell display "###". I don't want to widen the column this cell is in for aesthetic reasons, so is there any other way to view the number?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-06-16 07:54:36.668768


Change the font size.

Ratslinger gravatar imageRatslinger ( 2017-06-13 06:26:44 +0200 )edit

Or if you wish to keep all cells the same width, modify other cells to match the width the ### cell needs to display properly.

robleyd gravatar imagerobleyd ( 2017-06-13 08:29:09 +0200 )edit

@Ratslinger I was more wondering if one could perhaps click on the cell and perform some process to get it to display the contents whilst it is selected, then it would go back to "###" when it isn't selected anymore.

Perhaps I'm just being picky but I just wanted to keep all the cells and fonts the same size.

@robleyd good suggestion, however there are a lot of cells and information in this particular spreadsheet so doing this would make it unreasonably large and difficult to read.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-06-13 14:18:45 +0200 )edit

Both great suggestions though.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-06-13 14:18:59 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-06-13 08:54:27 +0200

JohnSUN gravatar image

updated 2017-06-13 14:59:30 +0200

You can use Format - Cells...(Ctrl+1) - Alignment - Shrink to fit cell size

Shrink to fit cell size

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-06-13 06:04:56 +0200

Seen: 132 times

Last updated: Jun 13 '17