excel and worksheets...

askaboutexcel

New Member
Joined
Nov 14, 2005
Messages
4
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
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Atom

New Member
Joined
Nov 11, 2005
Messages
30
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,458
Members
412,595
Latest member
slim313
Top