PDA

View Full Version : Excel TIPS of daily use...


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

MOST WANTED
04-10-2007, 04:22 PM
KIYAWANNA BAAA MACHAN MECHHARA

MOST WANTED
04-10-2007, 04:22 PM
very lassy

nadeeraroshan
04-10-2007, 04:23 PM
:rolleyes: :rolleyes:

dj100
04-10-2007, 04:23 PM
Car Wash 2007
Hi Guys !

The Interact Club Of D.S.Senanaayake College (ICDS) Is Supposed To Do A Project Named " CAR WASH 2007 " So Guys Give Us A Great Support

Venue : Near BRC Grounds,HavlockTown
Time : 9.00 am Onwards
Date : 22 nd Of April


<<<<<<<<<<<<<<<<<Hey Guys>>>>>>>>>>>>>>>
For More Details Call Me On 0785-360863
Or Send Me PM's ok................................................ .................

I think ElaKiri will give us a great Support !

milindayu
04-10-2007, 04:34 PM
KIYAWANNA BAAA MACHAN MECHHARA

Okkoma kiyawanna epa macho....one by one try karapan.....:yes: :yes: :yes: :yes:

Anupa
04-10-2007, 04:39 PM
matath ba mechchara kiyawanna,,,,,,,,,,,,,,,,,,

milindayu
04-10-2007, 04:41 PM
matath ba mechchara kiyawanna,,,,,,,,,,,,,,,,,,

:angry: :angry: :angry: :angry: :angry: :angry: ;)

GNS
04-14-2007, 05:58 AM
WoW... These would be Gr8 4 Me...:yes::yes: