Microsoft Office Tutorials and References
In Depth Information
HTML prototypes are great if you want to have your prototypes displayed in a
browser. It's easy to show your work to people who are remotely located by posting
your HTML prototype to a Web server. It's also unnecessary to prototype files to
other members of your team if they can access them online.
In an HTML file, hyperlinks that have been set up will work, but unfortunately any
drop-down boxes and certain cell features such as text flush left will not. In
addition, if you have more than one worksheet, the tabs will show up at the bottom
of the Web page, even if you have suppressed them in the workbook.
If you're using Internet Explorer (IE), you don't have to save your prototype as HTML.
You can simply open up a file in IE and get a similar effect. However, the result will
not look exactly like a Web page, since the Excel columns and rows will display.
Insert and Delete Cells Shortcuts
Windows and Macintosh operating systems now support multiple levels of undo and
redo. These two simple features can be used in combination with Excel's insert and delete
cell features to make precision sizing a breeze. You can use insert and delete cells to resize
elements for alignment (Figure A.5, page 214), as shown in the following procedure.
1. Select a single column in the All Contacts Toolbar
section, as shown in
Figure A.6 (page 214).
2. Right-click the selected cells and choose Insert (Figure A.7, page 215).
The Insert menu’s Cells command can also be used.
In the Insert dialog box, select Shift cells right
and click OK (Figure A.8,
The table is increased in size one column to the left. To continue to increase the
size, you no longer need the Insert command. You can use C TRL -Y to increase the
the table until
it matches the size of
the Recent Contacts section
(Figure A.9, page 216).