We changed our privacy policy. Read more.
197

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 ...


47

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(...


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

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.


26

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 ...


24

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: ...


20

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.


19

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.


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

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


15

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


14

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.


12

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


12

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, ...


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.


12

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.


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.


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 ...


10

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.


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

A quick keyboard substitute for "Send and Archive" -- as noted by Paul Anderson on this Google+ page -- would be to press TAB and then ENTER (or SPACE). As long as the "Send and Archive" button is enabled (Settings > General > Send and Archive) TAB will shift focus to the button and ENTER or SPACE will select it.


7

The Shortcusts for Trello Chrome Extension lets you move cards to the top. It's open source and there is a GitHub Issue on it to add shortcut for Card Move Up/Down. (Any JS developers willing to pull this one off?)


7

While not a simple shortcut, there are several ways to achieve fullscreen play without a mouse: Visit https://youtube.com/html5 and opt-in to the experiment. After that most (but not all) youtube videos will use the native <video> tag instead of Flash, with a slightly different UI. The fullscreen control is reachable in this UI by pressing (quite a ...


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