Whether you’re maintaining a list of competitors or creating a resource of websites, you can put hyperlinks in Google Sheets which makes it extremely convenient to open sites. To format your cell data to currency, select all the cells, and press Ctrl+ Shift + 4. You can convert those cells and format the data into currency. Let’s say you’ve added some data to your sheet but the values are just numbers. To add the current date, press ⌘ + or Ctrl +, and to add the current time press ⌘ + Shift + or Ctrl + Shift +. To input them together, press ⌘ + Option + Shift + or Ctrl + Alt + Shift +. Either you can input the date and time at once or you can add date and time separately.
When pasting the data, instead of pressing ⌘ + V, press ⌘ + Shift + V or Ctrl +Shift + V to paste without any formatting.Īdding date and time is one of the most used actions and you need to know the correct Google Sheets keyboard shortcut for it. When copying the data from other sheets, you also get the formatting and this quick shortcut would let you remove the frills and copy just raw data. You can select an entire grid of cells with the usual ⌘ + A or Ctrl + A. Simply press Ctrl + Space to select a column and Shift + Space to select a row. You can, in fact, use a simple keyboard shortcut to quickly select an entire row or column on the sheet. When you’re working with data on Sheets document, it can be tiring to select entire blocks of rows and columns using a mouse. It’s only logical that we cover some of the most important Google Sheets shortcuts for keyboard users. I try to incorporate keyboard shortcuts into my workflow wherever I can, be it Google Docs keyboard shortcuts or macOS keyboard shortcuts. I use it extensively and switching back and forth between keyboard and mouse is really unintuitive.
Google Sheets makes way more sense if you’re not in the Microsoft ecosystem and only use spreadsheets to manage your small business.
0 kommentar(er)
