Teach Yourself VISUALLY Excel 2016

CHAPTER 5

Manipulating Worksheets

An Excel worksheet is where you enter your headings and data and build your formulas. You will spend most of your time in Excel operating within a worksheet, so you need to know how to navigate and perform worksheet tasks such as renaming, moving, copying, and deleting.

Navigate a Worksheet

Rename a Worksheet

Create a New Worksheet

Move a Worksheet

Copy a Worksheet

Delete a Worksheet

Change the Gridline Color

Toggle Worksheet Gridlines On and Off

Toggle Worksheet Headings On and Off

Set the Worksheet Tab Color

Set the Worksheet Background

Zoom In on or Out of a Worksheet

Split a Worksheet into Two Panes

Hide ...