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.
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.
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.
