Category: Uncategorized

Google Docs Tips – Open a New Document

logo_docs

Google document is much better application than Microsoft Word.

The main difference is, Google Docs is free and widely used nowadays. This post will help you understand how to open a new document while starting with Google Docs.

  • Sign in to your Google Doc account by going to the link http://docs.google.com
  • You will see the below page opening

Google Docs Overview

  • On the Menu bar you will see New menu, click on it

[ad#post-link]

Google Doc Open a new Document

  • As seen in the above image click Document
  • This will open a new window with the new document
  • The below page will load

Google New Document

  • The new Google documents are named as Untitled by default, you can edit the by clicking on the Untitled word
  • Google docs save the work automatically, you also have the option of saving the document and also Save and Close the Google Document
  • As mentioned in the image you have nice working space similar to MS Word document

I will explain more about the menu and formatting the documents in my future posts

Subscribe to my feed to get more updates on Google related tips
[ad#post-link]

MS Excel Tips and Tricks – Change the Cell format from Text to Number

When you use Microsoft Excel, You will sometimes find that the numbers are not calculated properly. This is mainly because of the cell format.

Excel accepts Text and the Number input, it has the great capability to interpret between two. All the Excel cells are in General format, when you start working on any Excel sheet It automatically allots the format to each cell based on the characters inside.

If you see any cells containing the numbers but are aligned left side, you need to understand that the cell format is in Text mode. Whenever you see the numbers in any cells arranged in right side, The cell format is in Number.

Excell Cells in Text format

The calculation only works if you have the cell in numbers format

You can change the format from Text to Number by following the method below

Click on any empty cell and right click

Excel Format Cell Menu

Choose cell formatting

You will see a menu opening as seen below

Excel Format Cell Options

Under the Number Tab, Click number as shown in the image

Choose the decimal you want to have, make it ‘0’ if you do not want any decimal

Click OK to save

Now type ‘1’ in the cell that you have changed the format, Press enter

Then copy the cell

Copy Cell

Now select all the cells that you want to be changed to Number formatting

Then right click and choose Paste Special

Excel Cell Paste Special

Excel will give you Paste special Options as seen below

Excel Cell Paste Special 1

Choose Multiply

Then click OK, Do not change any other values

Now you will see all the selected cell formatting changed to Numbers and Excel automatically aligns the numbers to the right side

Excel Number Formatting

Now your calculation should work

If you have any questions or suggestions, please post a comment

Read More Tips and Tricks from our website