Introduction to Excel 2016: For every user by Robin Hunt

Author:Robin Hunt [Hunt, Robin]
Language: eng
Format: azw3
Published: 2017-11-27T05:00:00+00:00

Relative References

By default, Excel uses relative references. That means that when you copy it or autofill it, it will update to the relative row or column.

Absolute References

If you need to have a constant then you can apply absolute references to the column and/or row so that it will always point to the same location for the information.

Using F4 (Function Key F4)

MODIFYING A WORKSHEET

Topics in this section and exercise file: 01_NavigatingExcel.xlsx

Working with spreadsheets you will find that there are times when you need to insert additional columns or rows. You might find occasions where shifting cells is the best choice. Learning how to do each command will help you know when to use which option.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.