Hi,
Normally on excel I can press ctrl+g and it will look for all blank cells and I can insert cells.
Is there a way to do the same but instead of looking for blanks, I want to search for a keyword such as average and then insert 3 cells in front of it.
I tried the filter option but I couldn't insert cell, only rows and columns is allowed.
Is there a formula or script for this?
Thanks!
Normally on excel I can press ctrl+g and it will look for all blank cells and I can insert cells.
Is there a way to do the same but instead of looking for blanks, I want to search for a keyword such as average and then insert 3 cells in front of it.
I tried the filter option but I couldn't insert cell, only rows and columns is allowed.
Is there a formula or script for this?
Thanks!
Last edited: