If you click on the column indicator in Google Sheets it will highlight the entire column. Paste special will paste the values and get rid of the formulas. Instead, when pasting values that were created from formulas, use Control Shift V to paste special. Copying and pasting the column onto another sheet will not produce a list of the names as intended. The problem is, that list is formulas not values. Then I fill down to make the entire list of names concatenated. I use =A1&B1 to concatenate the first and last name together. Let’s say I have first name in column A and last name in column B. Pasting special is something I use every day. How many times have you copied something and when you pasted it into the spreadsheet it is funky? Use Control Z to undo that and then use Control SHIFT V to try again. Ctrl + Shift + V: Paste specialĬontrol SHIFT V is a lifesaver for pasting. It will even overwrite things in the highlighted cells. Now use Control R to force all of the cells to the right to take on that formula or value. HIGHLIGHT to the right the cells you want to copy to. So if you want to refresh your Google Sheet you can’t use the traditional Control R. Now in every other application, Control R is refresh. It is not uncommon that I work left to right in a spreadsheet and not just top to bottom. Instead, if you highlight a vertical range of cells and use Control D it will fill in, and even overwrite, the cells that were highlighted with the value. IF the column next to it has a blank cell… say cell C17, but there is text in C18, the fill down will fill to row 17. So if you have 30 rows of data and then use Control D to fill DOWN (not up) then it will match just those 30 rows. Normally when you double click on the fill down square it matches the values to the column next to it. I mean seriously, that fill down square is SMALL! How far does the spreadsheet fill down? Now use Control D to fill down instead of trying to clumsily grab the fill down square in the bottom right corner of the cell. This way I can toggle between the two and decide which way I like it better. Ctrl + Y: Redo last actionĭid I like the change I just made? Control Z to undo what I just did and Control Y to put it back. You can also right click on a cell to choose “cell history.” Cell history won’t allow you to roll that cell backwards, but you can see what the previous value was and manually restore it if you so desire. You can however, use version history to roll the entire spreadsheet back to a previous version. If you closed the spreadsheet, you can not use Control Z to undo past mistakes. It’s just too easy to accidentally lean on the keyboard and delete entire portions of your spreadsheet.Ĭontrol Z only works if you catch the mistake while you’re still editing in the same session. Using Google Sheets, especially with a trackpad, makes Control Z a necessity. If I didn’t catch that I was making a mistake WHILE I was making the mistake, no worries. Pressing the Esc key will cancel what I am doing and put it back the way it was. Or some other thing I did not mean to do. Escape Key: Cancel what I am doingīEFORE I press enter I might realize… oops, wrong cell. I select all and then apply word wrap to the entire spreadsheet. Spreadsheet keyboard shortcuts mug from my friend Linda. When you use Control V to paste into say cell F56 then what it will add is not A1 and B1 but rather D56 + E56. This says to take the cell 2 to the left and add it to the cell one to the left. This is because it does not just copy the cell…. Ctrl + C: Copy selected cellsĬontrol C is hugely important for ANY application, but in particular it is important in Google Sheets. Here are 20 important keyboard shortcuts for Google Sheets 10 Important Keyboard Shortcuts for Google Sheets 1. This can be especially helpful if you have a lot of tasks to complete in a short period of time.Using keyboard shortcuts can help you stay focused and minimize distractions, since you don’t need to move your hand away from the keyboard to use a mouse. Streamline your workflow, allowing you to get more done in less time. This can save you time and effort in the long run. Keyboard shortcuts can be easier to remember than mouse-based commands, especially if you use them frequently. Using them can help reduce the risk of carpal tunnel syndrome and other repetitive strain injuries that can be caused by excessive mouse use. This can be especially helpful if you need to do a lot of formatting or data entry. Keyboard shortcuts allow you to perform tasks more quickly than using a mouse or trackpad. Using keyboard shortcuts can help teachers save time and be more efficient when using Google Sheets.
0 Comments
Leave a Reply. |