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 ...
Get Microsoft® Office Excel® 2007 VISUAL™ Quick Tips now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
