EXCEL - Setting default row height in combination with word wrap

%3CLINGO-SUB%20id%3D%22lingo-sub-1471660%22%20slang%3D%22en-US%22%3EEXCEL%20-%20Setting%20default%20row%20height%20in%20combination%20with%20word%20wrap%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1471660%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20make%20a%20more%20user-friendly%20worksheet%20for%20rapidly%20entering%20moderate%20amounts%20of%20data.%26nbsp%3B%20My%20data%20is%20in%20a%20standard%20matrix%20with%20the%20fields%20as%20columns%20and%20the%20entries%20as%20rows.%26nbsp%3B%20The%20default%20row%20height%20is%20only%2015%2C%20but%20for%20better%20readability%20I%20would%20like%20it%20to%20be%20about%2025.%26nbsp%3B%20Unfortunately%2C%20I%20have%20to%20employ%20word%20wrap%20as%20some%20fields%20may%20contain%20a%20longer%20amount%20of%20text%20than%20will%20fit%20in%20the%20column.%26nbsp%3B%20And%20to%20get%20all%20the%20columns%20on%20one%20screen%20and%20avoid%20having%20to%20scroll%20horizontally%2C%20I%20have%20to%20keep%20their%20sizes%20confined.%3C%2FP%3E%3CP%3EI%20have%20tried%20using%20a%20table%20and%20the%20data%20entry%20form%20it%20offers%20(I%20love%20it)%2C%20but%20my%20employees%20all%20complain%20that%20the%20form%20size%20is%20too%20small%20to%20see%20clearly%2C%20and%20I%20haven't%20found%20any%20way%20(other%20than%20blowing%20up%20the%20whole%20screen%20size%2C%20which%20limits%20what%20will%20fit%20on%20it)%20to%20get%20the%20data%20entry%20form%20enlarged.%26nbsp%3B%20So%20that's%20my%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1471660%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1472474%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20-%20Setting%20default%20row%20height%20in%20combination%20with%20word%20wrap%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1472474%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702552%22%20target%3D%22_blank%22%3E%40JackWood%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20if%20I%20can%20paraphrase%2C%20you%20want%20your%20users%20to%20be%20able%20to%20eat%20their%20cake%20and%20have%20it%20too.%20That%20about%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20a%20serious%20note%2C%20given%20your%20description%2C%20I%20find%20myself%20wondering%20what%20kind%20of%20project%20you're%20working%20on%20and%20whether%20(possibly)%20Excel%20is%20the%20wrong%20software%20package.%20It's%20forte%20is%20not%20large%20strings%20of%20text%3B%20not%20that%20it's%20devoid%20of%20ability%20to%20work%20well%20with%20text.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20don't%20know%20whether%20what%20you're%20asking%20is%20feasible%20or%20possible%2C%20but%20if%20it's%20not%20asking%20too%20much%2C%20could%20you%20step%20back%20and%20describe%20the%20goals%20and%20why%20you've%20picked%20Excel%20over%2C%20say%2C%20Word%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792166%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20-%20Setting%20default%20row%20height%20in%20combination%20with%20word%20wrap%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F702552%22%20target%3D%22_blank%22%3E%40JackWood%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20similar%20challenge%20with%20entering%20text%20into%20cells%20when%20the%20amount%20of%20text%20is%20larger%20than%20the%20default%20row%20height.%3C%2FP%3E%3CP%3EI've%20had%20some%20success%20in%20splitting%20the%20text%20content%20laterally%20in%20the%20same%20row%2C%20and%20in%20a%20few%20cases%20separating%20the%20text%20into%20logical%20groups%20into%20the%20next%20row%20(or%20several%20rows).%3C%2FP%3E%3CP%3EWhen%20I%20have%20a%20topic%20with%20a%20list%20of%20alternative%20bullets%20(letters%20or%20numbers)%20below%20that%20relate%20to%20that%20specific%20topic%2C%20I%20can't%20separate%20the%20text%20content.%3C%2FP%3E%3CP%3EThe%20users%20tell%20me%20that%20the%20Word%20format%20isn't%20as%20useful%20as%20Excel%20(I've%20tried%20both%20formats).%3C%2FP%3E%3CP%3EThe%20best%20alternative%20for%20me%20in%20my%20project%20is%20to%20set%20the%20default%20row%20height%20higher%20so%20that%20%22word%20wrap%22%20simply%20expands%20the%20row%20height%20enough%20to%20show%20the%20contents.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792168%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20-%20Setting%20default%20row%20height%20in%20combination%20with%20word%20wrap%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792168%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20similar%20challenge%20with%20entering%20text%20into%20cells%20when%20the%20amount%20of%20text%20is%20larger%20than%20the%20default%20row%20height.%3C%2FP%3E%3CP%3EI've%20had%20some%20success%20in%20splitting%20the%20text%20content%20laterally%20in%20the%20same%20row%2C%20and%20in%20a%20few%20cases%20separating%20the%20text%20into%20logical%20groups%20into%20the%20next%20row%20(or%20several%20rows).%3C%2FP%3E%3CP%3EWhen%20I%20have%20a%20topic%20with%20a%20list%20of%20alternative%20bullets%20(letters%20or%20numbers)%20below%20that%20relate%20to%20that%20specific%20topic%2C%20I%20can't%20separate%20the%20text%20content.%3C%2FP%3E%3CP%3EThe%20users%20tell%20me%20that%20the%20Word%20format%20isn't%20as%20useful%20as%20Excel%20(I've%20tried%20both%20formats).%3C%2FP%3E%3CP%3EThe%20best%20alternative%20for%20me%20in%20my%20project%20is%20to%20set%20the%20default%20row%20height%20higher%20so%20that%20%22word%20wrap%22%20simply%20expands%20the%20row%20height%20enough%20to%20show%20the%20contents.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792398%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20-%20Setting%20default%20row%20height%20in%20combination%20with%20word%20wrap%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792398%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F659960%22%20target%3D%22_blank%22%3E%40Pat_Walsh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20question%20I%20asked%20the%20original%20poster%20in%20this%20thread%3A%20what%20is%20the%20nature%20of%20the%20project%20or%20task%20here%3F%20Are%20you%20using%20Excel%20solely%20for%20its%20nice%20row%20and%20column%20layout%20of%20cells%2C%20or%20are%20you%20also%20using%20it%20for%20calculations%2C%20functions%2C%20sorting%20or%20sifting%3F%20Calculations%20can%20include%20text%20functions%20as%20well....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20if%20all%20you're%20doing%20is%20entering%20text%20and%20wanting%20it%20to%20look%20organized%2C%20then%20despite%20what%20your%20users%20might%20be%20saying%2C%20it%20seems%20to%20me%20that%20Word%20would%20be%20the%20default%3A%20it's%20far%20more%20capable%20of%20handling%20lots%20and%20lots%20of%20text%2C%20and%20the%20table%20format%20in%20Word%20is%20quite%20versatile.%20Each%20program%20has%20its%20advantages%20and%20disadvantages%2C%20of%20course%2C%20but%20I%20haven't%20seen%20anything%20in%20what%20you've%20written%20to%20convince%20me%20that%20Excel%20is%20the%20right%20choice.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to make a more user-friendly worksheet for rapidly entering moderate amounts of data.  My data is in a standard matrix with the fields as columns and the entries as rows.  The default row height is only 15, but for better readability I would like it to be about 25.  Unfortunately, I have to employ word wrap as some fields may contain a longer amount of text than will fit in the column.  And to get all the columns on one screen and avoid having to scroll horizontally, I have to keep their sizes confined.

I have tried using a table and the data entry form it offers (I love it), but my employees all complain that the form size is too small to see clearly, and I haven't found any way (other than blowing up the whole screen size, which limits what will fit on it) to get the data entry form enlarged.  So that's my problem.

4 Replies

@JackWood 

 

So if I can paraphrase, you want your users to be able to eat their cake and have it too. That about right?

 

On a serious note, given your description, I find myself wondering what kind of project you're working on and whether (possibly) Excel is the wrong software package. It's forte is not large strings of text; not that it's devoid of ability to work well with text.

 

I really don't know whether what you're asking is feasible or possible, but if it's not asking too much, could you step back and describe the goals and why you've picked Excel over, say, Word?

@JackWood 

I have a similar challenge with entering text into cells when the amount of text is larger than the default row height.

I've had some success in splitting the text content laterally in the same row, and in a few cases separating the text into logical groups into the next row (or several rows).

When I have a topic with a list of alternative bullets (letters or numbers) below that relate to that specific topic, I can't separate the text content.

The users tell me that the Word format isn't as useful as Excel (I've tried both formats).

The best alternative for me in my project is to set the default row height higher so that "word wrap" simply expands the row height enough to show the contents.

@mathetes 

I have a similar challenge with entering text into cells when the amount of text is larger than the default row height.

I've had some success in splitting the text content laterally in the same row, and in a few cases separating the text into logical groups into the next row (or several rows).

When I have a topic with a list of alternative bullets (letters or numbers) below that relate to that specific topic, I can't separate the text content.

The users tell me that the Word format isn't as useful as Excel (I've tried both formats).

The best alternative for me in my project is to set the default row height higher so that "word wrap" simply expands the row height enough to show the contents.

@Pat_Walsh 

 

Same question I asked the original poster in this thread: what is the nature of the project or task here? Are you using Excel solely for its nice row and column layout of cells, or are you also using it for calculations, functions, sorting or sifting? Calculations can include text functions as well....

 

But if all you're doing is entering text and wanting it to look organized, then despite what your users might be saying, it seems to me that Word would be the default: it's far more capable of handling lots and lots of text, and the table format in Word is quite versatile. Each program has its advantages and disadvantages, of course, but I haven't seen anything in what you've written to convince me that Excel is the right choice.