excel and worksheets...

[askaboutexcel]

what keys are pressed to move the highlight to the last cell of the work sheet that has data??

also,
what cell format displays numerical data preceded by a dollar sign?

this is for some work at school but i cant find an answer...
THXS

 

[Atom]

To move to the last cell in a sheet hit ctrl and end, ctrl home will take you to the first cell in your sheet.

To select how you would like your currency to be displayed you can select that under format and then cells.