Skip to Main Content
Teach Yourself VISUALLY Excel 2016
book

Teach Yourself VISUALLY Excel 2016

by Paul McFedries
October 2015
Beginner content levelBeginner
352 pages
9h 32m
English
Visual
Content preview from Teach Yourself VISUALLY Excel 2016

CHAPTER 1

Working with Ranges

image

In Excel, a range is a collection of two or more cells that you work with as a group rather than separately. This enables you to fill the range with values, move or copy the range, sort the range data, and insert and delete ranges. You learn these and other range techniques in this chapter.

Select a Range

Fill a Range with the Same Data

Fill a Range with a Series of Values

Flash Fill a Range

Move or Copy a Range

Insert a Row or Column

Insert a Cell or Range

Delete Data from a Range

Delete a Range

Hide a Row or Column

Freeze Rows or Columns

Merge Two or More Cells

Transpose Rows and Columns

Select and Enter Data ...

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

Excel 2010 Made Simple

Excel 2010 Made Simple

Abbott Katz

Publisher Resources

ISBN: 9781119074731Purchase book