Get instant live expert help on I need help with excel goto cell

i need a formula to goto cell H1 if A1 is 2

I have the top 15 rows on one page of an Excel workbook that seem permanently hidden. It's not a "freezepane" issue, as I can freeze and unfreeze the pane at other places on the sheet without displaying those top 15 rows. Normally, you can "goto" a cell in a hidden top row, and then unhide the row once you get there. When I use the goto function, however, it doesn't actually take me where I'm looking to go. The liitle box in the upper left below the toolbar shows me I'm at the cell I tried to goto, but I'm not actually there (my cursor). When I try to "unhide" I can't do it, because I'm not actually there.

I'm using my MacBook Air for Excel, the computer was made in early 2015. I need to do a data analysis with excel and all that shows up when I put goto Add Ins all that is shown is Solver.Xlam, and I click it and it doesn't do anything.

i am trying to insert my average figure in all my empty cells for the variable how do i do this. i have used the goto special and selected blank, but when i select the value i want it just fill the active cell and not the other blanks

I am trying to get a macro to go to a named range. The range name is in listed in a cell. When, in the macro, I copy that cell into the goto box it goes there. However the next time I run the macro it uses the last name I copied and not the one that is in the cell.