- To enter data without pressing the arrow keys, enable the After Pressing Enter, Move
Selection option on the Advanced tab of the Excel Options dialog box (which you access from the Office➜Excel Options command). You can also choose the direction that you want to go. - To enter the same data in all cells within a range, select the range, enter the information into the active cell, and then press Ctrl+Enter.
- To fill a range with increments of a single value, press Ctrl while you drag the fill handle at the lower-right corner of the cell.
- To create a custom Auto Fill list, select the Edit Custom Lists button on the Popular tab of the Excel Options dialog box.
- To copy a cell without incrementing, drag the fill handle at the lower-right corner of the selection; or, press Ctrl+D to copy down.
- To automatically format a cell with the currency format, type your currency symbol before the value.
- To enter a value in percent format, type a percent sign after the value.
- To insert the current date, press Ctrl+; (semicolon). To enter the current time into a cell,press Ctrl+Shift+;.
Keep Learning and do Share
Sanjay Bakshi
mesanjaybakshi@gmail.com
No comments:
Post a Comment