Skip to main content
Aliexpress WW
Aliexpress WW

Things You'll Need to Know About Moving And Copying Cell Contents in Excel 2000

Introduction

By the end of this lesson, you should be able to:

  • Move and copy cell contents using:
    • Cut, copy, and paste
    • Drag and drop

Moving and copying cell contents

If you're not happy with the location of your data, you don't have to delete it and start entering data all over again. Instead, you can move it around in the worksheet.
Basic moving and copying techniques can be reviewed in our Office 2000 tutorial.

Copying and pasting cells

The Office 2000 Clipboard is helpful if you want to transfer information within a worksheet. In fact, the Clipboard allows you to store up to 12 items and paste them one at a time or all of them at once. To turn on the Clipboard toolbar, choose ViewactionToolbarsactionClipboard from the menu bar.

To cut, copy, and paste:

  • Select a cell or cells to be duplicated.
  • Click the Copy button. Marching ants appear around the selected cells.
  • If you want to move the information from one cell to another, click the Cutbutton instead.
  • Click the cell where you want to place the duplicated information. The cell will be highlighted. If you are copying contents into more than one cell, click the first cell where you want to place the duplicated information.
  • Press Enter. Your information is copied to the new location.
Marching Ants Appear
Important pointSelect a cell or cells to be moved or duplicated and right-click to open the shortcut menu.
Shortcut Menu

Differences in Excel's Cut, Copy, and Paste functions

While basic cut, copy, and paste functionality works in Excel, you should know that Excel handles it a bit differently:
  1. You must paste data you've cut or copied immediately. If you don't, the cut or copy operation is cancelled.
  2. When you cut a selection, you can paste it once. You can't paste the selection multiple times. Instead, you must copy and paste the same information over and over again.
  3. When you cut a cell, it's copied to the Clipboard. This information remains on the Clipboard until you paste it by pressing Enter or the Paste button.
  4. You can't paste cells on top of existing data. If you do, the existing data is overwritten.

Using drag and drop

Drag and drop is useful in Excel when you can actually see where you want to move your data to a new location.

To use drag and drop:

  • Select some cells you want to move to a new location.
  • Position the mouse pointer near one of the outside edges of the selected cell (avoid the fill handle in the lower-right during this process).
  • The mouse pointer becomes a small white arrow.
Small White Arrow
  • Keeping the mouse pointer on the outer edge of the selected cell, press and hold the mouse button, and dragthe cells to a new location.
Drag and Drop in Excel
Important point
Labels:

Comments

Post a Comment

Popular posts from this blog

The Advanced Guide to Colours In Graphic Design

The power of color Color plays a vital role in  design  and  everyday life . It can draw your eye to an image. Sometimes it can trigger an emotional response. It can even communicate something important without using words at all. So how do we know which colors look good together and which ones don't? The answer is simple:  Color theory . Artists and designers have followed  color theory  for centuries, but anyone can learn more about it. It can help you feel confident in many different situations, whether it's  choosing colors for a design  or  putting together the perfect outfit . With a little insight, you'll be looking at color in a whole new way. Color basics Let's start at the beginning with a refresher on the basics. Remember learning about  primary and secondary colors  in school? Then you already have some knowledge of color theory. Secondary colors  are created by combining two  primary colors...
Post a Comment
Read more

The Ultimate Cheat Sheet On Making Basic Adjustments In Image Editting

Introduction Image editing is all about adjusting your images to make them look better. We're going to talk about some of the most  basic image adjustments , along with some common problems to watch out for when making these changes. The adjustments we'll cover in this lesson include: Cropping : If you want to remove parts of an image, you can  crop  it. You can think of cropping as using a pair of scissors to  cut out  the parts you no longer want. Resizing : If you want to make an image smaller or larger, you can  resize  it. However, keep in mind that making an image larger than its original size generally does not look good. Rotating : If you want to change the  orientation  of an image, you can  rotate  it to the left or right. Optional : If you'd like to follow along, you can download some or all of our  example images . Just click any of the images below to open a full-sized version. Then right-click the full-si...
3 comments
Read more

Layout And Composition In Graphic Design: It's Not as Difficult as You Think

What is composition? In many ways, layout and composition are the  building blocks  of design. They give your work structure and make it easier to navigate, from the margins on the sides to the content in between. Why is composition so important? In short, it's the  way your content is arranged . It doesn't matter if you're working with text, images, or elements in a graphic; without a thoughtful, well-composed layout, your work would basically fall apart. Five basic principles The key to mastering layout and composition is to  think like a designer . Luckily, it's easier than it sounds. There are  five basic principles  that can help you transform your work and sharpen your eye for design. Keep them in mind during your next project, and look for ways to apply them. Proximity Proximity is all about using  visual space  to show  relationships  in your content. In practice, it's pretty simple—all you have to do is make su...
Post a Comment
Read more