Explainry Tutorials to Expert in IT

Category: Get Started

Freeze rows or columns in Google Sheets

Previous Lesson: Delete Cells or Rows This freeze feature enables you to pin data in the same place and you can see it during scroll. At the end of this lesson, you will be able to freeze rows or columns in Google Sheets. 1- Select a row or a column that you want to freeze. […]

Delete rows in Google Sheets

Previous Lesson: How to find and replace data in Google Sheets In this lesson, we will learn how to delete a single row or multiple rows in Google Sheets. 1- Go to the row (i.e. row 2 in our example) that you want to delete. 2- Do one of the followings: A- Do the right […]

Paste special in Google Sheets

Previous Lesson: Cut, copy & paste data This example illustrates various paste special options in Google Sheets. Cell A5 below has the SUM function which calculates sum of the range A1:A4. We also changed the cell A5 color to yellow and added border. Paste values only 1- To paste only values, first copy cell A5 […]

Cut, copy and paste data in Google Sheets

Previous Lesson: Undo, redo, or repeat an action Cut, copy and paste are spreadsheets’ features that allow to create duplicate content or move existing content to another location. In this lesson, we will learn how to copy/cut and paste data in other cells? Copy and paste data 1- To copy data, select cell or range […]

Save Google Sheets as an Excel File

Previous Lesson: Convert Excel to Google Sheets In this article, we will learn how to save Google Sheets File as an Excel File. Once you download the file in Excel format and save it to desktop then any change made will reflect in the Excel format file only. Because you have exported file to MS […]

Convert Excel to Google Sheets

Do the following steps to import your Excel’s file into Google Sheets: 1- Click on the File tab and select Open or press Ctrl+O. 2- Open a file window will open, click Upload and select Blue colored button. 3- Select an Excel file of your need and press Open. 4- Result. Excel file will open […]

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved