377-Excel-Mysteries-SolvedLearn-Excel-2007-From-Mr-Excel.pdf

377 Excel Mysteries Solved

Bill Jelen

Holy Macro! Books

13386 Judy Ave NW, Uniontown OH 44685

Learn Excel 97 through Excel 2007 from MrExcel

in any form or by any means, electronic or mechanical, including

photocopying, recording, or by any information or storage retrieval

system without written permission from the publisher.

All terms known in this book known to be trademarks have been

appropriately capitalized. Trademarks are the property of their respective

owners and are not affiliated with Holy Macro! Books

Every effort has been made to make this book as complete and accurate

as possible, but no warranty or fitness is implied. The information is

provided on an “as is” basis. The authors and the publisher shall have

neither liability nor responsibility to any person or entity with respect

to any loss or damages arising from the information contained in this

book.

Printed in USA by Malloy

First Printing: November 2007

Author: Bill Jelen

Editors: Kitty Jarrett

Interior Design: Cass White

Cover Design: Shannon Mattiza, 6Ft4 Productions

Illustrations: Bob DAmico, Millenium Design Group

Cover Photo: Dallas Wallace, Paramount Photo

Published by: Holy Macro! Books, PO Box 82, Uniontown OH 44685

Distributed by Independent Publishers Group

ISBN 978-1-932802-27-6

Library of Congress Control Number: 2007922378

Table of ConTenTs

Dedication..........................................................................................................xvii

About.the.Author................................................................................................xix

Acknowledgments...............................................................................................xxi

Foreword...........................................................................................................xxiii

THe excel environMenT............................................................. 1

Find.Icons.on.the.Ribbon....................................................................................... 3

Go.Wide................................................................................................................ 4

Minimize.the.Ribbon.to.Make.Excel.Feel.a.Bit.More.Like.Excel.2003.................... 6

The Ofice Development Team Likes the Artist Formerly Known as Prince............. 7

The Paste Icon Is Really Two Icons......................................................................... 8

Use.Dialog.Launchers.to.Access.the.Excel.2003.Dialog....................................... 11

Make Your Most-Used Icons Always Visible......................................................... 13

The Alt Keystrokes Still Work in 2007 (If You Type Them Slowly Enough)............. 16

Use New Keyboard Shortcuts.to.Access.the.Ribbon............................................ 18

The Blue Question Mark Is Help.......................................................................... 21

All Commands Start at the Top (Except for 2 Controls at the Bottom)................. 23

What Happened to Tools – Customize?............................................................... 25

What Happened to Tools – Options?................................................................... 26

Where Are My Macros?....................................................................................... 28

Why Do I Have Only 65,536 Rows?..................................................................... 30

Which File Format Should I Use?......................................................................... 32

Share Files with People Who Are Still Using Excel 97 Through Excel 2003.......... 34

Use Live Preview................................................................................................. 36

Get Quick Access to Formatting Options Using the Mini Toolbar......................... 38

MIX FORMATTING IN a Single CELL.................................................................... 39

Copy the Characters from a Cell Instead of Copying an Entire Cell..................... 40

I am a Lobbyist Writing Policy Papers for the White House.................................. 42

vi of xxx

LEARN EXCEL 97-2007 FROM MR EXCEL

My Manager Wants Me to Create a New Expense Report from Scratch.............. 43

Increase.the.Number.of.Documents.in.the.Recent.Documents.List..................... 44

Keep Favorites in the Recent Documents List...................................................... 46

I’ve Searched Everywhere. Where Is the Save Workspace Command?................. 47

Use a Workspace to Remember What Workbooks to Open................................. 49

Close All Open Workbooks.................................................................................. 50

Automatically Move the Cell Pointer in a Direction After Entering a Number..... 52

Return to the First Column After Typing the Last Column.................................... 53

Enter Data in a Circle (Or Any Other Pattern)...................................................... 55

How to See Headings as You Scroll Around a Report........................................... 57

How to See Headings and Row Labels as You Scroll Around a Report................. 59

How to Print Titles at the Top of Each Page......................................................... 61

Print a Letter at the Top of Page 1 and Repeat Headings at the Top of Each Subse-

quent Page................................................................................................. 64

How to Print Page Numbers at the Bottom of Each Page.................................... 66

How to Make a Wide Report Fit to One Page Wide by Many Pages Tall............... 68

Arrange Windows to See Two or More Open Workbooks.................................... 69

Why Is There a “:2” After My Workbook Name in the Title Bar?......................... 73

Have Excel Always Open Certain Workbook(s).................................................... 75

Set up Excel Icons to Open a Speciic File on Startup.......................................... 76

Use a Macro to Further Customize Startup......................................................... 79

Control Settings for Every New Workbook and Worksheet.................................. 82

Open a Copy of a Workbook............................................................................... 84

Open a Saved File Whose Name You Cannot Recall............................................ 85

Excel 2007’S Obsession with Security Has Destroyed Linked Workbooks............ 86

I Navigate by Sliding the Scrollbar and Now the Slider Has Become T iny............ 88

Send an Excel File as an Attachment...................................................................90

Save Excel Data as a Text File..............................................................................92

Use a Laser Printer to Have Excel Calculate Faster..............................................96

Use Excel as a Word Processor............................................................................96

Add.Word.to.Excel...............................................................................................99

Spell check a Region......................................................................................... 102

Translate.with.Excel.......................................................................................... 103

Use Hyperlinks to Create an Opening Menu for a Workbook............................ 105

Get Quick Access to Paste Values...................................................................... 108

Quickly Copy a Formula to All Rows of Data..................................................... 110

Enter a Series of Months, Days, or More by Using the Fill Handle..................... 112

Have the Fill Handle Fill Your List of Part Numbers............................................ 115

Quickly Turn a Range on Its Side....................................................................... 118

Stop Excel from AutoCorrecting Certain Words................................................. 120

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: