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

split screen

ResolvedVersion 2007

Debbie has attended:
Excel Intermediate course
Excel Introduction course

Split screen

can you sort data by filters beforeor after splitting?

RE: split screen

Hi Debbie

Thanks for your question

Screen splitting has no effect on the data in a workbook. So filtering will work fine when the screen is split. However, in my experience it can sometime make the data difficult to fully understand.

Regards

Stephen

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

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.