milindayu
04-10-2007, 04:12 PM
SUM Formula, Quick
Hold down the [Alt] while you type the equal sign. Excel will automatically write a SUM formula for the cells above or to the left.
Zooming Only Selected Cells
You can Zoom only selected cells rather than the whole sheet if you use the Selection option with the Zoom. This option allows you to select the cells you want to zoom in on (this option won't reduce a range) and chooses just the right percentage to see the selection as large as possible.
Simply select the range you want to enlarge and then either choose Selection from the Zoom drop down or choose View | Zoom | Fit Selection.
When you're done, select 100% (or the appropriate percentage) from the Zoom control in the Toolbar or choose Edit, Undo Zoom or press Ctrl-Z.
Selecting Only Visible Cells
When you've filtered data or hidden rows or columns, selecting a block of cells will also, disappointingly, select the cells that are not visible. There is a hidden command that will let you select only the visible cells. It's hidden in that you have to add this command to your toolbar in order to use it.
1. Right-click in the gray area of the toolbar to the right of Help
2. Choose Customize
3. Go to the Commands tab
4. Choose the Edit category
5. Scroll all the way to the bottom of the list of Edit Commands
6. You should find the Select Visible Cells command
7. Click and drag this command and drop it where you want it to appear on a toolbar.
Now anytime you have cells hidden, you can click the Select Visible Cells icon to select all the currently visible cells WITHOUT selecting those cells you can't see.
Pasting Column Widths
When you Copy and Paste cells in Excel (Ctrl-C, Ctrl-V) you can't automatically paste in the column widths that accommodate that data. But, you can paste in the column width by using Paste Special. After using a normal Paste to paste in the data and cell formats, right-click the new range of data you just pasted, choose Paste Special, and select the Column Widths radio button.
Pasting Column Widths
When you Copy and Paste cells in Excel (Ctrl-C, Ctrl-V) you can't automatically paste in the column widths that accommodate that data. But, you can paste in the column width by using Paste Special. After using a normal Paste to paste in the data and cell formats, right-click the new range of data you just pasted, choose Paste Special, and select the Column Widths radio button.
Line Break Within a Cell
With text wrap formatting set in a cell (Format | Cells | Alignment | check Wrap Text), sometimes you want to force a line break at a certain point. Use Alt-Enter
Calling EXCEL Functions using keyboard
Just Hold down the Shift key and Press F3
Hold down the [Alt] while you type the equal sign. Excel will automatically write a SUM formula for the cells above or to the left.
Zooming Only Selected Cells
You can Zoom only selected cells rather than the whole sheet if you use the Selection option with the Zoom. This option allows you to select the cells you want to zoom in on (this option won't reduce a range) and chooses just the right percentage to see the selection as large as possible.
Simply select the range you want to enlarge and then either choose Selection from the Zoom drop down or choose View | Zoom | Fit Selection.
When you're done, select 100% (or the appropriate percentage) from the Zoom control in the Toolbar or choose Edit, Undo Zoom or press Ctrl-Z.
Selecting Only Visible Cells
When you've filtered data or hidden rows or columns, selecting a block of cells will also, disappointingly, select the cells that are not visible. There is a hidden command that will let you select only the visible cells. It's hidden in that you have to add this command to your toolbar in order to use it.
1. Right-click in the gray area of the toolbar to the right of Help
2. Choose Customize
3. Go to the Commands tab
4. Choose the Edit category
5. Scroll all the way to the bottom of the list of Edit Commands
6. You should find the Select Visible Cells command
7. Click and drag this command and drop it where you want it to appear on a toolbar.
Now anytime you have cells hidden, you can click the Select Visible Cells icon to select all the currently visible cells WITHOUT selecting those cells you can't see.
Pasting Column Widths
When you Copy and Paste cells in Excel (Ctrl-C, Ctrl-V) you can't automatically paste in the column widths that accommodate that data. But, you can paste in the column width by using Paste Special. After using a normal Paste to paste in the data and cell formats, right-click the new range of data you just pasted, choose Paste Special, and select the Column Widths radio button.
Pasting Column Widths
When you Copy and Paste cells in Excel (Ctrl-C, Ctrl-V) you can't automatically paste in the column widths that accommodate that data. But, you can paste in the column width by using Paste Special. After using a normal Paste to paste in the data and cell formats, right-click the new range of data you just pasted, choose Paste Special, and select the Column Widths radio button.
Line Break Within a Cell
With text wrap formatting set in a cell (Format | Cells | Alignment | check Wrap Text), sometimes you want to force a line break at a certain point. Use Alt-Enter
Calling EXCEL Functions using keyboard
Just Hold down the Shift key and Press F3