Easiest way to create table.

Are you searching for easiest way to create table in Microsoft Office Word???


The easiest way to create table in Microsoft Office Word is by using (+) and (-) keys from keyboard.

For example,

If you want to create table with three columns,

Press keys as below

 +-------+--------+------------+ 

and hit enter and see the magic.

Here, (+) works as column separator and (-) works as width of column. If you want column with longer width, press more (-) key.

If you want to add rows below, just go to the last cell in the table and hit tab button.

*** Please Follow Us if You Found This Post Useful ***

*** Happy Learning Friends***

Find us on facebook  :  www.facebook.com/cashelpline

Find us on twitter : www.twitter.com/CAsHelpline

Contact : cashelpline@gmail.com

Unable To Use MS Excel Filter Option???

Have you ever felt problems like this in excel, like,

>> Your Filters will not work.
>> If you write something in some cell of one sheet, it will        automatically update in same cell of another sheet.


Do you know, this, actually is not a problem. This happens because you have grouped the sheets.


How to ungroup the sheets and get rid of this?

Its easy, go to sheet name, click options(right click on mouse), select ungroup.

Note : Grouping of sheets is useful if you have to work on one sheet and you want same sheets to be backed up/copied to another sheet on real time manner.

*** Please Follow Us if You Found This Helpful***

***Enjoy Playing With Excel***

Find us on facebook  :  www.facebook.com/cashelpline

Find us on twitter : www.twitter.com/CAsHelpline

Contact : cashelpline@gmail.com

Advanced ALT Function For Excel

Are you bored of changing data types in Excel – like changing numbers of columns to number from text or changing format of dates? And whenever you try to do it from Home (Alt H H N), it will not work – it will show the data type of cell as number; however it is still not a number.

Today, I will tell you the easiest way to do so. Select the cell/column/row to be changed. Then hit (Alt D E D) simultaneously. This will open Text to Column option, which you can even do from home tab.

Suppose if you want to change the format of date from (01-01-2015) to (01-Jan-2014) then hit Alt D E D, press enter, press enter or choose option as per need ( how do you want to separate your dates, by using , or / or . ,then choose option as per your need.

Refer image below:

Then choose the date format you want. Hit enter, hit finish, it will change to another form, then follow same method and repeat the same method once, and then you got what you wanted.

For text to number or text to date,

Follow same method and choose text or general. And do it from (Alt H N N), this time it will change to the format you wanted.

***Enjoy Playing With Excel***


Find us on facebook  :  www.facebook.com/cashelpline

Find us on twitter : www.twitter.com/CAsHelpline

Contact : cashelpline@gmail.com