Excel Tip of the Day
Keep focus on the current cell (Excel 97/2000/2001/2002)
By default, Excel moves the cell selector down one row when you press [Enter] after making an entry. However, you may prefer that the cell in which you're entering data remain active, so that you can easily format it. If you want, you can completely disable the behavior. To do so, choose Tools | Options from the menu bar. Then, click on the Edit tab, clear the Move Selection After Enter check box, and click OK. However, if you don't want to permanently change the way Excel handles the [Enter] key, you don't have to. Simply press [Ctrl][Enter] after completing an entry. Excel will save your entry, but the focus remains on the current cell instead of moving to the one beneath.
(Content provided by Element K Journals)
(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
Print
CloseCopyright © 2001 - 2024 MJ Technologies, LLC. All rights reserved.