how to keep rows highlighted when scrolling down and how to move columns?

[dylansmith]

with regards to the image above, i'd like to ask if there's any keyboard shortcut that allows me to go down line by line and keep the grey box highlighted (if i press down arrow, it will remove the highlight. if i press page down, the highlighted box does not move to the next row).


1b) How do i keep the row highlighted if i'm working side by side with another document? e.g. acrobat/ms word is in focus on the left, excel inactive on the right

second question :



how do i insert row 11 into row 7 without replacing row 7 itself?

third question :


how do i make this into a table AND retain my original formatting (colours/bold font etc)? i just need to make the headers into a workable format (i.e. able to sort by column).

thanks!

[Pecoflyer]

Is this question some kind of homework?

[dylansmith]

Originally Posted by Pecoflyer

Is this question some kind of homework?

sorry, i can't help but feel insulted by your guess.

i know the questions are dead simple for an expert like you, but it isn't for me.

the answers to these questions are difficult to find because it's hard to describe without an accompanying image, not because i'm lazy and want people to help me answer it.

and of course last but not least, it's not homework. for example, the first question is clearly aimed at productivity - i'm always comparing data and writing reports at the same time, hence i just want to know if there's a way i can keep things highlighted for ease of use. Things like these are too trivial to be taught in an excel course.

[Pecoflyer]

Sorry that you feel that way, no disrespect was intended.