Reply to thread

Message: <blockquote data-quote="milindayu" data-source="post: 427913" data-attributes="member: 4467">SUM Formula, QuickHold 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 CellsYou 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 CellsWhen 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 WidthsWhen 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 WidthsWhen 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 CellWith 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 keyboardJust Hold down the Shift key and Press F3</blockquote>

Verification: Hath warak paha keeyada? (hatha wadikireema paha)

Top Bottom