excel.advanced.course - returnenter

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Return/Enter

excel.advanced.course - Return/Enter

resolvedResolved · Low Priority · Version Standard

Jen has attended:
Excel VBA Intro Intermediate course

Return/Enter

How can you change it so that when you hit return/enter in an excel sheet it moves across (across columns) istead of down (down rows)

RE: Return/Enter

Hi Jen

You can do this by going to Tools-Options, and then selecting the edit tab.

Here there is a drop down that lets you choose which cell is selected after you press enter

RE: Return/Enter

Thanks Stephen,

That's great


 

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips


Server loaded in 0.09 secs.