microsoft+excel+training - rowscolumns excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum 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

resolvedResolved · Low Priority · Version Standard

replyReply Thu 2 Aug 2007, 09:51Delegate Joanna said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Thu 2 Aug 2007, 10:19Trainer Amanda said...

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

 


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard