learn excel in london - organize data

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » learn excel in london - Organize Data

learn excel in london - Organize Data

resolvedResolved · Low Priority · Version Standard

Julie has attended:
Excel Introduction course
Excel Intermediate course

Organize Data

How do you hide and display data and create outlines to organise data?

RE: Organize Data

<b>To HIDE and DISPLAY<b/>

Select the rows or columns that you want to hide.
Right click > HIDE.

To display, select the two rows or columns to either side of the ones you want to display. Right click > UNHIDE.


<b>Create Outlines <b/>
Select the data that you want to outline, then select
DATA > Group & Outline


 

Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips


Server loaded in 0.28 secs.