• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Editing Cell Content > Editing with the Mouse

Editing with the Mouse

Worksheets are complex documents, relying heavily on the exact and appropriate placement of text and numbers. Formula results and overall legibility can be adversely affected by numbers in the wrong cells or text that doesn't reflect the latest information. You may also need to repeat the content of one or more cells within the same worksheet and want to avoid retyping it.

While you can use the Clipboard to copy or move cell content, it often is easier to make minor changes in data location within a single worksheet by using the mouse. This feature, called drag and drop, is supported in all of the Microsoft Office applications—you may have used it in Microsoft Word, where it is especially useful in rearranging words in a sentence or sentences in a paragraph. These word processing examples should serve to remind you of a basic limitation of drag and drop—it works best within a small area, namely the portion of your worksheet that is currently visible onscreen.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint