98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - Rows/columns in excel
microsoft+excel+training - Rows/columns in excel
Resolved · Low Priority · Version Standard
Joanna has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Rows/columns in excel
how do i enter multiple rows or columns within a worksheet?
RE: rows/columns in excel
Hi Joanna
Thank you for your question.
When you say 'enter multiple rows or columns' I am assuming you mean to insert more than one row or column at a time.
As an example, say you want to enter four rows above row 9 in your spreadsheet:
1. Select rows 9, 10, 11 and 12 (4 rows)
2. Right-click on top of your selection and choose Insert. This should insert 4 rows for you above row 9.
You can do the same thing with columns, you just need to select the number of columns you wish to insert, to the right of the point where you want them to appear in the spreadsheet. For example, selecting columns A and B then using the method above will insert two columns to the left of column A.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |