Excel 2016 Introduction

Excel 2016

Lesson - Working with Columns and Rows

Steps

Practice Data

1. Double-click the line to the right of the heading of the column you want to AutoFit. The column width is adjusted to the width of its widest cell entry.

Double-click the line to the right of the heading of column H

Practice the concept: Scroll to view column K . Adjust the column width using AutoFit.

H IDING C OLUMNS AND R OWS  D ISCUSSION

You can hide columns or rows to conceal the entries in them. For example, you may want to hide columns or rows that contain salary data. Hidden columns and rows do not appear in the worksheet and do not print. Any number in a hidden column or row is calculated, however, even though the column or row is hidden.

Hide a range of rows

OFFICEPRO, Inc.

Page 135