Introduction to Microsoft Excel 2016
i
INTRODUCTION ..................................................................................................................................................... 1
The Excel 2016 Environment .................................................................................................................................. 1
Worksheet Views ................................................................................................................................................... 2
UNDERSTANDING CELLS ................................................................................................................................... 2
Select a Cell Range ................................................................................................................................................. 3
CELL CONTENT ...................................................................................................................................................... 4
Enter and Edit Data ................................................................................................................................................ 4
Delet or Edit the Contents of a Cell ........................................................................................................................ 4
Copy and Paste Cell Content .................................................................................................................................. 5
Cut and Paste Cell Content..................................................................................................................................... 5
Access More Paste Options .................................................................................................................................... 5
Use the Fill Handle ................................................................................................................................................. 6
Continue a Series with the Fill Handle.................................................................................................................... 6
Use Flash Fill .......................................................................................................................................................... 7
FIND AND REPLACE ............................................................................................................................................. 7
Find Content .......................................................................................................................................................... 7
Replace Content .................................................................................................................................................... 8
WORKING WITH ROWS, COLUMNS AND CELLS ....................................................................................... 8
Modify Column Width ........................................................................................................................................... 8
Modify Row Height ................................................................................................................................................ 9
Modify All Rows or Columns .................................................................................................................................. 9
Insert Rows ............................................................................................................................................................ 9
Insert Columns ..................................................................................................................................................... 10
Delete Rows......................................................................................................................................................... 10
Delete Columns ................................................................................................................................................... 10
Wrap Text and Merge Cells .................................................................................................................................. 10