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

learn excel in london - organize data

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

learn excel in london - Organize Data

ResolvedVersion 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:

Removing border lines on the keyboard

Highlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.