Skip to Main Content
Effective Prototyping with Excel
book

Effective Prototyping with Excel

by Nevin Berger, Michael Arent, Jonathan Arnowitz, Fred Sampson
January 2009
Intermediate to advanced content levelIntermediate to advanced
240 pages
4h 44m
English
Morgan Kaufmann
Content preview from Effective Prototyping with Excel
Appendix A. Useful Techniques with Excel
In this appendix you will learn to
▪ Eliminate background gridlines
▪ Set page attributes for the canvas
▪ Format table cells
▪ Use the drawing menu
▪ Create hyperlinks
▪ Save as HTML
▪ Insert and delete cells shortcuts
▪ Use drag-and-drop shortcuts
▪ Copy and paste
▪ Work with graphics

Introduction

This appendix includes a number of hints, gathered together here from the chapters in which they first appeared, which you might find useful while building prototypes in Excel.
As you discover new techniques and shortcuts in Excel, we invite you to share them by emailing them to mailto:tips@effectiveprototyping.com. We will post them on our site so that everyone can share in your discovery.

Creating the Canvas

To Turn Off ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

VBA Automation for Excel 2019 Cookbook

VBA Automation for Excel 2019 Cookbook

Mike Van Niekerk
101 Ready-To-Use Excel Macros

101 Ready-To-Use Excel Macros

Michael Alexander, John Walkenbach

Publisher Resources

ISBN: 9780120885824