I would like apply cell formatting to all cells except first one. I need this because first line contains description. How to achieve that?

  • Have you tried to select the cells that you want to apply the format, and apply it to them? If that isn't what are you looking for describe what you are looking for. May 11, 2017 at 2:32
  • I suppose I can't select all cells without pressing column label. But this will select all cells. But I need all_cells - first_one.
    – vico
    May 11, 2017 at 7:14
  • Check the Google Sheets keyboard shortcuts. May 11, 2017 at 14:16
  • Ctrl-A to select all cells, then Ctrl-click to de-select the one cell you don't want formatted. Does this not work for you?
    – ale
    May 24, 2017 at 14:13

2 Answers 2


It seems the easiest way is to click the cell in second row, then scroll to the bottom of the sheet (using the scrollbar on the right) and Shift-click the cell in the last row.

To select all cells in the sheet, except for the first row, proceed similarly but clicking the row numbers instead: Click Row 2 -> Scroll to the bottom -> Shift-click last row.


A2:{ColumnLetter}(omit row number)

This will select row A2 and everything underneath it until the specified column. To be more specific, this syntax can be used to create a box, where the top left corner is the first index, with a width that goes until the second index (the column letter w/o a number). This box will go all the way to the bottom of the sheet.


  • A2:E
  • A2:Z
  • A10:J
  • K6:M

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.