كورس اوفيس 2010 - اكسل - 6 - جزء 2 - تنسيق الخلايا

Formatting Text in Excel

Basic Formatting Techniques

• The speaker discusses standard text formatting options available in Excel, similar to those in Word, including changing font type and size, making text bold or italicized, and adding borders around cells.

• To change the text color within a cell while in edit mode, the speaker notes that simply changing the color will not take effect unless the cell is selected properly.

• The importance of selecting content correctly for formatting changes is emphasized; either by single-clicking on a cell or double-clicking to highlight specific text.

Merging Cells

• The option to merge cells is introduced, allowing multiple cells to be combined into one. This can be useful for centering titles across several columns.

• After merging cells using "Merge and Center," the text aligns centrally within the merged area. Adjustments can be made post-merging for better visibility.

Text Alignment Options

• Various alignment options are available for positioning text within a cell. Right-clicking provides access to more advanced alignment settings where angles can also be adjusted.

• The speaker demonstrates how to set vertical and horizontal alignment preferences, such as placing text at the top or bottom of a cell.

Wrapping Text

• When dealing with long sentences that exceed cell width, wrapping text allows it to display over multiple lines instead of spilling out of the cell boundaries.

• The formula bar helps identify which cells contain data when working with wrapped text.

Additional Formatting Features

• Options like "Shrink to Fit" help adjust font size automatically so that longer texts fit within smaller cells without overflowing.

• Background colors can enhance visual appeal; however, if they obscure text visibility (e.g., white font on white background), adjustments must be made accordingly.

Exploring Format Cells Dialog

• Accessing format options through right-clicking allows users to modify number formats, alignments, fonts (including bold and italics), borders, and fill patterns effectively.

How to Protect Cells and Use Custom Lists in Excel

Protecting Cells in Excel

• The speaker discusses removing text from a selected cell and accessing the "Format Cells" option to set protection features, including locking cells to prevent changes.

• A warning is noted that certain options will only work if the sheet is protected. The speaker selects both "Locked" and "Hidden" options for the cell.

• After attempting to change the locked cell, it remains unprotected until the sheet itself is protected with a password.

• Once protection is applied, not only can users not edit the cell, but they also cannot view any formulas or functions contained within it.

• The importance of hiding formulas while allowing visibility of results is emphasized; this prevents others from seeing how calculations are made.

Unprotecting and Adjusting Cell Protection

• To revert changes, the speaker demonstrates how to unprotect the sheet by entering the same password used for protection.

• It’s explained that while some cells can be locked for editing, their content can still be visible unless marked as hidden.

• The discussion includes using auto-fill features in Excel for automatic data entry based on predefined lists.

Utilizing Custom Lists for Auto-Fill

• The concept of custom lists is introduced, allowing users to create personalized auto-fill options beyond standard days of the week or months.

• Users can input frequently used names or data into a custom list so that when entering new files, they can quickly fill in information without retyping everything.

• Instructions are provided on how to access and edit custom lists through Excel's advanced options menu.

Creating and Managing Custom Lists

• Steps are outlined for creating a new custom list by entering names sequentially without spaces between entries.

• Upon completion of adding names to a custom list, users can utilize auto-fill functionality effectively with those entries in future documents.

Deleting Unwanted Custom Lists

• If a user no longer needs a specific custom list, they can delete it through advanced options by selecting and confirming deletion.