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
• Deleting Columns
  • Delete a Column
  • Delete Multiple Columns In Bulk
• Editing Columns
  • Editing the Value
  • Apply a Function
• Adding a column
• Renaming Columns
• Moving Columns
  • Move Columns in Manage Columns
  • Move Columns in Right Hand- Panel 
• 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"I have

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

Deleting Columns

Delete a Column

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

Go to the right hand side and select "Show/Hide" columns you want deleted. Once the sheet appears how you'd like, go to Edit > Delete > Hidden Columns.

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.

Editing 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.

Adding a column

Add a column by select the "+" on the right hand corner of the sheet, then switch to Formula to "Blank Column"

Renaming 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:

Moving 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. 

Move Columns in Manage Columns

Click and drag the six dotted icon on the Manage Columns Tab.

You can also move columns to the start or end: 

Move Columns in Right Hand- Panel 

Click and drag the six dotted icon on the right-hand Panel 

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.