That’s where these handy shortcuts come in. Menu before pressing Ctrl + Shift + F: Menu after pressing Ctrl + Shift + F: Now this search box is pretty awesome because I can just type 'Courier New' and hit Enter. That’s why it’s easier to make small adjustments like typos and missing commas directly using editing mode. There is the Ctrl + Shift + F keyboard shortcut to collaps the menu bar, which then displays the Search the menus (Alt+/) search box. Tool finder (formerly search the menus), press Alt + / (Windows, Chrome OS) or Option. The only downside to suggesting mode is that when a file has to undergo major surgery, it can look a bit messy. To see a list of keyboard shortcuts in Google Sheets, press Ctrl + / (Windows, Chrome OS) or + / (Mac). The platform assigns different colors to different users-so you know who did what-and every change is accompanied by its own sidebar comment detailing what was there, and how it is now different. Pieces of text you remove will appear with a line through them, while the text you add will be underlined. Let’s get started getting Google Sheets to drag down numbers. Fill Down is an autofill Google Sheets setting you can apply to a column (or row) based on the pre-existing pattern. One such functionality is Google Sheets Fill Down. + Option + (with rows selected)Ctrl + Option + i, then r. Google Sheets has some great shortcuts that can help you get the work done a lot faster (and more accurately). Ctrl + Alt + Shift + Ctrl + Alt + (with rows selected)Google Chrome: Alt + i, then rOther browsers: Alt + Shift + i, then r. Suggesting mode, on the other hand, marks everything you do so other people know exactly what you did. Google Sheets shortcuts for adding or changing rows and columns. You can, however, see these alterations in the document’s version history. Once you’re done, there are no traces of where you made your edits, so it always looks like a final version.

Editing mode allows you to make changes straight into a document.

Changing google sheets shortcuts