Problem operating MS Excel and adding column in database

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Sherin Viluel
Answered By 25 points N/A #98231

Problem operating MS Excel and adding column in database

qa-featured

 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

Best Answer
Best Answer
Answered By 0 points N/A #98233

Problem operating MS Excel and adding column in database

qa-featured

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.

 

 

Related Questions