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
Highlighted
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.

1 Reply
Highlighted

@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?