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 ...

Get Microsoft Office 2016 Step by Step 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.