split screen

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Split screen

Split screen

resolvedResolved · Low Priority · Version 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.




Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips

Server loaded in 0.06 secs.