138

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


44

Use the following short cuts. Shotcuts Ctrl + Shift + PageDown ==> Move to next sheet (Option + Down arrow on a Mac) Ctrl + Shift + PageUp ==> Move to previous sheet (Option + Up arrow on a Mac) Screenshot Reference Keyboard Accelerators


43

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


39

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


30

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


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


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


18

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


16

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


15

Ctrl+Shift+7 for a numbered list Ctrl+Shift+8 for a bulleted list It's the same as in Google Docs.


15

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


14

Try Control+Shift+\ Works in Google Chrome for me. I found this at https://sites.google.com/a/umich.edu/going-google/accessibility/google-documents-keyboard-shortcuts---mac


13

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

I will assume you're not using Chrome, which is why my answer is relevant. Check out this article on copy/pasting in Google Drive documents: When working in Chrome, you can use the right-click menu to copy and paste content (or select "Copy" or "Paste" from the Edit menu in the toolbar). When using the right-click-context menu in Drive, the stuff you ...


13

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


13

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.


11

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.


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

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.


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

Currently the feature you want is not implemented. The only way to prioritise cards without drag and drop is moving all cards out of the list and move card with the highest priority first back to the list.


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

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


10

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.


9

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


9

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.


9

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


8

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


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