Sunday, November 11, 2012

How to Create a Button Object in Excel Spreadsheet


1. Open Excel. Create a new spreadsheet or use an existing sheet.
2. Click the 'Insert' menu at the top of the Excel program window. Choose the 'Object' command. If the 'Object' command is not listed, the menu is automatically collapsed to show only the most frequently-used features. Click the double arrow at the bottom of the menu to expand and show all features. A pop-up window will appear after the 'Object' command is chosen.
3. Click the 'Create New' tab at the top of the 'Object' window if you wish to insert a blank object into the Excel spreadsheet. The object can be edited later, if desired. Alternately, click the 'Create from File' tab if you wish to insert an object from a file that already exists.
4. Choose the file type or the file name for your object. If creating a new blank object, scroll through the list of file types and click once on the program format you wish to create. For example, choose 'Microsoft Word Document' to create an object for Word in the Excel spreadsheet. If inserting an existing file, click the 'Browse' button on the 'Create from File' tab and locate the file on your computer and press the 'Insert' button.
5. Check the 'Display as icon' check box on either tab to create a button for the object. This will prevent the object from displaying as a full document within the Excel spreadsheet. Instead, the user will click a button to launch the object in its native program window.
6. Press the 'OK' button. The button object is created in the Excel spreadsheet.

Blogger news