see more In which group on the ribbon can we find the Wrap text command Excel provides a Wrap Text option in the Alignment group on the Home tab of the ribbon. Then select Format > AutoFit Row Height or AutoFit Column Width from the Home tab. I've shown the same here:īut when I'm retrieving the same range name using formula, it's not showing the range. Just select the cells containing the wrap texts. Now the problem is, if I directly set the source of B11 with some named-range, say country1, it's successfully showing the values. In other words, a named-range has to be set as source for B11 depending on value from A11. As an example, if I choose 'England', then values in B11 must contain IJ, KL. Named-ranges country2 and countr圓 represent B5-B6 and B8-B9 respectively.Ĭell A11 is a drop down list with range 'countries' as source so that it contains values : INDIA, ENGLAND ,AUSTRALIA.Ĭell B11 is another drop down list whose values are to be determined by the value chosen in A11 i.e. To change the name of some other sheet, you first need to activate it and then use the above steps. This will get the sheet name into edit mode Enter the name that you want for the sheet This method would only allow you to change the name of the current sheet. I've attached a snapshot for better understanding.Ĭells A1-A3 are represented by named-range countriesĬells B2-B3 are represented by name-range country1. In the Cell group, click on the ‘Format’ option Click on the Rename Sheet option. I've been trying to work on this thing in OpenOffice Calc, where I have two drop lists in a spreadsheet, in which data is coming from other columns.

Openoffice spread sheet wrap cell