Formatting: Easy Excel Essentials, #5
()
About this ebook
It's not enough to enter information into Excel. If you really want to work effectively with your data, you need to format it.
That could mean anything from adding borders so that your document looks good when it prints to adding fill color in the header row of a table to simply formatting your numbers as currency or percentages.
So if you're ready to learn how to format the data you enter into Excel, then this is the guide for you. It'll show you how to do all of that and more with clear, easy to follow instructions.
The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, and 50 Useful Excel Functions. In that series, formatting is covered in Excel for Beginners.
M.L. Humphrey
Hi there Sci Fi fans, my name is Maurice Humphrey. I am a Vermont native, husband, father, grandfather, well over 60, Navy veteran, retired IBM engineer, retired printer repairman, Graduated: Goddard Jr. College, VT Technical College, and Trinity College. Over the years I've written technical articles, taught technical classes, and presented at technical conventions. I've been reading science fiction for over 50 years now. First books were "Journey to the Centre of the Earth" by Jules Verne and "The Stars Are Ours" by Andre Norton. I've read and collected many great stories, and a considerable amount of junk ones as well. I'd say by now that I probably have a good idea of what I consider a good story.
Read more from M.L. Humphrey
Access 2019 Beginner: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsAccess Essentials 2019 Rating: 0 out of 5 stars0 ratingsWord 365 Essentials Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials Rating: 0 out of 5 stars0 ratingsExcel Tips and Tricks Rating: 0 out of 5 stars0 ratingsExcel 2019 Formulas and Functions Study Guide Rating: 0 out of 5 stars0 ratingsAccess 2019 Intermediate: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsExcel 365 Essentials Rating: 0 out of 5 stars0 ratingsHow To Gather And Use Data For Business Analysis Rating: 0 out of 5 stars0 ratingsToll Booth Rating: 0 out of 5 stars0 ratingsMicrosoft Office 2019 Beginner Rating: 0 out of 5 stars0 ratingsWord Essentials 2019 Rating: 0 out of 5 stars0 ratingsWord Essentials Rating: 0 out of 5 stars0 ratingsPowerPoint 365 Essentials: PowerPoint 365 Essentials Rating: 0 out of 5 stars0 ratingsMy Grandfather's Spaceship Rating: 0 out of 5 stars0 ratingsA Light in the Window Rating: 0 out of 5 stars0 ratingsTails of the North Rating: 0 out of 5 stars0 ratingsExcel Essentials 2019 Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials 2019 Rating: 0 out of 5 stars0 ratings
Related to Formatting
Titles in the series (6)
Pivot Tables: Easy Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsConditional Formatting: Easy Excel Essentials, #2 Rating: 0 out of 5 stars0 ratingsThe IF Functions: Easy Excel Essentials, #4 Rating: 0 out of 5 stars0 ratingsCharts: Easy Excel Essentials, #3 Rating: 0 out of 5 stars0 ratingsFormatting: Easy Excel Essentials, #5 Rating: 0 out of 5 stars0 ratingsPrinting: Easy Excel Essentials, #6 Rating: 0 out of 5 stars0 ratings
Related ebooks
Printing: Easy Excel Essentials, #6 Rating: 0 out of 5 stars0 ratingsPivot Tables: Easy Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsJuggling Your Finances: Basic Excel Primer: Juggling Your Finances Rating: 0 out of 5 stars0 ratingsConditional Formatting: Easy Excel Essentials, #2 Rating: 0 out of 5 stars0 ratingsIntermediate Excel: Excel Essentials, #2 Rating: 5 out of 5 stars5/5Hidden Gems of Microsoft Excel Rating: 0 out of 5 stars0 ratingsExcel for Beginners: Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsExcel 2019 Formulas and Functions Study Guide Rating: 0 out of 5 stars0 ratingsWord Essentials Rating: 0 out of 5 stars0 ratingsExcel 2019 – Business Basics & Beyond Rating: 0 out of 5 stars0 ratingsExcel 2019 Conditional Formatting: Easy Excel Essentials 2019, #3 Rating: 0 out of 5 stars0 ratingsExcel Subtotals Straight to the Point Rating: 0 out of 5 stars0 ratingsExcel Essentials Rating: 0 out of 5 stars0 ratings15 Most Powerful Features Of Pivot Tables: Save Your Time With MS Excel Rating: 0 out of 5 stars0 ratingsIntermediate Excel 365: Excel 365 Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel 2019 PivotTables: Easy Excel Essentials 2019, #1 Rating: 5 out of 5 stars5/5Excel 2019 Beginner: Excel Essentials 2019, #1 Rating: 0 out of 5 stars0 ratingsExcel 365 Conditional Formatting: Easy Excel 365 Essentials, #2 Rating: 0 out of 5 stars0 ratingsLearn Excel: Executive Summary & Scope Rating: 5 out of 5 stars5/5Charts: Easy Excel Essentials, #3 Rating: 0 out of 5 stars0 ratingsTables: Easy Word Essentials, #4 Rating: 0 out of 5 stars0 ratingsExcel 2019 Charts: Easy Excel Essentials 2019, #2 Rating: 0 out of 5 stars0 ratingsI Will Teach You Excel Rating: 3 out of 5 stars3/5Secrets of Excel and Access for Accounting! Rating: 0 out of 5 stars0 ratingsSecrets of Access Database Development and Programming Rating: 5 out of 5 stars5/5Word 2019 Intermediate: Word Essentials 2019, #2 Rating: 0 out of 5 stars0 ratingsMastering Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5Microsoft Office for Beginners Rating: 0 out of 5 stars0 ratings
Training For You
Crucial Conversations: Tools for Talking When Stakes are High, Third Edition Rating: 4 out of 5 stars4/5The McKinsey Way Rating: 4 out of 5 stars4/5HBR Guide to Coaching Employees (HBR Guide Series) Rating: 5 out of 5 stars5/5Positioning: The Battle for Your Mind Rating: 4 out of 5 stars4/5Communicating in Business English: Business English Rating: 4 out of 5 stars4/51001 Questions to Ask Before You Get Married Rating: 4 out of 5 stars4/5The English You Need for the Office: Business English Rating: 5 out of 5 stars5/5Crucial Conversations Tools for Talking When Stakes Are High, Second Edition Rating: 4 out of 5 stars4/5The Disease to Please: Curing the People-Pleasing Syndrome Rating: 4 out of 5 stars4/5Hope Is Not a Strategy: The 6 Keys to Winning the Complex Sale: The 6 Keys to Winning the Complex Sale Rating: 4 out of 5 stars4/5You Can't Lie to Me: The Revolutionary Program to Supercharge Your Inner Lie Detector and Get to the Truth Rating: 4 out of 5 stars4/5How to Trade In Stocks Rating: 4 out of 5 stars4/5Emotional Vampires: Dealing with People Who Drain You Dry, Revised and Expanded 2nd Edition DIGITAL AUDIO Rating: 5 out of 5 stars5/5The Job Interview Phrase Book: The Things to Say to Get You the Job You Want Rating: 4 out of 5 stars4/5Cultures and Organizations: Software for the Mind Rating: 4 out of 5 stars4/5How to Make Money in Stocks Complete Investing System (EBOOK) Rating: 4 out of 5 stars4/5Electronic Shorthand: An Easy-To-Learn Method Of Rapid Digital Note-Taking Rating: 5 out of 5 stars5/5The 2-Hour Workshop Blueprint: Design Fast. Deliver Strong. Without Stress. Rating: 4 out of 5 stars4/5How to Hug a Porcupine: Negotiating the Prickly Points of the Tween Years Rating: 4 out of 5 stars4/5The McGraw-Hill 36-Hour Course: Operations Management Rating: 5 out of 5 stars5/5E-Myth Mastery: The Seven Essential Disciplines for Building a World Class Company Rating: 4 out of 5 stars4/5Practice Makes Perfect Exploring Writing Rating: 5 out of 5 stars5/5
Reviews for Formatting
0 ratings0 reviews
Book preview
Formatting - M.L. Humphrey
Also by M.L. Humphrey
Easy Excel Essentials
Pivot Tables
Conditional Formatting
Charts
The IF Functions
Formatting
Printing
Excel Essentials
Excel for Beginners
Intermediate Excel
50 Useful Excel Functions
50 More Excel Functions
Excel Essentials Quiz Books
The Excel for Beginners Quiz Book
The Intermediate Excel Quiz Book
The 50 Useful Excel Functions Quiz Book
The 50 More Excel Functions Quiz Book
Formatting
Easy Excel Essentials - Volume 5
M.L. Humphrey
Contents
Introduction
Formatting
1. Aligning Your Text Within a Cell
2. Bolding Text
3. Borders Around Cells
4. Coloring a Cell (Fill Color)
5. Column Width (Adjusting)
6. Currency Formatting
7. Date Formatting
8. Font Choice and Size
9. Font Color
10. Italicizing Text
11. Merge & Center
12. Number Formatting
13. Percent Formatting
14. Row Height (Adjusting)
15. Underlining Text
16. Wrapping Text
17. Copying Formatting From One Cell To Another
Conclusion
Appendix A: Basic Terminology
About the Author
Copyright
Introduction
In Excel for Beginners I covered the basics of working in Excel, including how to format in Excel and how to print. In Intermediate Excel I covered a number of intermediate-level topics such as pivot tables, charts, and conditional formatting. And in 50 Useful Excel Functions I covered fifty of the most useful functions you can use in Excel.
But I realize that some users will just want to know about a specific topic and not buy a guide that covers a variety of other topics that aren’t of interest to them.
So this series of guides is meant to address that need. Each guide in the series covers one specific topic such as pivot tables, conditional formatting, or charts.
I’m going to assume in these guides that you have a basic understanding of how to navigate Excel, although each guide does include an Appendix with a brief discussion of basic terminology to make sure that we’re on the same page.