Format Worksheet

Format Worksheet
Convert Text to Columns
Sometimes you will want to split data in one cell into two or more cells. You cando this easily by utilizing the Convert Text to Columns Wizard.

§     Highlight the column in which you wish to split the data
§     Click the Text to Columns button on the Data tab
§       Click Delimited if you have a comma or tab separating the data, or click fixed widths to set the data separation at a specific size.
Modify Fonts

Modifying fonts in Excel will allow you to emphasize titles andheadings. To modify a font:

§     Select the cell or cells that you would like the font applied
§       On the Font group on the Home tab, choose the font type, size, bold, italics, underline, or color
Format Cells Dialog Box

In Excel, you canalso apply specific formatting to a cell. To apply formatting to a cell or group of cells:

§     Select the cell or cells that will have the formatting
§     Click the Dialog Box arrow on the Alignment group of the Home tab

There are several tabs on this dialog box that allow you to modify properties of the cell or cells.

Number: Allows for the display of different number types anddecimal places Alignment:  Allows for the horizontal and vertical alignment of text, wrap text, shrink text, merge cells and the direction ofthe text.
Font: Allows for control of font, font style, size, color, and additional features
Border: Border styles and colors
Fill:  Cell fill colors and styles

Add Borders and Colors to Cells
Borders and colors can be added to cells manually or through the use of styles. To addborders manually:

§     Click the Borders drop down menu on the Font group of the Home tab
§     Choose the appropriate border
 To apply colors manually:


§     Click the Fill drop down menu on the Font group of the Home tab
§     Choose the appropriate color
 To apply borders and colors using styles:


§     Click Cell Styles on the Home tab
§     Choose a style or click New Cell Style


    Category List

    • 3D Animation Video
    • 3D presentation
    • 3G
    • 3G Data Cards
    • 5 Essential Diet Tips
    • A Way to Earn $100 A Day..Capitalize on FaceBook
    • Accessories
    • Adsense
    • Amazon
    • Android
    • Apple
    • Approval
    • Article
    • basic I.T
    • best ways of burning fat
    • Bike
    • biomedical
    • Biomedical Engineering
    • BlackBerry
    • Blogs
    • Bodybuilder
    • Bodybuilder Diet
    • Bodybuilder's Diet
    • Books
    • brain
    • Brain Cancer
    • brain structure
    • Brain Tumor
    • Brain wired for learning
    • Breakfast Diet
    • Bucknell Engineering Week
    • Bucknell Engineering Week-2013
    • Burning Fat
    • Camera
    • Cancer
    • caner treatment
    • Cars
    • central nervous system
    • common diseases
    • Computer
    • Cricket News
    • CSK News
    • Dengue Virus
    • Dengue Virus Infection
    • Devices
    • Diabetes
    • Diabetes overview
    • Diabetes patients
    • Diet
    • Diet for Bodybuilder
    • DNA
    • DNA Replication
    • Energy
    • Essential Diet Tips
    • facebook
    • Facebook Timeline
    • Filter Blood
    • four fundamntal human tissue
    • Games
    • gift cards
    • ginger
    • Google
    • hacking
    • Health benifit
    • Healthy Breakfast
    • Healthy Breakfast Routine
    • Heart
    • Heart Failure
    • Heart Failure Video
    • Hiv
    • HIV replication
    • Host web site server
    • How to create a Google AdSense account
    • How to Earn Money on YouTube
    • How To Earn Money Online From PTC Sites ?
    • How to Get Visitors (Traffic) to Your Blog from Go...
    • How to Insert Heading Tags to Blogger Blog Posts
    • How To Make Money From Facebook?
    • How to Make Money From Google : Proven Strategy
    • How To Make Money Online on YouTube
    • How To Make Money Online With Google AdSense?
    • How to Use Post Title As Title Tag in Blogger Blog
    • human body
    • Human nervous system
    • human tissue
    • If you already have a Google AdSense account
    • iMotion
    • Indian News
    • Information
    • INTERNET
    • iPad
    • IPL News
    • Jobs
    • Kidney
    • Laptop
    • Laptops
    • LG
    • LG Nexus
    • Make money
    • Make Money Online in India : An Adsense Gameplan
    • Make Money Online in India The Hard Way
    • Make Money Online Strategy in 2013 & Beyond
    • Make more money with Google Adsense – Simple trick...
    • Making Money Online From Home Possible?
    • medical debate
    • medical science
    • Medical video
    • medicalvideo
    • medicinevideo
    • Memory Card
    • Micromax
    • Microsoft Office Access 2007
    • Microsoft Office Excel 2007
    • Microsoft Office InfoPath 2007
    • Microsoft Office Outlook 2007
    • Microsoft Office Power Point 2007
    • Microsoft Office Word 2007
    • Mobile
    • Model Diet
    • Model's Diet
    • Model's Essential Diet Tips
    • Modern Medicine
    • Muscle building Secrets
    • Nephron
    • nerve
    • nervous system
    • Nexus
    • Online Data Entry jobs in India & The Hard Reality
    • Player Diet
    • Player's Diet
    • Ptc
    • Reabsorb water
    • Reviews
    • Samsung's
    • Secret Nutrition Tips for Player
    • Security
    • Self-test
    • SEO Tips For Blogger Blogspot Blogs
    • Smartphones
    • Software
    • Solar Energy
    • Sports Nutration
    • Super Food
    • Symptoms of Brain Tumor
    • Tablet
    • Tablets
    • Technology
    • thyroid
    • thyroid diseases
    • Thyroid Test
    • Tips And Trick
    • Tools
    • Traditional Medicine
    • Traditional vs Modern Medicine
    • treatment
    • Tutorials
    • USB
    • Vehicle
    • vlc
    • Ways of cancer treatment
    • Web Development
    • webdesign
    • What is cancer
    • What it Takes to Earn Money Online in India
    • Wi-Fi
    • Wi-Fi Devices
    • Wi-Fi Printer
    • windows
    • windows 98
    • Windows Phone
    • Windows Vista
    • windows XP
    • ZTE

    Blog Archive

Bloggerized by FiyaGalito & | Powered By Movizac.com