The link may not be clickable, so go back into the cell to edit it, place your cursor at the end of the unlinked URL and then press Enter. Use the Alt-Enter trick to make a new line, then paste the link and press Enter. If you want more than one link in the cell, click into the cell to edit it. Pasting another link will usually just paste over the previous one. When you paste a link into a cell, it will automatically become clickable. Put the cursor where you want the row or column to move to and let go of the mouse button. Now you can move the mouse and a cursor will show up. Then click again and hold the click down. Click into the cell of the row number or column number itself, then let go of the click. If you want to easily move a row from one place to another you can drag it with the mouse. In Google Sheets, when you’re in a cell for the row (or column) you want to freeze, choose View, then Freeze and the number of rows or columns you want to freeze. Then, as you scroll through the data, the label row stays at the top so it’s easy to see which columns are which. You can freeze the row that has the labels of columns, for instance. Freezing a row is a good way to make data scannable.Now, just hit Enter to save the text, which will inherit the formatting of the cell it’s being pasted into. If you don’t want this to happen, click into the cell first to edit, then paste the text. If you highlight a cell and paste in text, it will preserve the formatting from where it was copied. Cut and paste with or without formatting.On a Mac, hold down the Control key while pressing Return. If you want to make a line break, hold the Alt key while pressing Enter. If you’re writing a piece of text and press Enter, it just saves it in the cell. So here are my top five Google Sheets shortcuts. Listen to the podcast version of this Top 5 episode on SoundCloud Some of these Google Sheets tips are the same in other programs, like Excel, and I’m sure many of you know several of them, but you may not know all of them – especially if you use Sheets for text and not just numbers. In fact, we use it on the Daily Tech News Show to make our rundowns, and we’ve taken advantage of some tricks to make that faster over the years. Lots more folks are using Google Sheets these days to edit things.