For instance when I'm working in a large spreadsheet with many columns I like to hide specific columns to allow me to present or focus in on a set of data, this often means hiding columns eg. C:C, F:H, P:S, Z:AC. When I need to view everything again I manually turn the columns back on, but when I want to hide them again after I need to hide them all manually.

Is there a simple way to be able to save a "view" that will capture how my spreadsheet is currently using hidden rows, columns and filters and allow me to toggle it on / off as required?



That is not a built-in function. Use google-apps-script or an add-on. – Rubén Mar 6 at 11:34

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.