Split screen

Resolved · Low Priority · Version 2007

Wed 29 Jun 2011, 16:48 Delegate Debbie said...

Debbie has attended:
Excel Intermediate course
Excel Introduction course

Split screen

can you sort data by filters beforeor after splitting?

Thu 30 Jun 2011, 09:33 Trainer Stephen said...

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

Training courses

	98.8 % recommend us
	More live stats...

Training information:

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