microsoft excel course - Excel Question

The UK's most regular instructor-led training courses.
Training information: microsoft excel course · Excel/courses/london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel Question

Elizabeth has attended:
Excel Introduction course

by - delegate Elizabeth [1 post] (2007 Jul 2 Mon, 13:49) Reply

How do I move lots of columns together?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 26 Tue + 27 Wed	Bayswater	4	book now	£475	£485
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	5	book now	£450	£485
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 45 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel Question

by - trainer Amanda platinum contributer [947 posts] (2007 Jul 3 Tue, 12:29) Reply

Hi Elizabeth

Thanks for your question.

You can do this by selecting the columns you wish to move then right-click and choose Cut.

Then select the column to the right of where you want the columns to be inserted, right-click and choose Insert Cut Cells.

Note that you can only move multiple columns in this way if the columns are next door to each other in the spreadsheet. If they are not next to each other, you need to cut and insert them one at a time.

Amanda

· Advanced Excel Training - takes you to the next level
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Microsoft Excel Features and Functions for Accountants
· What's Better Than the Help Function in Excel? Microsoft Training

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips