📊 Curso Google Sheets ✅ Inmovilizar, ocular y agrupar celdas, filas y columnas

How to Combine and Group Cells, Rows, and Columns in Google Sheets

Introduction to Combining and Grouping

• The video focuses on combining and grouping cells, rows, and columns in Google Sheets while customizing the spreadsheet for specific information needs.

Adding New Data

• To add more data, select the desired column (column J) and drag it to the right using the "+" button. This action applies existing formatting from column J.

• If alternating colors were used previously, they may not appear correctly after adding new data; adjustments can be made later.

Applying Alternating Colors

• After creating new data by dragging downwards, reduce the view size for better visibility.

• To apply alternating colors across all data, select a cell with existing formatting and navigate to "Format" > "Alternating Colors." Adjust the range from A1:J15 to A1:Y44 for full coverage.

Freezing Rows and Columns

• The video demonstrates how to freeze rows or columns for easier navigation through large datasets. For instance, freezing the first column keeps it visible while scrolling horizontally.

• Access this feature via "View" > "Freeze," allowing users to keep essential information like student names visible as they scroll through grades.

Advanced Freezing Options

• Users can freeze multiple columns (e.g., A & B), ensuring that these remain static while other columns move.

• It is also possible to freeze several rows at once; selecting any cell in row 5 allows you to freeze up to that point.

Unfreezing Rows/Columns

• To unfreeze any previously frozen rows or columns, go back to "View" > "Freeze" > "No Rows" or "No Columns."

Hiding Information

• When dealing with extensive spreadsheets, certain columns or rows can be hidden. Right-click on a column letter or row number and select “Hide” from the menu.

Managing Hidden Columns and Rows in Spreadsheets

Understanding Hidden Data

• Internal data remains unchanged when reading the spreadsheet. To view hidden columns, hover over the dividing line between columns A and C where two arrows indicate hidden information.

• Avoid confusion with downward arrows that represent column options. Clicking on these will reveal previously hidden columns, allowing for multiple columns to be unhidden simultaneously.

Unhiding Rows and Grouping Cells

• Similar to columns, rows can also be hidden. Hovering over the arrows indicates hidden rows; clicking them will make them visible again.

• The concept of merging cells is introduced, which allows for grouping multiple cells into one. Selecting a range (e.g., B2 to E3) enables various types of cell combinations.

Types of Cell Combinations

• The first method is "Merge All," which combines all selected cells into one single cell while retaining only the top-left value.

• Upon merging, a warning appears indicating that only the upper-left cell's content will remain after merging; other data will be lost.

Horizontal and Vertical Merging

• The second method is "Merge Horizontally," which combines cells across rows while keeping each row's leftmost value.

• After horizontal merging, two separate cells are created for each row containing their respective leftmost values.

Advanced Grouping Techniques

• The third method is "Merge Vertically," creating individual cells for each column in the selection while retaining data from above.

• This results in multiple new cells being created based on the original data layout.

Creating Groups of Rows or Columns

• To group several rows or columns together, select desired ranges (e.g., B through D), right-click, and choose to group them. This creates an expandable/collapsible icon for easy management.

• Using this grouping feature allows quick visibility toggling without needing to hide/unhide individual elements repeatedly.

Efficiency in Managing Visibility

• Grouped items can be quickly shown or hidden using icons rather than going through menus repeatedly—this enhances efficiency compared to traditional hiding methods.

• Similar functionality applies to rows; selecting multiple rows allows for grouping with an identical icon system for visibility control.