-
Shortcut : Select all data on a sheet
Hi, I wanted to share a shortcut how to select all data in a sheet (in order to delete or format all the data) Select top row in sheet, Press Shift, Ctrl and down arrow5 · -
Re: Lock single cell
In my particular case, I had put defaults in my Navigation and Summary headers so that Sorting the columns would still keep the Navigation section in place. (I had formatted the defaults to be unseen…3 · -
Re: Update Column Formula with Control Center
Hey @Automations 1 / @Andrée Starå ! See this link below – if you use ‘Modify Existing Column’ the global update does change the column formula! Global Updates Support for Column Formulas with Contro…1 · -
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea110 · -
Re: If/Then Logic - Based on What Letter a Name Starts With
Thanks @Genevieve P. , That would work but then I would have to hard code the whole ABC. I ended up using a match formula to reference another sheet where I had the ABC running down one column and re…1 ·