Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Changing the Alignment of Data in an Excel Cell

May 4, 2016 by Tyrone Pernsley

Making an excel spreadsheet look “pretty” is not as daunting as people make it seem.  Many people in the workforce will shy away from tinkering with an excel spreadsheet’s layout because they have a fear of making it worse or deleting an important item. Today our goal is to crush the fear of alignment of data in an excel cell!

Have you ever had numbers in the cells adjacent to a text wrapped group of cells? With a giant cell, numbers do not always fill the up the empty space which makes the spreadsheet look awkward. Here is how to fix that issue in the matter of seconds.

There are two ways to do this. The first way is to use the “Alignment” in the general toolbar on top of your excel spreadsheet. It looks like this.

alignment toolbar

First, highlight the cell or cells that you desire to have their contents aligned. Go up to the alignment toolbar and chose either the left, center, or right alignment. After your desired horizontal alignment has been chosen, chose your vertical alignment (top, center, or bottom). In seconds you can transform how your spreadsheet to look clean and neat!

The second way to go about this would be to right-click the cell or selection of cells that you would like to change the alignment for. Select “Format Cells” at the bottom of the menu and click the “Alignment” tab. From there you can select the type of Horizontal and Vertical alignments with a drop down menu.  You can also use the “Orientation” area to rotate the data of your cell if you really want to get crazy! Once you are finished changing your settings, click OK.

Check out the demonstration below to get a better understanding of the two ways to change the alignment of data in an excel cell.

#14 Gif

We hope you found todays quick and easy Excel lesson beneficial. Don’t forget to follow ups on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Like Learn Excel Now? Sign up for the newsletter above! And don’t forget to connect with us on social media and share your favorite Excel tips with your networks!

-Kevin, Learn Excel Now

 

Comments

  1. Aurelia Matei says

    May 8, 2016 at 11:40 am

    Thank you.
    It’s interesting and useful.

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In