Free Tutorial Central Home |Excel 2007: Moving, Copying, and Filling Cells |

Microsoft® Excel® 2007: Moving, Copying, and Filling Cells With Lots of Tips and Tricks

H. Albert Napier, Ph.D. and Ollie N. Rivers

This lesson is available in PDF format and can be downloaded free.

Description

Microsoft®Excel 2007: Moving, Copying and Filling Cells With Lots of Tips and Tricks is a tutorial that guides you through moving and copying worksheet data and formulas using command buttons and the mouse pointer using step-by-step hands-on activities.

The Excel 2007 Office Fluent user interface is very different from the Excel 2003 (and earlier Excel versions) user interface. Although these lessons are presented at an introductory level, you can benefit even if you are an experienced Excel user switching to Excel 2007 since it can help you become more familiar with the new Excel 2007 Office Fluent user interface.


Click the "Download" button to download this free lesson in PDF format.


See also:

Objectives

  1. move or copy cells using command buttons on the Ribbon
  2. move or copy cells using the mouse pointer and drag and drop
  3. enter data in a preselected range
  4. copy formulas with relative, mixed or absolute cell references using command buttons or the fill handle
  5. format grouped worksheets
  6. move or copy an entire worksheet
  7. collect and paste using the Office Clipboard
  8. copy and paste only visible cells when a range contains both visible and hidden cells
  9. paste formulas’ results as values
  10. fill a range with a custom list
  11. fill a range with a series of numbers, dates, or text and number combinations

Key Terms

mixed reference

Office Clipboard

Office Clipboard task pane

Paste Options button

relative reference

system Clipboard

ungroup worksheets

Windows Clipboard

#DIV/0!

absolute reference

custom list

drag and drop

Error Checking button

F4 function key

Fill feature

fill handle

grouping worksheets

Author Biographies

H. Albert Napier, Ph.D.
Dr. Napier is a successful professor, author and entrepreneur. Currently, he serves as Professor of Management in the Jones Graduate School of Management at Rice University, where he teaches graduate level courses on entrepreneurship, information technology and e-business.

He is a co-author of more than 60 books on Microsoft Office application software.  His books have been used as the textbooks for courses in hundreds of universities, colleges, and corporations. Dr. Napier is also co-author of additional computer software training courses that are provided on the Internet.

Dr. Napier is also co-author of Creating a Winning E-Business, E-Business Technologies, Business Planning: 25 Keys to a Successful Business Plan, and Preparing an Entrepreneurial Business Plan. He is currently completing another book on the entrepreneurial process.

He is an owner of the successful e-business town Favorites that provides on-line grocery shopping for candies, condiments and everyday food items that are hard to find where you live. The company is located at www.hometownfavorites.com.

In addition to his duties at Rice, Dr. Napier was a principal for 20 years of Napier & Judd, Inc. The company provided consulting services in IT strategy, planning, and systems development to more than 200 organizations and trained more than 150,000 participants on personal computer software applications. Some of the industries served by Napier & Judd, Inc. included energy, health, education, finance, banking, distribution, and accounting.

He is the author of more than 25 articles related to information technology, human-computer interface, and applications of computer based decision processes in business.

Dr. Napier holds a BA degree in Mathematics and Economics, an MBA degree, and a Ph.D. degree in Business Administration, all from the University of Texas at Austin.


Ollie N. Rivers
Ollie N. Rivers has more than 20 years' business experience in financial and administrative management and more than 10 years’ experience as a corporate trainer. She is a co-author of two e-business textbooks and a Web design textbook, and is a contributing author on more than 15 software package and Internet textbooks. Ms. Rivers has also developed and delivered numerous classroom and online continuing education seminars for CPAs. Ms. Rivers holds an MBA and a BS in Accounting and Management from Houston Baptist University.




Copyright © 2009
H. Albert Napier, Ollie N. Rivers, and JB Napier
Distributed by FreeTutorialCentral with permission

Microsoft and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.