Excel 2011 for the Mac. There are a few problems (bugs) If you use VBA SaveAs or ExportAsFixedFormat or save a workbook manual as PDF. When you save the workbook as PDF it wil create a seperate PDF for each sheet in the workbook and it also add a sheet name to the file name of the PDF when you do it manual or with code.
You can help people work more efficiently in worksheets by using drop-down lists in cells where they can pick an item from a list you create.
WindowsmacOSOnline
Working with your drop-down list
After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.
If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet. For more information about how to protect a worksheet, see Lock cells to protect them.
If you decide you want to change the options in your drop-down list, see Add or remove items from a drop-down list.
![]()
To delete a drop-down list, see Remove a drop-down list.
Download our examples
You can download an example workbook with multiple data validation examples like the one in this article. You can follow along, or create your own data validation scenarios. Download Excel data validation examples.
Data entry is quicker and more accurate when you restrict values in a cell to choices from a drop-down list.
Start by making a list of valid entries on a sheet, and sort or rearrange the entries so that they appear in the order you want. Then you can use the entries as the source for your drop-down list of data. If the list is not large, you can easily refer to it and type the entries directly into the data validation tool.
See also
After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries. If you decide you want to change the options in your drop-down list, see Add or remove items from a drop-down list. To delete a drop-down list, see Remove a drop-down list.
Excel’s Formula Builder in Office 2011 for Mac is a tool in Toolbox designed to help you build cell formulas. You start at the top of the Formula Builder and work your way down to put a finished cell formula into an empty cell. The following example builds a formula to count the number of times the word apple is in a list. To follow along, type data into cells as shown in A1:D5 (or enter your own list where a word appears more than once). Then follow these steps:
In the example, when you’re done, the value of A6 depends upon the value of D2. Type a different fruit from the list into D2 and then click elsewhere. Watch as the count in A6 updates instantly.
You can use the Formula Builder to learn new functions. Suppose someone gives you a workbook that uses a function you’re unfamiliar with, and you want to understand how it works. Turn on the Formula Builder and then click on the mysterious formula. The Formula Builder shows you how the formula and its arguments were constructed.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |