Category: Tools

Your website data is still vulnerable despite having the utmost security practices. There are chances where you can get a major data loss caused by hackers, human error, and various other reasons. Of course, you can’t afford to lose those valuable data and make your business going chaotic. Therefore, it’s important to do a prevention […]

In the updated version of Google Sheets, you can now publish an individual spreadsheet to the web. How to publish spreadsheets to the web? You will see these thumbnails right along the top to start a new spreadsheet. You can either create a new blank spreadsheet right from here or use one of these handy […]

Here are some steps to import the exercise files to Google Sheets: To use the file in Google Sheets, start by downloading the exercise files to your desktop. Next, open Google Sheets at sheets.google.com. You’ll need to login with your Google account. Click the folder icon in the upper right corner of the google sheets home screen. This […]

Google Sheets is an online spreadsheet application. With Google Sheets, you can create, edit, and format spreadsheets, and collaborate on spreadsheets with other people. To access Google Sheets, it’s necessary to sign up for a Google account. You’ll also need to use Google Drive to store and organize your spreadsheet files. Google sheets is free […]

View the Spreadsheets To access the View menu, click the word view in the upper menu above the Google Sheets toolbar. You’ll see a dropdown menu appear with several options listed. The first option is freeze. This refers to freezing rows or freezing columns in your spreadsheet view. Freezing rows and columns are useful if […]

Installing Google Sheets Mobile App First, open your App Store or Google Play Store, search “Google Sheets”, Install it on your device. Second, Sign In with your Google account. After that, you will see all of your spreadsheets you created before and have been shared by you.                      […]

Spreadsheet name Menu bar Basic controls (undo, redo, print, format painter) Zoom Number formatting options Text formatting options Cell formatting options Advanced controls and functions Active cell Formatting Cell, Row, and Column Data  (Use Format on Menu bar, Number Formatting Option, Text Formatting Option, & Cell Formatting Option) For numbers, you can select between a […]

Working with multiple sheets —————————————— Using keyboard shortcuts & code ————————————————– Entering Hyperlinks : First, click the cell where you’d like the link to appear. Now, click the link icon on the toolbar. The link tool will open up. In the text field, type or edit the text you’d like displayed in the cell that […]

Creating, naming, and renaming a spreadsheet  The file spreadsheet title is displayed in the top left of the spreadsheet, above the menu. ——————————————- Copying a spreadsheet  In Google Drive, you have to right-click the google sheets file on a PC, or CTRL+click on a Mac, on the title of the spreadsheet document. From the pop-up […]