O'Reilly logo

Microsoft Office 2016 Step by Step by Curtis Frye, Joan Lambert

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

7. Manage worksheet data

In this chapter

Image Limit data that appears on your screen

Image Manipulate worksheet data

Image Define valid sets of values for ranges of cells

Practice files

For this chapter, use the practice files from the Office2016SBS\Ch07 folder. For practice file download instructions, see the introduction.

With Excel 2016, you can manage huge data collections, but storing more than 1 million rows of data doesn’t help you make business decisions ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required