Excel Cell Formating

Today I would like to present you some tips on excel formatting;

1. Formatting an excel cell to Text, Number, Date
, Time, Currency, Accounting, special or custom.

       
Select any excel cell and then on the menu click on Format then click
on cell you can also use shortcut to open the cell formatting box directly
by holding Ctrl+1 key, as shown in the following figure.

Image and video hosting by TinyPic

   As in the above figure
you can see Category box from where you can change the cell format to your
desired format. You can do lot more than format in an excel cell. Make
your excel cell a digital clock or digital image viewer, whatever you want
just imagine and do it by using all the advanced features of cell
formatting  to know more about how to do it just give a comment to
this post.

       

Comments

  1. 愛鋒頭February 5, 2010 at 12:15 AM

    Never put off till tomorrow what may be done today..........................

    ReplyDelete
  2. Adelle - IshaSeptember 24, 2010 at 2:43 PM

    Hello! Very cool your tips, do not always use the full capacity of the office in general and you gives important tips here .. I'm happy to be able to follow him

    May your days be sweet like honey.
    Kisses

    ReplyDelete

Post a Comment

Your Comment Please!

Popular posts from this blog

Office on phone a smartest way

Image
        The trend of smart users is growing as the phone industry is making the smart phones for the smart guys. Now its a old news that you access all your documents on smart phones like Nokia, Samsung, Sony Ericson, LG, XOLO, Micromax, Karbon almost all windows and android phones. These apps have been made user friendly with emerging technology today and can let you access your office documents, personal or business documents with hassle free ms office applications on your smart phone. You can Create, View , Edit and print all you want. So we are very soon provide you the information and more of the apps that work on your smart phones.
Read more

Spirograph in Excel

Image
Besides excel's excellent features there is yet another face of excel which amuses every excel user with fun and games in ms excel. Take a look at the fun of spirographing in excel. Hope you will enjoy this post. This is a fun little spreadsheet that lets you create a spirograph. Try playing with the slider bar and modifying some of the parameters to change scaling and the number of "spokes".     Download Now source: vertex42.com
Read more

Get started on your job hunt with Word templates

Image
Applies to Ms Word 2002 and 2003 Looking for a new job can be challenging, but sometimes a tiny boost can give you a huge head start. You can find the boost you need at the Templates on Microsoft Office Online Web site, which offers hundreds of preformatted templates and example documents that you can download to use with Microsoft Office 2003 and Microsoft Office XP. By using templates that are designed just for your job search — including resumes, cover letters, and letters of acceptance — you can avoid the overwhelming task of starting with a blank page. Templates give you a starting point as you modify job information to match your own experience. The formatting and layout are already done, so you can focus instead on the words and content that really make you stand out. Use templates from the Office Templates site Click one of the links listed, or find a template that you want to use on the Office Templates Web site. When you find the template that you want, click the Downl...
Read more