+4 votes
67 views
Learn how to use Google Sheets with these basic tips

in Help by (551k points)
reopened | 67 views

1 Answer

+5 votes
Best answer

How to use Google Sheets from the browser itself
Full text grouped in one cell
How to sum values ​​in columns or rows
Most used key combinations
How to color cells

Index

image

Using Google Sheets is simple, although, as with any other spreadsheet, you need to know at least a few basic and easy-to-use tricks. In this article we will show you some of the most useful..

Index

How to use Google Sheets from the browser itself
Full text grouped in a cell
How to add values ​​in columns or rows
Most used key combinations
How to color cells

How to use Google Sheets from the browser itself

The most basic: how to create our first spreadsheet in Google Sheets. This is very simple. All we have to do is enter the sheets.new web page and a new sheet will automatically open and be synchronized with our Google Drive account.

Full text grouped in one cell

Sometimes, we have to place some concept that goes beyond the size of the cell and this is somewhat inconvenient. In order for the text to wrap, we have to select the cells in which we want to apply it, then go to the top bar and select the icon of the little arrow that curves , as shown in the image.

image

How to sum values ​​in columns or rows

This is a very simple operation. To do it, we just have to select the cells we want with the mouse, go to the top bar and choose the icon that appears in this screenshot. Then, we will go to the desired mathematical operation , in this case, the addition..

image

The result of the operation will be reflected in the immediately subsequent cell. With the rows, the procedure is the same: we select the ones we want, and when clicking on the corresponding icon, the result will be displayed in the cell immediately to the right.

image

Most used key combinations

These are the most used keyboard shortcuts in Google spreadsheets

  • Select column: Ctrl + Space
  • Select Row: Shift + Spacebar
  • Select all: Ctrl + a
  • Undo: Ctrl + z
  • Redo: Ctrl + y
  • Find: Ctrl + f
  • Find and replace: Ctrl + h
  • Fill the gap: Ctrl + Enter
  • Fill Down: Ctrl + d
  • Fill Right: Ctrl + r
  • Save: Ctrl + s
  • Open: Ctrl + o
  • Print: Ctrl + p
  • Copy: Ctrl + c
  • Paste: Ctrl + v
  • Paste only the values: Ctrl + Shift + v
  • Show common keyboard shortcuts: Ctrl + /
  • Cut: Ctrl + x
  • Insert new sheet: Shift + F11
  • Search in menus: Alt + /
  • Hide controls: Ctrl + Shift + f
  • Turn text input tools on or off: Ctrl + Shift + k
  • Select text input tools: Ctrl + Alt + Shift + k

How to color cells

Filling cells with color will help us assign categories to different values. To do this, we just have to select the paint bucket from the toolbar and choose the color we want. If we want to remove the color, we just have to click on Reset and it will stay blank again..

image

 


by (3.5m points)

Related questions

+3 votes
1 answer
+3 votes
1 answer
+4 votes
1 answer
asked Nov 8, 2021 in Help by backtothefuture (551k points) | 71 views
+3 votes
1 answer
asked Nov 20, 2021 in Guides by backtothefuture (551k points) | 79 views
+4 votes
1 answer
asked Nov 25, 2020 in Help by backtothefuture (551k points) | 199 views
Sponsored articles cost $40 per post. You can contact us via Feedback
10,632 questions
10,764 answers
510 comments
3 users