How can I add a drop-down list to a cell so the user can choose a value from the list?
Type the list of valid entries in a single column (this column can be hidden, if desired). Select the cell or cells that will display the list of entries, choose Data – Validation, and select the Settings tab. From the Allow drop-down list, select List. In the Source box, enter a range address or a reference to the items in your sheet. Make sure the In-cell dropdown box is selected. This technique does not require any macros. How can I increase the number of columns in a worksheet? You can’t. This number is fixed and cannot be changed. How can I increase the number of rows in a worksheet? See the answer to the previous question. Is it possible to change the color and font of the sheet tabs? You can’t change the color. You can, however, change the font size. In the Windows Control Panel, select Display. In the Display Properties dialog box, click the Appearance tab. In the Item list, select Scrollbar. Use the spinner to increase or decrease the size. This setting will affect other progr