Problem operating MS Excel and adding column in database

Asked By jones 10 points N/A Posted on - 02/15/2012

Hello,

By using Microsoft works, my ex- secretary creates a mailing list database for me.

But I don’t know much about it.

 I am well-known with Excel, but I can’t able to solve 3 things which are eluding me.

I need to add a column in the database.

Please give me a solution.

Thanks.

• Status: Open
• Question Views: 858
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Sherin Viluel

Go To Solution

Answered By brionas brain 25 points N/A #98231

Problem operating MS Excel and adding column in database

 Hello,

I will give you the solution to your problem 1st is right click on the column header where you want the new column to be added and then there will be a list that will show open choose insert, and there will be a menu will pop up and choose entire column, the new column will be inserted to the left of the selected column.

Good day sir, enjoy your stay here

About brionas brain

Questions
3

Answers
191

Best Answers
41

• Vote Up 0 Vote Down

• Posted on - 02/15/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Sherin Viluel 0 points N/A #98233

Problem operating MS Excel and adding column in database

If you want to add columns in the database there are many ways that you do it in Microsoft Excel.

Method 1

First go to the place where you want to insert a new column and select the entire column.

Important: If you select for an example column C the new column will be inserted in that place (it means to the column C) and the data which was in column C will be moved to column D.

Now click on the home tab and click on the insert option in then cells section.

 

Now you can see a new column has been inserted in column C.

 

Method 2

As above select a column where you want to insert a new column.

Then right click on the selected area and click on the “insert”.( Or you can use the short cut keys “Ctrl+” without right clicking)

 

 

Now you can see a new column has been inserted in column C.

 

 

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/28/2012
• Question Category: MS Excel