• Home
  • MAD
  • Concept Series
    • Software Design
    • Software Arch
    • GIT & Github
    • System Design
    • Cloud
    • Database Integration
    • Push Notification
    • API Integration
    • Cocoa PODS
  • DSA
  • Interview
  • Tips&Tricks
  • YT
  • Home
  • MAD
  • Concept Series
    • Software Design
    • Software Arch
    • GIT & Github
    • System Design
    • Cloud
    • Database Integration
    • Push Notification
    • API Integration
    • Cocoa PODS
  • DSA
  • Interview
  • Tips&Tricks
  • YT
  • #News
  • #APPS
  • #Events
    • #WWDC
    • #I/O
    • #Ignite
  • #Let’s Talk

MyCodeTips mycodetips-newlogocopy1

  • Home
  • MAD
  • Concept Series
    • Software Design
    • Software Arch
    • GIT & Github
    • System Design
    • Cloud
    • Database Integration
    • Push Notification
    • API Integration
    • Cocoa PODS
  • DSA
  • Interview
  • Tips&Tricks
  • YT
ExcelTips

How to Format Cells in Excel

How to Format Cells in Excel

How to Format Cells in Excel

When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).

To change the font:

  • Select the cell(s) you want to modify.
  • Click the drop-down arrow next to the Font command on the Home tab. The Font drop-down menu will appear.
  • Select the desired font. A live preview of the new font will appear as you hover the mouse over different options. In our example, we’ll choose Georgia.
  • The text will change to the selected font.

To change the font size:

  • Select the cell(s) you want to modify.
  • Click the drop-down arrow next to the Font Size command on the Home tab. The Font Size drop-down menu will appear.
  • Select the desired font size. A live preview of the new font size will appear as you hover the mouse over different options. In our example, we will choose 16 to make the text larger.
  • The text will change to the selected font size.

To change the font color:

  • Select the cell(s) you want to modify.
  • Click the drop-down arrow next to the Font Color command on the Home tab. The Color menu will appear.
  • Select the desired font color. A live preview of the new font color will appear as you hover the mouse over different options. In our example, we’ll choose Green.
  • The text will change to the selected font color.

To use the Bold, Italic, and Underline commands:

  • Select the cell(s) you want to modify.
  • Click the Bold (B), Italic (I), or Underline (U) command on the Home tab. In our example, we’ll make the selected cells bold.
  • The selected style will be applied to the text.

To change horizontal text alignment:

  • Select the cell(s) you want to modify.
  • Select one of the three horizontal alignment commands on the Home tab. In our example, we’ll choose Center Align.
  • The text will realign.

To change vertical text alignment:

  • select the cell(s) you want to modify.
  • Select one of the three vertical alignment commands on the Home tab. In our example, we’ll choose Middle Align.
  • The text will realign.

To add a border:

  • Select the cell(s) you want to modify.
  • Click the drop-down arrow next to the Borders command on the Home tab. The Borders drop-down menu will appear.
    Select the border style you want to use. In our example, we will choose to display All Borders.
  • The selected border style will appear.

To add a fill color:

  • Select the cell(s) you want to modify.
  • Click the drop-down arrow next to the Fill Color command on the Home tab. The Fill Color menu will appear.
  • Select the fill color you want to use. A live preview of the new fill color will appear as you hover the mouse over different options. In our example, we’ll choose Light Green.
  • The selected fill color will appear in the selected cells.

To apply a cell style:

  • Select the cell(s) you want to modify.
  • Click the Cell Styles command on the Home tab, then choose the desired style from the drop-down menu. In our example, we’ll choose Accent 1.
  • The selected cell style will appear.

To apply number formatting:

  • Select the cells(s) you want to modify.
  • Click the drop-down arrow next to the Number Format command on the Home tab. The Number Formatting drop-down menu will appear.
  • Select the desired formatting option. In our example, we will change the formatting to Long Date.
  • The selected cells will change to the new formatting style. For some number formats, you can then use the Increase Decimal and Decrease Decimal commands (below the Number Format command) to change the number of decimal places that are displayed.
Liked it? Take a second to support Ranjan on Patreon!
become a patron button
  • Click to share on Reddit (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • More
  • Click to share on Pocket (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
Written by Ranjan - 1217 Views
AUTHOR
Ranjan

Namaste, My name is Ranjan, I am a graduate from NIT Rourkela. This website is basically about of what i learnt from my years of experience as a software engineer on software development specifically on mobile application development, design patterns/architectures, its changing scenarios, security, troubleshooting, tools, tips&tricks and many more.

Next Post
Previous Post

Support us

mycodetips
mycodetips

Follow us @ LinkedIn 2850+

Subscribe for updates

Join 8,213 other subscribers

Latest Posts

  • YT-Featured-solidprinciples
    SOLID Principles of Software Design
  • IOS 16 Features
    Latest features in IOS 16
  • r-language
    How can R language be used for data analysis?
  • wordpress-coding-blog
    Guide To WordPress Coding Standards
  • YT-Featured-Algorithm
    What is Algorithm?
  • Frameworks of IOS
    Frameworks of IOS – Part ( I )
  • NSFileManager or NSPathUtilities
    NSFileManager or NSPathUtilities in Objective-C
  • Passing data between view controllers in Objective-C
    Passing data between view controllers in Objective-C
  • structures-classes-enum
    Structures and Classes in swift !
  • control-system-swift
    Control Flow in Swift
whiteboard

Whiteboard(PRO)

whiteboard

Whiteboard(lite)

alphabets

Kids Alphabet

techlynk

Techlynk

techbyte

Do2Day

techbyte

Techbyte

  • #about
  • #myapps
  • #contact
  • #privacy
  • #Advertise
  • #myQuestions

Android Android Studio API APP Programming Apps blogging CSS DATABASE dsa Features HTML HTML5 installation Interview Questions IOS iPhone javascript Mac objective-c OS Programming quicktips SDK SEO SQL swift Tips & Tricks Tools UI Web Wordpress Xcode

  • SOLID Principles of Software Design
  • Latest features in IOS 16
  • How can R language be used for data analysis?
  • Guide To WordPress Coding Standards
  • What is Algorithm?

©mycodetips.com