Excel 365 Formatting: Easy Excel 365 Essentials, #1
()
About this ebook
If you're going to spend any amount of time working in Excel then you need to learn how to format cells, because inevitably your column won't be as wide as you want it to be or you'll want to have a cell with red-colored text or to use bolding or italics or something that isn't Excel's default.
That's what this book is for. It's a listing of different things you might want to do to format your data in Excel.
* * *
This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.
If you want a more general introduction to Excel, then you should check out the Excel 365 Essentials titles instead. In this case, Excel 365 for Beginners which covers formatting as well as a number of other topics, such as sorting and filtering.
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 ratingsExcel Tips and Tricks Rating: 0 out of 5 stars0 ratingsAccess 2019 Intermediate: Access Essentials 2019 Rating: 0 out of 5 stars0 ratingsMicrosoft Office 2019 Beginner Rating: 0 out of 5 stars0 ratingsExcel Essentials Rating: 0 out of 5 stars0 ratingsWord 365 Essentials Rating: 0 out of 5 stars0 ratingsHow To Gather And Use Data For Business Analysis Rating: 0 out of 5 stars0 ratingsWord Essentials 2019 Rating: 0 out of 5 stars0 ratingsExcel 365 Essentials Rating: 0 out of 5 stars0 ratingsExcel 2019 Formulas and Functions Study Guide Rating: 0 out of 5 stars0 ratingsAccess Essentials 2019 Rating: 0 out of 5 stars0 ratingsA Light in the Window Rating: 0 out of 5 stars0 ratingsMicrosoft Office for Beginners Rating: 0 out of 5 stars0 ratingsExcel Essentials 2019 Rating: 0 out of 5 stars0 ratingsTails of the North Rating: 0 out of 5 stars0 ratingsMicrosoft Office 365 for Beginners Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials 2019 Rating: 0 out of 5 stars0 ratingsPowerPoint 365 Essentials: PowerPoint 365 Essentials Rating: 0 out of 5 stars0 ratings
Related to Excel 365 Formatting
Titles in the series (6)
Excel 365 Formatting: Easy Excel 365 Essentials, #1 Rating: 0 out of 5 stars0 ratingsExcel 365 Conditional Formatting: Easy Excel 365 Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel 365 Charts: Easy Excel 365 Essentials, #3 Rating: 0 out of 5 stars0 ratingsExcel 365 Pivot Tables: Easy Excel 365 Essentials, #4 Rating: 0 out of 5 stars0 ratingsExcel 365 LOOKUP Functions: Easy Excel 365 Essentials, #6 Rating: 0 out of 5 stars0 ratingsExcel 365 The IF Functions: Easy Excel 365 Essentials, #5 Rating: 0 out of 5 stars0 ratings
Related ebooks
Excel 365 Charts: Easy Excel 365 Essentials, #3 Rating: 0 out of 5 stars0 ratingsExcel 365 Conditional Formatting: Easy Excel 365 Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel 365 Pivot Tables: Easy Excel 365 Essentials, #4 Rating: 0 out of 5 stars0 ratingsMicrosoft Excel 2016: Data Analysis with PivotTables Rating: 0 out of 5 stars0 ratingsMicrosoft Excel for Management Consultants : A Comprehensive Course: Course, #2 Rating: 0 out of 5 stars0 ratingsExcel 2019 Conditional Formatting: Easy Excel Essentials 2019, #3 Rating: 0 out of 5 stars0 ratingsIntermediate Access: Access Essentials, #2 Rating: 0 out of 5 stars0 ratingsAdvance Excel 2016: Training guide Rating: 0 out of 5 stars0 ratingsIntermediate Excel: Excel Essentials, #2 Rating: 5 out of 5 stars5/5Excel 2019 Intermediate: Excel Essentials 2019, #2 Rating: 0 out of 5 stars0 ratingsExcel Data Filters Rating: 5 out of 5 stars5/5EXCEL: Microsoft: Boost Your Productivity Quickly! Learn Excel, Spreadsheets, Formulas, Shortcuts, & Macros Rating: 0 out of 5 stars0 ratingsPowerPoint Essentials Rating: 0 out of 5 stars0 ratingsExcel Pivot Tables & Charts Rating: 0 out of 5 stars0 ratingsExcel Tables: A Complete Guide for Creating, Using and Automating Lists and Tables Rating: 5 out of 5 stars5/5Conditional Formatting: Easy Excel Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Mastering Excel: Excel Apps Rating: 3 out of 5 stars3/5Excel 2019 PivotTables: Easy Excel Essentials 2019, #1 Rating: 5 out of 5 stars5/5Pivot Tables for everyone. From simple tables to Power-Pivot: Useful guide for creating Pivot Tables in Excel Rating: 0 out of 5 stars0 ratingsWord 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 ratingsExcel for Beginners: Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsTop Secrets Of Excel Dashboards: Save Your Time With MS Excel Rating: 5 out of 5 stars5/5How To Develop A Performance Reporting Tool with MS Excel and MS SharePoint Rating: 0 out of 5 stars0 ratingsExcel 2019 – Business Basics & Beyond Rating: 0 out of 5 stars0 ratingsSecrets of Access Database Development and Programming Rating: 5 out of 5 stars5/5
Enterprise Applications For You
Scrivener For Dummies Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Systems Thinking: Managing Chaos and Complexity: A Platform for Designing Business Architecture Rating: 4 out of 5 stars4/5Excel 2019 For Dummies Rating: 3 out of 5 stars3/5Creating Online Courses with ChatGPT | A Step-by-Step Guide with Prompt Templates Rating: 4 out of 5 stars4/5Excel Formulas and Functions 2020: Excel Academy, #1 Rating: 4 out of 5 stars4/5ChatGPT Ultimate User Guide - How to Make Money Online Faster and More Precise Using AI Technology Rating: 0 out of 5 stars0 ratings50 Useful Excel Functions: Excel Essentials, #3 Rating: 5 out of 5 stars5/5Bitcoin For Dummies Rating: 4 out of 5 stars4/5QuickBooks 2023 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsQuickBooks Online For Dummies Rating: 0 out of 5 stars0 ratingsCreate Income through Self-Publishing: An Author's Approach on Generating Wealth by Self-Publishing Rating: 5 out of 5 stars5/5Excel 2016 For Dummies Rating: 4 out of 5 stars4/5Excel Formulas That Automate Tasks You No Longer Have Time For Rating: 5 out of 5 stars5/5QuickBooks 2021 For Dummies Rating: 0 out of 5 stars0 ratingsLearn Windows PowerShell in a Month of Lunches Rating: 0 out of 5 stars0 ratings101 Ready-to-Use Excel Formulas Rating: 4 out of 5 stars4/5Enterprise AI For Dummies Rating: 3 out of 5 stars3/5Notion for Beginners: Notion for Work, Play, and Productivity Rating: 4 out of 5 stars4/5CISSP Study Guide Rating: 4 out of 5 stars4/5102 Useful Excel 365 Functions: Excel 365 Essentials, #3 Rating: 0 out of 5 stars0 ratingsExcel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsExercises and Projects for The Little SAS Book, Sixth Edition Rating: 0 out of 5 stars0 ratingsLearning Python Rating: 5 out of 5 stars5/5The Ridiculously Simple Guide to Google Docs: A Practical Guide to Cloud-Based Word Processing Rating: 0 out of 5 stars0 ratings
Reviews for Excel 365 Formatting
0 ratings0 reviews
Book preview
Excel 365 Formatting - M.L. Humphrey
ALSO BY M.L. HUMPHREY
Listing of all books by M.L. Humphrey
Excel 365 Essentials
Excel 365 for Beginners
Intermediate Excel 365
102 Useful Excel 365 Functions
Easy Excel 365 Essentials
Formatting
Conditional Formatting
Charts
Pivot Tables
The IF Functions
LOOKUP Functions
EXCEL 365 FORMATTING
EASY EXCEL 365 ESSENTIALS - BOOK 1
M.L. HUMPHREY
CONTENTS
Introduction
Formatting
Appendix: Basic Terminology Recap
About the Author
Copyright
INTRODUCTION
This book is part of the Easy Excel 365 Essentials series of titles. These are targeted titles that are excerpted from the main Excel 365 Essentials series and are focused on one specific topic.
If you want a more general introduction to Excel, then you should check out the Excel 365 Essentials titles instead. In this case, Excel 365 for Beginners which covers formatting as well as a number of other topics, such as sorting and filtering.
But if all you want is a book that covers this specific topic, then let’s continue with a discussion of your formatting options in Microsoft Excel.
FORMATTING
If you're going to spend any amount of time working in Excel then you need to learn how to format cells, because inevitably your column won’t be as wide as you want it to be or you’ll want to have a cell with red-colored text or to use bolding or italics or something that isn’t Excel’s default.
That's what this section is for. It's an alphabetical listing of different things you might want to do to format your data in Excel.
You can either format one cell at a time by highlighting that specific cell, or you can format multiple cells at once by highlighting all of them and then choosing your formatting option. In some cases, you can also format specific text within a cell by clicking into a cell, selecting that text, and then choosing your formatting option.
There are basically four main ways to format cells or text in current versions of Excel.
First, you can use the Home tab and click on the option you want from there.
Second, you can use the Format Cells dialogue box. Either right-click from the main workspace and select the Format Cells option from the dropdown menu or use Ctrl + 1 to open the dialogue box.
Third, you can right-click from the main workspace and use the mini formatting menu that appears above or below the dropdown menu.
Finally, some of the most popular formatting options can be applied using control shortcuts. For example, Ctrl + B to bold text, Ctrl + I