O'Reilly logo

Microsoft® Office Excel® 2007 VISUAL™ Quick Tips by Denise Etheridge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Copying, Formatting, and More

If you have used Word, you know that copying text for use in another document or application enables you to reuse material and minimize !retyping and errors. Copying data in Excel is similar: You simply select the data you want to copy and click the Copy icon in the Ribbon. Then click the cell in which you want to place the data, and click the Paste icon.

However, copying can be both more involved and more powerful in Excel because in Excel so many elements can occupy a cell: values, functions, formulas, formats, styles, and more. You can copy any of these elements between cells, worksheets, workbooks, and even applications. You can copy one value at a time, such as a specific number or specific bit of text, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required