178

From https://support.google.com/docs/answer/6325535?hl=en : Open a spreadsheet in Google Sheets. Paste the data you want to split into columns. In the bottom right corner of your data, click the Paste icon. Click Split text to columns. Your data will split into different columns. To change the delimiter, in the separator box, click PS: There is no option ...


46

While it's not directly possible in the current version with its own keystroke, there is another very simple way to accomplish this. First, be located in the row on which you want to insert a row above or below. Then do the following (keys are on Mac, so translate as necessary for your OS): Ctrl + Option + I - invokes the Insert menu Then hit the R key ...


43

Yup, you can! Shift+N is next video in playlist and Shift+P is the previous one!


42

You are able to paste CSV data as is into the spreadsheet and go to Data selecting Split text to columns... and even further specifying the delimiter: Also, you can simply use keyboard shortcut combo: LEFT ALT + D + E And as already mentioned SPLIT formula: =SPLIT("l,f,x,a,s,f"; ",") =SPLIT(A1; ",") For a range/array it would be: =ARRAYFORMULA(IFERROR(...


40

Chrome (Windows, Linux): ALT+I, then R IE & Firefox (Windows, Linux): ALT+SHIFT+I, then R Mac: CTRL+OPTION+I, then R This will add a row above. Instead of R you can use... W to add row below C to add column to the left G to add column to the right


28

Wow, a year later I had this issue again. Finally realized that the issue was Vimium—once I disabled it on docs.google.com everything was fine. Seems kind of obvious, but for some reason I had figured that wasn't it. I guess I was unconsciously assuming I had already disabled Vimium in Google Docs because everything else worked.


25

Update 28.02.2016 They seem to have updated the possible keyboard shortcuts. With the new keyboard shortcuts, it also works now on my keyboard with the German layout. For Windows: For OS X: Source: https://support.google.com/docs/answer/179738?hl=en Original answer I found a workaround. Select a piece of text in the document. Ctrl+Alt+H opens the Help ...


21

You can just press the Enter key and it should start editing your current cell.


20

~ - move to previous tab (left, looping to far right) ` - move to next tab (right, looping to far left) In a complete accident, I found one of the shortcuts while typing up the question and taking screenshots. I tried to switch Chrome windows with Cmd+` (Mac), but dropped off Cmd too soon. The flip version, was a quick matter of trial and error. Edit: ...


17

The keyboard shortcut to skip the ad at the beginning of a video is Tab and then Enter. There is no keyboard shortcut to skip ads in the middle of the video. Other things to try Get an Ad Blocker (This will hide all ads but it won't give the website owner or youtuber any money.) Install Greasemonkey for Firefox/Tampermonkey for Chrome and then install the "...


16

There doesn't seem to be a native shortcut, but you can use Alt+O, M, and then Enter to select "Merge All" quickly from the dropdown menu.


16

Pressing Tab when the cursor is at the rightmost of the bottom row automatically adds a new row below it. It's quite handy if you don't know how many rows you need in advance and require them as you type along.


15

The new version of Google Sheets makes it very simple: hit the Enter key while you're in the cell. Boom. Dropdown list.


15

cmd + c then, cmd + alt + v works for me on a Mac. Ctrl + C then, Ctrl + Alt + V works on Windows


14

I created a little script that converts the string literal "_now" to current datetime - function onEdit(e) { if (e.range.getValue() == "_now") { e.range.setValue(new Date()); } } I find it pretty handy to type _now and have it convert to current datetime value. See https://developers.google.com/apps-script/quickstart/macros and https://developers....


13

You can open the first link populated by Google search by pressing: tab enter enter After pressing the tab key, a dialog box appears saying "Skip to main content" Additionally, after pressing tab enter : ctrl+enter opens the search result in a new tab. shift+enter opens the search result in a new browser window.


13

I eventually tested on a 3rd Mac and it worked. It turns out it was a Chrome extension using that same shortcut on my 2 Macs. I don't know why Incognito mode didn't solve this. You can see the keyboard shortcuts claimed by your extensions here: chrome://extensions/shortcuts


12

There isn't one. If the cell is blank, just start typing. If the cell has content, press F2 and you'll be able to edit. (Microsoft Excel is the same.) I'm afraid if you want to get into the formula bar you'll need to use the mouse.


11

Not sure exactly what your use case is, but if your goal is to quickly apply a font repeatedly, the easiest way is to first select a block of text with the font you want, hit Command+Option+C to copy formatting, then each time you select the text you want to apply the font to, just hit Command+Option+V to paste formatting. Note: Doesn't work the first time, ...


11

There's no a specific shortcut, however, while composing the body of the email, hit Tab three times. (The first hit moves you to the SEND button, the second one moves you to the Schedule Send arrow, and the third one takes you to the clip icon for attachments.) Bam! Now you're able to paste the path for your attachment.


11

Use @Pikachu's solution (Alt+O,M,Enter) for the first one then use Ctrl+Y (Edit - Redo) for the rest. This assumes you're doing them one after the other, as I am.


10

You can select multiple cells, type in your value, then hit Ctrl-D to fill down, or Ctrl-R to fill right.


10

As per comments, once you enabled Keyboard shortcuts on in mail > Settings, you can use ; for "expand entire conversation" and : for "collapse entire conversation". This and more shortcuts: https://support.google.com/mail/answer/6594?hl=en Original: There is a "custom keyboard shortcut" feature you can enable in labs through ...


10

I've been able to resolve this issue by enabling Gmail's "Undo Send" feature. CMD + Enter still triggers sending, but I now have a 10-second window to catch it before it is actually sent. Send or unsend Gmail messages On your computer, open Gmail. In the top right, click Settings . Click Settings. In the "Undo Send" section, check the box next to "Enable ...


10

The shortcut that does exactly what is asked for here is 'u', which Google labels "return to thread list," which is what it does if you're in a conversation view (i.e. a single email thread). However, if you're already looking at a list of threads (e.g. your inbox), 'u' will refresh that list. Unlike "g, i", 'u' works to refresh any thread list you're ...


8

"Is there any shortcut to move to the last row where data is entered?" Ctrl + down arrow


8

Here's some: f: fullscreen/normal j: backward k: play/pause l: forward


8

If you don't want to change your settings (as @buddha suggests), you can also use the other shortcut (type '?' in Gmail to see this): } : Archive conversation and go to previous { : Archive conversation and go to next From Keyboard shortcuts for Gmail


8

Here are the steps: Press Alt + / Type the color (eg. blue, red etc) Hit Enter Alt + / is like a command palette for all available commands. It's in Help menu.


Only top voted, non community-wiki answers of a minimum length are eligible