Filling out multiple columns in Excel problem

Asked By henryka 0 points N/A Posted on - 11/06/2011

Hello,

Please guide me.

I am working with Microsoft excel 2007 and I am using excel table with a lot of repeated information I would like to know how I can fill out multiple columns at the same time without having to fill it manually.

Thank you.

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

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by jiniya

Go To Solution

Best Answer

Best Answer

Answered By jiniya 0 points N/A #105761

Filling out multiple columns in Excel problem

Hi!

If I have understood your question right, I have the simple solution for this. Click on the cell where the value should be repeated. Click on the lower right of the border in which your cursor will turn into a cross and drag it to other cell. It will automatically copy the value of the chosen cell to the other cell where you have dragged the cursor.

If the dragged method does not fit your needs, I have other method for you using the "=" sign. Identify the position of the cell in which the repeated information is placed. For example if the repeated information is located in A10 cell, then enter this data in other cell: "=A10". Do not include the quote.

About jiniya

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 11/09/2011
• Question Category: MS Excel

Answered By jamesstave 0 points N/A #105762

Filling out multiple columns in Excel problem

 

I think you will be in simple problem. It has particular and possible answers to solve your question. In MS Excel consist of columns and rows these are necessary requirement of the excel, normally we apply rows and columns to build charts where in excel spread sheets, so according to your question haven’t any relevant tab or option for insert multiple columns at same time in spread sheets. That is the reason you excite as like that.

 

First you must select the multiple columns in sheet( ex-K and L column).put the mouse pointer on word K top of the sheet then drag on to letter M You can these two columns are select. Then select insert option where in the cells group. Again select insert option in cell group after click inset sheets columns. These steps will be helpful your question, so you can consider this image.

About jamesstave

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/11/2011
• Question Category: MS Excel