Three tasks under editing a worksheet:
Answers
Answer:
A Fast Find-Next
Tired of the Find and Replace dialog box blocking the view of your worksheet when you are searching for information? Do what I do and get rid of the dialog box. Use the technique described in this tip to do your searching.
Adjusting a Range's Starting Point
Select a range of cells, and one of those cells will always be the starting point for the range. This tip explains how to change the starting point for a range without getting rid of the range itself.
Adjusting Formulas when Pasting
The Paste Special feature in Excel can be used to uniformly adjust values and formulas. This tip shows how powerful this feature can be.
Automatically Breaking Text
Want to convert the text in a cell so that it wraps after every word? You could edit the cell and press Alt+Enter after each word, but there's an easier way using a formula.
Automatically Moving from Cell to Cell when Entering Data
As you enter data in a worksheet, you may want to have Excel automatically move from cell to cell based on the length of what you are entering. This is not as easy to do as you might at first think, but there are ways to accomplish the task.