MS Excel 2007 - Lesson 14: Layout: Microsoft Excel

MS Excel 2007 - Lesson 14: Layout: Microsoft Excel covers the essential facts behind the topic, including what changed, why it mattered, and how it affected users.

Microsoft Excel Overview

TipsMake. Com - Split spreadsheet

This section explains the key facts, background, and practical implications of MS Excel 2007 - Lesson 14: Layout: Microsoft Excel. To separate spreadsheets:

• Select the central cells of the spreadsheet you want to split

• Click the Split button on the View tab

• The screen separation notice appears, you can manipulate each section separately.

Making freezing rows and columns

You can select a specific part of a spreadsheet to keep it unchanged while working with other sections. This is done through the Freeze Rows and Columns feature (freezing rows and columns):

• Click the Freeze Panes button on the View tab

• Select a part to freeze or click at the beginning of each column or left side of the LINE

• To cancel the freeze application, click the Freeze Panes button

• Click Unfreeze

Hide the spreadsheet

To hide spreadsheet:

• Select the sheet tab that you want to hide

• Right-click on that tab

• Click Hide

To cancel hidden spreadsheet:

• Right click on any spreadsheet

• Click Unhide

• Select a spreadsheet to cancel hiding.