Column Management

INTRODUCTION

Managing Columns in Gigasheet is easy in Gigasheet. You can Hide, Show, Delete, Edit, Rename, Move, and Resize Columns. This article will cover on how to do these functionalities. 

TABLE OF CONTENTS

• Hide/Show Columns
• Delete Columns
• Edit Columns
• Rename Columns
• Move Columns
• Resize Columns

Hide/Show Columns

To hide a column, or manage hidden columns, select the “Columns” icon on the right hand side of the page OR the Hide Columns tab on the top.  From there, a menu will appear in which you can select and unselect column titles. Doing so will hide the data from the sheet, and will exclude the data from any functions or groupings you do to the dataset. If you hide a column, and later decide you want it back, simply go to the columns menu (by clicking the icon in the right hand corner), and re-check the column title you wish to be visible again.

You can also "hide" columns by selecting the column header and "Hide" 

Another way to Hide/Show columns is the Right-Hand Menu: 

Delete Columns

To delete a column in Gigasheet, simple click on the column title for the column you wish to delete, and select the delete option. Please note, once a column has been deleted, you can not get it back. Only delete a column if you are sure you will never need or want the data again.

Delete Multiple Columns In Bulk:

The Data Cleanup > Delete Hidden or Visible Columns allows you to delete columns that are hidden/not hidden on the right hand Column Management panel. Simply go to Data Clean up, select Delete, and Delete Hidden Columns/Delete Visible columns.

Edit Columns

You can edit data in columns in two ways: 

• Editing the Value
• Applying a Function

Editing the Value

You can edit cells by double clicking the cell and typing in a new value. Simply press enter to save. 

Apply a Function

You can apply functions to create new ones. For example, if we have two columns containing costs and revenue, and we want a column for the total profit, we can not edit these columns directly to calculate this, but we can apply an formula function to calculate this. Once doing so, a new column will be created. See this article for more information on functions.

Add a column

Add a column by select the "+" on the right hand corner of the sheet

Rename Columns

To rename a column, simply click on the column header, select rename, input your new desired title, and hit save. You can also select the top tab to rename columns: 

Move Columns

There are a few ways to move columns in Gigasheet. The first is to simply select the column title of the column you wish to move, and drag it to it’s desired location. With many columns, this can be a bit tricky. Another way to move columns is by selecting the columns menu in the top right corner. Then simply drag the columns to their desired locations. 

Resize Columns

To resize a column, simply hover over the right or left side of the column title. Then, click the side you want to extend. Drag the cell to your desired width, and all cells within the column will adjust.

Video