1

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

migrated from superuser.com May 10 '17 at 23:11

This question came from our site for computer enthusiasts and power users.

  • 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. – Rubén May 11 '17 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 '17 at 7:14
  • Check the Google Sheets keyboard shortcuts. – Rubén May 11 '17 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 '17 at 14:13
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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