Excel 2013 Bible（Excel2013宝典） by John Walkenbach，Wiley出版

共享是关键
Acknowledgments ix
Introduction. xxxvii
Is This Book for You?.............................................................................xxxvii
Software Versions..................................................................................xxxvii
Conventions Used in This Book...............................................................xxxviii
Excel commands...................................................................................xxxviii
Filenames, named ranges, and your input..............................................xxxviii
Key names...........................................................................................xxxviii
Functions.............................................................................................xxxviii
Mouse conventions.................................................................................xxxix
How This Book Is Organized................................................................................. xl
How to Use This Book.......................................................................................... xl
What’s on the Website........................................................................................ xli
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Identifying What Excel Is Good For........................................................................ 3
Seeing What’s New in Excel 2013........................................................................... 4
Understanding Workbooks and Worksheets............................................................ 5
Moving Around a Worksheet................................................................................. 8
Navigating with your keyboard...................................................................... 8
Navigating with your mouse.......................................................................... 9
Using the Ribbon................................................................................................. 10
Ribbon tabs................................................................................................ 10
Contextual tabs........................................................................................... 12
Types of commands on the Ribbon.............................................................. 13
Accessing the Ribbon by using your keyboard.............................................. 14
Using Shortcut Menus.......................................................................................... 15
Customizing Your Quick Access Toolbar............................................................... 16
Working with Dialog Boxes.................................................................................. 18
Navigating dialog boxes.............................................................................. 19
Using tabbed dialog boxes........................................................................... 19
Using Task Panes................................................................................................ 20

Creating Your First Excel Workbook..................................................................... 21
Getting started on your worksheet............................................................... 22
Filling in the month names.......................................................................... 22
Entering the sales data................................................................................ 23
Formatting the numbers.............................................................................. 23
Making your worksheet look a bit fancier..................................................... 24
Summing the values.................................................................................... 25
Creating a chart.......................................................................................... 25
Printing your worksheet.............................................................................. 26
Saving your workbook................................................................................ 26
Chapter 2: Entering and Editing Worksheet Data 29
Exploring Data Types.......................................................................................... 29
Numeric values.......................................................................................... 30
Text entries................................................................................................ 30
Formulas.................................................................................................... 31
Entering Text and Values into Your Worksheets.................................................... 32
Entering Dates and Times into Your Worksheets................................................... 33
Entering date values.................................................................................... 33
Entering time values................................................................................... 34
Modifying Cell Contents....................................................................................... 34
Deleting the contents of a cell...................................................................... 34
Replacing the contents of a cell.................................................................... 35
Editing the contents of a cell........................................................................ 35
Learning some handy data-entry techniques................................................. 36
Automatically moving the cell pointer after entering data..................... 36
Using navigation keys instead of pressing Enter................................... 37
Selecting a range of input cells before entering data............................. 37
Using Ctrl+Enter to place information into multiple
cells simultaneously....................................................................... 38
Entering decimal points automatically................................................. 38
Using AutoFill to enter a series of values............................................. 38
Using AutoComplete to automate data entry........................................ 38
Forcing text to appear on a new line within a cell................................ 40
Using AutoCorrect for shorthand data entry......................................... 40
Entering numbers with fractions......................................................... 40
Using a form for data entry................................................................. 41
Entering the current date or time into a cell......................................... 42
Applying Number Formatting............................................................................... 43
Using automatic number formatting............................................................. 44
Formatting numbers by using the Ribbon..................................................... 44
Using shortcut keys to format numbers........................................................ 45
Formatting numbers using the Format Cells dialog box................................. 45
Adding your own custom number formats................................................... 48

Chapter 3: Essential Worksheet Operations 49
Learning the Fundamentals of Excel Worksheets................................................... 49
Working with Excel windows...................................................................... 49
Moving and resizing windows............................................................. 50
Switching among windows................................................................. 51
Closing windows................................................................................ 52
Activating a worksheet................................................................................ 52
Adding a new worksheet to your workbook................................................. 53
Deleting a worksheet you no longer need..................................................... 53
Changing the name of a worksheet.............................................................. 54
Changing a sheet tab color.......................................................................... 54
Rearranging your worksheets...................................................................... 55
Hiding and unhiding a worksheet................................................................ 57
Controlling the Worksheet View........................................................................... 57
Zooming in or out for a better view............................................................. 57
Viewing a worksheet in multiple windows................................................... 59
Comparing sheets side by side..................................................................... 60
Splitting the worksheet window into panes.................................................. 60
Keeping the titles in view by freezing panes................................................. 61
Monitoring cells with a Watch Window....................................................... 62
Working with Rows and Columns........................................................................ 64
Inserting rows and columns........................................................................ 64
Deleting rows and columns......................................................................... 65
Hiding rows and columns............................................................................ 66
Changing column widths and row heights.................................................... 67
Changing column widths.................................................................... 67
Changing row heights......................................................................... 68
Chapter 4: Working with Cells and Ranges. 69
Understanding Cells and Ranges........................................................................... 69
Selecting ranges.......................................................................................... 70
Selecting complete rows and columns.......................................................... 71
Selecting noncontiguous ranges................................................................... 72
Selecting multisheet ranges......................................................................... 73
Selecting special types of cells..................................................................... 75
Selecting cells by searching......................................................................... 77
Copying or Moving Ranges.................................................................................. 79
Copying by using Ribbon commands........................................................... 80
Copying by using shortcut menu commands................................................ 81
Copying by using shortcut keys................................................................... 82
Copying or moving by using drag-and-drop.................................................. 83
Copying to adjacent cells............................................................................. 84
Copying a range to other sheets................................................................... 85


Chapter 5: Introducing Tables 101

Chapter 6: Worksheet Formatting. 119


.......