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 10. Customize Excel
Excel has a large number of integrated features you can customize and adapt to suit your purposes. This chapter introduces a few important ways in which you can customize Excel.
One simple way is to install additional features, called add-ins. This chapter shows you how to install the add-ins included with Excel and how to find add-ins available from third-party developers.
You also learn to tailor Excel by placing items on the Quick Access toolbar. Items on the Quick Access toolbar are independent of the tabs in the Ribbon and you can access them with a single click. You can add many options that are not available in the Ribbon to Excel via the Quick Access toolbar.
When working with large worksheets, you can open multiple windows to view different parts of a worksheet at the same time. This chapter teaches you how. You also learn to create custom views. If you filter data, hide columns or rows, or create special print settings, you can save your changes in a custom view and recall them when you need them. Another task shows you how to create custom number formats for use in a workbook.
The task on macros introduces an enormous topic, which more than any other task enables you to extend and customize Excel. After you learn how to create a macro, you learn how to assign a macro to a button and how to add the button to the Quick Access toolbar.
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.