كورس اوفيس 2010 - اكسل - 12 - تبويب فيو وخصائص الطباعة

Exploring Tab View and Its Options

Navigating Open Files

• The presenter introduces the Tab View feature, highlighting its utility in switching between multiple open files.

• The "Switch Windows" option allows users to navigate between open files, such as "Table Sort" and "Book 3."

Screen Splitting for Data Comparison

• Users can split their screen to view different parts of a large file simultaneously, enhancing data comparison.

• The screen can be divided into two, three, or four sections, allowing movement in various directions while keeping one section fixed.

Freezing Panes for Better Visibility

• The "Freeze Panes" option helps keep specific rows or columns visible while scrolling through large datasets.

• Activating "Freeze Top Row" keeps the first row static on the screen for easy reference while navigating through other data.

Advanced Freezing Techniques

• Users can freeze the first column using the "Freeze First Column" option to maintain visibility of key identifiers.

• To freeze multiple rows or columns, users select a cell below or to the right of the desired range before applying "Freeze Panes."

Saving Workspace for Future Use

• The "Save Workspace" feature allows users to save their current layout and position within files for future sessions.

• This function ensures that when reopening Excel, users return exactly where they left off in both files.

Comparing Multiple Files Side by Side

• The presenter demonstrates how to use the “Arrange All” feature to view two files side by side either horizontally or vertically.

• This setup is beneficial for comparing data across documents without losing context.

Understanding Excel's View Options

Opening New Windows and Zooming

• A new window opens the same file, creating a duplicate view (Table Sort 1 vs. Table Sort 2). Changes in one reflect in the other.

• The "Zoom to Selection" feature enlarges the selected cell area for better visibility, while returning to 100% zoom adjusts the overall view.

• Users can hide elements like formula bars, headers, and gridlines for a cleaner interface; these are essential features of Excel.

Full Screen and Custom Views

• The full-screen option maximizes workspace by filling the screen with the Excel interface; it can be exited using the Escape key.

• Custom views allow users to save specific display settings for easy access later.

Page Layout and Print Preview

• Different viewing modes include Normal, Page Layout (for print formatting), and Page Break Preview (to manage page divisions).

• Users can adjust page breaks by dragging them in Page Break Preview mode to optimize printed output.

Managing Page Breaks

• Inserting page breaks allows users to divide content into smaller sections for printing; this is crucial for large files.

• Resetting page breaks returns layout to default settings, ensuring ease of management when adjusting print layouts.

Printing Titles Across Pages

• To maintain clarity across multiple pages, users can set row titles to repeat at the top of each printed page.

• The "Print Titles" option enables selection of rows or columns that should appear on every printed page for consistency.

Finalizing Print Settings

• Adjustments made ensure that column headers are visible on all pages during printing, enhancing readability.

• Users can also specify how pages are numbered during printing—either sequentially or based on custom arrangements.

Printing Options and Background Settings in Document Editing

Setting Print Area

• Users can define a specific print area by selecting the desired section and using the "Set Print Area" option, which restricts printing to only that selected part.

• When previewing the file for printing, only the defined print area will be visible, confirming that no additional pages are included.

Background Image Configuration

• Users can add a background image to their document by selecting an image file; however, it may not be visible until switching from Normal View to another view mode.

• The background image is automatically tiled if it's smaller than the page size, but there are limitations on adjusting its color or size directly within this setting.

Page Break Management

• Returning to Normal View after setting page breaks allows users to see these breaks clearly marked, aiding in document layout management.

• Changing the orientation of a sheet affects only the current sheet being worked on; other sheets remain unchanged unless modified individually.

Printing Layout Adjustments

• Users can specify how many pages should fit horizontally and vertically when printing. This flexibility allows for customized layouts based on user preferences.

• The same options available in print settings allow users to select specific sheets or ranges of pages for printing, enhancing control over what gets printed.

Copy and Page Orientation Settings

• Users can determine how many copies of each page they want printed and set whether they prefer portrait or landscape orientation for their documents.