Navo Hosting

Navohosting

New Features To Enhance Google Sheet Visibility

Google Sheet

Google Sheet New Features

Google Sheet is the online collaboration spreadsheet application offered by Google in Google Workspace. It is an online collaborative spreadsheet used from anywhere. Sharing a spreadsheet is easy and is edited in real-time. Features such as smart fill and formula suggestions are available. Sheets are connected seamlessly with other Google Workspace applications. Easily edit in Microsoft Excel file format. Edits were saved online automatically. Everyone works on the updated version of a file. Let us check the new Google sheet features here. Use the tips to improve the performance of Google Sheets to increase productivity.

Latest updates in Google Sheets:

Google sheet new features are updated by Google Workspace here.

Improve Sheet Visibility

When you pin the data in the same place and see it when you scroll it, one can freeze rows or columns. Formatting is necessary for the spreadsheets as more data is present. Here we can see freeze/unfreeze columns, conditional formatting sheets, protect the sheets, and set permissions.

How to Freeze columns in sheets?

  • Open the sheets.
  • Select a row/column you want to freeze/unfreeze.
  • Click view 
  • Freeze.

Unfreeze Columns in google sheets

  • Select a row or column.
  • Click view. 
  • Freeze.
  • No rows / No columns.

 

Google Sheet

Use charts to summarize spreadsheet data

The spreadsheet data provides more data. The data are summarized in the table to chart. There are various charts available in the sheets, Follow the steps to summarize sheet data.

  • Highlight the range of data you want to create a chart for.
  • Click Insert > Chart.
  • In the editor, change the chart type and other aspects.

 

 

Conditional Formatting 

The conditional formatting highlights values or makes particular cells easy to identify. The appearance of a cell was based on certain conditions. 

  • Select the cell/range of cells to which formatting rules be applied.
  • Click format > Conditional formatting.
  • Define conditions for specific text /cell background color.
  • Click done.  

 

 

Email notifications update 

  • Select tool.
  • Notification rules.
  • Select when & how you want to receive notifications.
  • Click save.

Protect a sheet

If you don’t want your sheet edited use the ‘protect sheet’ option. You can set the protection. After using protect a sheet, you cannot simultaneously lock the formatting of cells and allow users to edit the input values, Protect the data with a password.

  • Open spreadsheet.
  • Click data.
  • Protect sheets and range.
  • Add sheet or range.  
  • To protect the sheet, click the sheet for range click range. 

 

 

Set permissions / Change permissions

The permission settings allows you to make the person to have edit access to the files. To show a warning when anyone edits a sheet. Select show warning when editing this range.

Choose who can edit

  • Only you /Only domain /Custom.
  • Copy permissions from another range.
  • Click save or done.

 

Hide / Unhide sheet 

The data in the sheet are important to the users. So if you want to hide the sheet you can use the hide option. You can also use the unhide the sheet option by following the steps.

Hide a sheet

  • Open a spreadsheet.
  • Click the sheet you want to hide.
  • Click the down arrow.
  • Hit the Hide sheet.

How to unhide a sheet

  • Click view. 
  • Show.
  • Click the sheet that you no longer want to hide.
  • The spreadsheet will reappear on sheets.

 

Navohosting offer services below for the users

  • Google workspace
  • Domain & Hosting
  • Bulk SMS
  • Web designing

The google sheets are used to create and collaborate spread sheets online. The beginner tips and tricks for google sheets is updated here. If you need further details about our services check us.

Facebook
Pinterest
Twitter
LinkedIn

2 Responses

Leave a Reply

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