HOW TO HIDE AND MANIPULATE CELLS IN GOOGLE SHEETS

Collaborative, cloud-based tool Google Sheets was introduced in 2012 Google Sheets. It is versatile spreadsheet software that provides a ton of different features for both professional and personal use cases. It’s cloud-based where spreadsheets are automatically saved, stored, and maintained via a remote server. Google Sheets is also available offline. It’s free. It works across devices. You can access and edit Google Sheet data from a wide variety of devices (like your Smartphone, tablet, and computer). Plus add-ons are available.

Questions like how to interact between the multiple pieces of software and ensure compatibility or how to move rows or organize files within the GSuite often comes in the user’s mind. So it’s important to know how to manipulate the different aspects of this spreadsheet so they can ensure maximum proficiency.

Here’s a guide given on how to hide cells in Google Sheets and ways to keep up your workflow within the Google Sheets software.

STEPS TO HIDE CELLS IN GOOGLE SHEETS

In Google Sheets you actually can’t hide individual cells when working with the software because it would actually make the spreadsheet break the workflow as well as make it look strange. But there are ways to do it, just not individually.

  1. You have to hide objects in Google Sheets via the row or column they are placed within, instead of hiding cells by themselves.
  2. Log into Google Sheets via its official website.
  3. Go into the preferred spreadsheet, hold down left-click and drag over the cells you’d prefer to hide.
  4. Go over to the number on the left of the row or top of the column, right-click it, and select the hide option.
  5. To recover these hidden cells, click on the pair of arrows attached to the outer barriers of the cells you’ve chosen to hide.

Let’s see a few tips to show you to increase your other Google Sheets proficiency:

STEPS TO MANIPULATE ROWS AND COLUMNS
  1. Take your left-mouse button and by clicking it down and holding it while dragging it across the desired cells select the rows and columns you’d like to manipulate.
  2. Select the Edit tab on the top left of the spreadsheet.

You can pick from an array of different options as given below.

MERGING CELLS
  1. Select an array of cells you’d like to merge,
  2. Head up to the “Format” tab on the top left of the screen,
  3. Maneuver to “Merge Cells,” and select between “Merge All,” “Merge Horizontally,” or “Merge Vertically.”

You can also do the same with rows and columns in the same way.

MOVING A ROW OR A COLUMN

You can move the information in rows and columns up/down and left/right respectively.

  1. Select the cells.
  2. Go to the Edit tab on the top left.
  3. Choose the move option within the list.
CHANGE ROW HEIGHT

You can do this either manually or by entering different inputs.

  1. Hover your mouse under or on top of the row you want to edit.
  2. Click and drag either up or down and adjust it as per your requirement.

OR

  1. Just right-click on the number of the row you want to modify.
  2. Go down the drop-down list into “Resize Row.”
  3. A pop-up box will appear, and you can enter your desired row height in pixels.
  4. Click okay and you are done.

Leave a Reply

Your email address will not be published. Required fields are marked *