8. Getting More Out of Excel Ranges

Image

In this chapter, you’ll learn about various techniques for working with Excel ranges, including selecting, filling, copying, moving, deleting, naming, and formatting ranges.

→ Selecting ranges

→ Automatically filling a range with data

→ Copying, moving, inserting, and deleting ranges

→ Working with named ranges

→ Applying formatting to a range

For small worksheets, working with individual cells doesn’t usually present a problem. However, as your worksheets get larger, you’ll find that performing operations cell by cell wastes both time and energy. To overcome this, Excel lets you work with multiple cells in ...

Get My Office 2013 RT now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.