Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
3. Moving Data > Moving Cells Around
One of the most common reasons to select groups of cells on a worksheet is to copy or move them from one place to another. Excel is a champion of the basic cut-and-paste feature, and it also gives you worthwhile enhancements that let you do things like drag and drop blocks of cells and copy multiple selections to the clipboard at the same time.
Before you get started shuffling data from one place to another, here are a few points to keep in mind:
-
Excel lets you cut or copy a single cell or a continuous range of cells. Ordinarily, when you cut or copy a cell, everything goes with it, including the data and the current formatting. However, Excel also has tricks that let you copy data without formatting (or even just the formatting). You'll learn about those on Fancy Pasting Tricks.
