To add a link, simply press ⌘ + K or Ctrl + K and paste the hyperlink. 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. Insert Date and TimeĪdding date and time is one of the most used actions and you need to know the correct Google Sheets keyboard shortcut for it. Press ⌘ + Shift + L or Ctrl + Shift + L for left, press ⌘ + Shift + R or Ctrl + Shift + R for right, and press ⌘ + Shift + e or Ctrl + Shift + e for center alignment. You can align the cells in three ways: left, right, or center. To make your data look consistent on the sheet, it’s a good practice to align the cells. You can remove the borders by pressing Option + Shift + 6 or Alt + Shift + 6 keyboard shortcut. To add the border on all four sides, simply press ⌘ + Shift + 7 or Ctrl + Shift + 7. As every cell has four sides, you get the ability to add borders to each side or all at once. Apply Bordersĭistinguishing data on a huge sheet can be a little challenging and that’s you have the option to add borders to make the cells stand out. When pasting the data, instead of pressing ⌘ + V, press ⌘ + Shift + V or Ctrl +Shift + V to paste without any formatting. 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.

Google sheets shortcuts insert row