Combination

Resolved · High Priority · Version 2007

Wed 6 Oct 2010, 16:34 Delegate Festus said...

Festus has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced course

Combination

kindly tell me the steps for using the consolidation tool on different worksheets

Thu 7 Oct 2010, 14:55 Trainer Simon said...

RE: combination

Hi Festus,

Thank you for your question and welcome to the forum.

I have included a link to explain how it works as it would take quite a long response to outline every step.

http://www.youtube.com/watch?v=HnHfO3Auimg

Try these sites:

MrExcel.com
ozgrid.com

I hope this helps.

Regards

Si

Thu 14 Oct 2010: Automatically marked as resolved.

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips

Combination

Combination

RE: combination

Excel articles

Excel tip:

Highlighting a data range