July 2007
Beginner
256 pages
7h 29m
English
Content preview from Excel® 2007: Top 100 Simplified® Tips & TricksBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 3. Copy, Format, 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. Basic copying in Excel is similar: Select the value and then click the Copy button in the Ribbon. In the new location, click in the cell where you want to place the value and then click Paste. But copying can be both more involved and more powerful in Excel because 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, or many consecutively arranged values at the same time, such as a range.
Excel makes use of the copy features built into Windows as well as those built into Office 2007. You can store as many as 24 different items on the Office Clipboard for pasting into Excel and other Office applications.
In this chapter, you learn to use the Office Clipboard. You also learn to transpose a row into a column, to copy styles from one worksheet to another, to copy formulas from one cell to another, to change text to numbers, and much more. If you share your workbooks with others, you may want to use the tip on keeping track of the changes.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.