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
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.
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.
You can edit data in columns in two ways:
- Editing the Value
- Applying a Function
Editing the Value
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
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:
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.
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.
Was this article helpful?
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
We appreciate your effort and will try to fix the article