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.