View Single Post
 
Old 03-19-2013, 07:16 PM
dylansmith dylansmith is offline Windows 8 Office 2013
Optimizer
 
Join Date: Nov 2011
Posts: 144
dylansmith is on a distinguished road
Default how to keep rows highlighted when scrolling down and how to move columns?


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!
Reply With Quote