How To Use Google Sheets Like Excel

Google will display a variety of templates under.

How to use google sheets like excel. Find the application by navigating to google sheets. You can set this up as follows. You can set your google drive to automatically convert subsequent uploads of excel files to google sheet format. But many people prefer sheets to excel for the simple reason that it s a google product. Both google sheets and microsoft excel allow you to create graphs and charts but excel gives you more options image credit.

Click on the gear icon on the top right. Google spreadsheet works the same as excel and you can do most of the important spreadsheet tasks with it. To select a row or column click on the number rows or letter columns of the row or column you want to select this will highlight the whole row or column blue to indicate you have it selected. Alternatively you may click the grid menu in the upper righthand corner of your screen while on google s homepage your gmail account or any page with google search results. There are 3 ways to create a new spreadsheet in google sheets.

Google enables you to use many of its other programs within sheets. So i recommend you process your data to a table like structure. The document will automatically be converted to the excel format. Sheets should step 2 open a new spreadsheet. Once the excel file uploads sheets automatically converts and opens it ready for you to start to edit share and collaborate.

How to use google sheets. Go to your google sheet containing the data you want to export. You can use google spreadsheet directly from your web browser or from its mobile app. If you re looking at the document in google drive take the following steps. Click the red new button on your your google drive dashboard and select google sheets open the menu from within a spreadsheet and select file new spreadsheet click blank or select a template on the google sheets homepage.

From the google sheets homepage click the folder icon in the top right click the upload tab then drag an excel file over from your computer. This can be anything you like but it will be exported to excel in a table database format. By using formulas like googletranslate or googlefinance you can take advantage of the numerous other free products that google offers without even having to leave the spreadsheet. Method 1 making a spreadsheet with google sheets. Choose where to save it.