August 2000
Beginner to intermediate
608 pages
17h 15m
English
Content preview from Excel 2000 in a Nutshell
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,
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.
Name
Tools → Options
Synopsis
The Options dialog, shown in Figure 8-36, provides general settings for various features of Excel. For example, on the General tab you can indicate the number of worksheets that should be placed in each workbook as it is created. If you change any of these settings it affects all currently open workbooks, and any that Excel may open or create in the future.
Figure 8-36. View tab on Options dialog
View Tab
The View tab provides options for specifying how your Excel window displays a workbook on the screen. There are basically four different groups of options on this tab. You select options in each group by selecting the appropriate radio button or checkbox.
Calculation Tab
The Calculation tab indicates how Excel should handle calculations. By default Excel automatically recalculates data in the worksheet whenever you change a value or formula. If you have a large worksheet with several formulas you may want to select the Manual option. If you select manual the worksheet will not be recalculated until you select the Calc Now or Calc Sheet button or press F9. The worksheet will also be recalculated when you save it if the “Recalculate before save” checkbox is selected.
The Iterations section limits the number of iterations that Excel makes for goal setting or for resolving circular references. For more information refer to “Tools → Goal Setting.”
The Workbook ...
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.