📊 Curso Google Sheets ✅ Ajustar texto, alineación y rotación

Google Sheets Text Formatting Overview

Introduction to Google Sheets and Data Series

• The video focuses on text formatting in Google Sheets, utilizing a previously discussed data series spreadsheet.

• The presenter opens the Google Sheets homepage and selects the "data series" spreadsheet for demonstration.

Inserting Rows and Columns

• To insert a row above existing data, right-click on the row number (1) and select "Insert above," creating an empty column before the data.

• Similarly, a column can be inserted by right-clicking on the column letter (A) and selecting "Insert left."

Entering Data for Formatting Demonstration

• The presenter enters sequential data labels such as "Series Number 1" and uses drag-fill to create subsequent entries like "Series Number 2," etc.

• Numeric data is also entered in sequence to showcase various text formatting options available in cells.

Adjusting Column Width

• Double-clicking between columns A adjusts their width to fit content; however, specific widths can also be set manually.

• The default overflow setting allows text to spill into adjacent empty cells but will cut off if there’s content in the next cell.

Text Wrapping Options

• Three text adjustment options are available: overflow (default), wrap (which moves excess text below), and clip (which cuts off any overflowing text).

• Changing column width automatically adjusts wrapped text according to its settings.

Text Alignment Features

Horizontal and Vertical Alignment

• Discusses horizontal alignment options: left, center, or right. Vertical alignment includes top, middle, or bottom adjustments.

• Demonstrates how different alignments affect cell content positioning within selected rows.

Practical Application of Alignments

• Shows practical examples of aligning numbers differently within cells based on desired presentation styles.

Resetting Changes

• Emphasizes using undo functionality (Ctrl + Z) to revert changes made during alignment adjustments.

Advanced Text Formatting Techniques

Modifying Text Orientation

• Introduces changing text orientation by increasing row height for better visibility of angled texts.

Understanding Text Rotation in Design

Default Rotations and Manual Adjustments

• The interface includes a rotation icon next to the settings, offering several default rotation options. Users can click on any option to adjust the text rotation accordingly.

• Alternatively, users have the ability to manually set the angle of rotation by selecting an icon that allows for custom input.

Custom Angle Input

• Users can specify any degree of rotation; for example, entering "12" would rotate the text by 12 degrees.

• There is also an option to display text vertically without actual rotation, maintaining the original orientation of letters while stacking them.

Vertical Alignment Options

• The feature labeled "pillar vertically" allows letters to be stacked directly on top of one another without rotating them, which may affect readability if space is limited.

• To achieve a 90-degree rotation, users should select specific options designed for this purpose.

Advanced Rotation Techniques

• Different selections allow for various rotations: turning upwards corresponds to 90 degrees, while turning right equates to 270 degrees.