how to create drop down in openoffice excel

This method can be useful to quickly change the print range without highlighting a large area of cells every time. Select the defined print range and click OK. The previously defined area now appears in the drop-down box under Print range. The name of your range cannot contain any spaces. Make sure that each group of cells is separated with a semicolon.

For example, to select the rectangle with A3 as the top left cell and F20 as the bottom right cell, enter $A$3:$F$20 or A3:F20 (both work and are equivalent) after the initial selection. To include more than one group of cells in the selection, type in the additional ranges. On the Define Names dialog (Figure 86), create a name for the range and enter it into the text box.Ĭlick the More button and then select the Print range checkbox. (The cells can be highlighted after opening the Define Names dialog as well.) XLSXCreate a schedule of events with mini calendars that highlight event dates.

Highlight the cells you want to define as a print range and select Insert > Names > Define. XLSXODSGSOur original calendar template for Excel, OpenOffice and Google. To define a print range, use the same procedure as labeling an area of the sheet. Several different print ranges can be defined to meet this need. This may be useful, for example, if there are different areas of a large spreadsheet that need to be printed for different reports. Review the Excel workbook’s suggested file name in the Export-Excel Spreadsheet dialog box (Microsoft Access uses the name of the source object).

Click Excel under the Export group on the External Data tab. In addition to highlighting a print range for each print job, you can define a range of cells to be used repeatedly. Go to the External Data tab of the Microsoft Access ribbon and click Excel under the Export group.

How to create drop down in openoffice excel