Google-sheets – How to scroll horizontally by more than one column at a time

google sheets

I have made a weekly planner: on the left is a frozen column with a list of times and then four-column blocks to represent each day. The first of every four columns has a date at the top.

I would like to be able to scroll (left and right) from day to day (date to date) rather than column by column.

Is this possible?

Best Answer

Sound like a rare instance where merging cells might be useful, for example merge horizontally each successive four cells in a row (a header perhaps) and tabbing across that row will jump four columns at a time.

Related Solutions

Google-sheets – How to make Google Sheets tell me how many of each date are in a column

You can reproduce the required table using a formula (this will only work on the newest version of Sheets):

=QUERY({A:A,A:A},"select Col1, count(Col2) where Col1 is not null group by Col1 label Col1 'Date', count(Col2) 'Number'",0)

And then reference that output for your graph.

If you are on the old version:

=ArrayFormula(QUERY(IF({1,1},A:A),"select Col1, count(Col2) where Col1 is not null group by Col1 label Col1 'Date', count(Col2) 'Number'",0))

Google-sheets – How to count numbers in nearby cell with criteria in Google Sheets

You may want to give the query() function a try. Assuming your data is in the range A1:D, try:

=query(A1:B; "select A, sum(B) where A <>'' group by A"; 1)

Note: depending on your locale you may have to change the semi-colons with comma's..

This is a one formula solution that will update when new rows are added. I hope that helps ?

Best Answer

Related Solutions

Google-sheets – How to make Google Sheets tell me how many of each date are in a column

Google-sheets – How to count numbers in nearby cell with criteria in Google Sheets

Related Topic