View Poll Results: Cast ur Votes

Voters
8. You may not vote on this poll
  • Geo

    1 12.50%
  • ~Loving Irfan~

    1 12.50%
  • naz

    0 0%
  • sheem

    3 37.50%
  • chwaqasahmed

    1 12.50%
  • DaNgErOuS tEaRs

    2 25.00%
Results 1 to 8 of 8

Thread: ~ Polling for IT competittion of June 09 ~

  1. #1
    Join Date
    Feb 2008
    Location
    Islamabad, UK
    Posts
    88,507
    Mentioned
    1031 Post(s)
    Tagged
    9706 Thread(s)
    Thanked
    603
    Rep Power
    21474934

    ~ Polling for IT competittion of June 09 ~



    Computer competition mai participate karne ka shukria.
    please now vote for your fav Tip.


    Rules:

    1.Apni Shamil Kiye Gai TIP Ko vote Nahi Cast Karsakte..
    2.Sirf Aik he TIP ko vote diya jasakta hai.
    3.voting ki last date 28 June Hai.




    Geo


    Add Combo Box to a Sheet in Microsoft Excel

    Step 1: Define names
    1.Enter the months list - January-December into the cells A1 to A12 in the new worksheet.
    2.Select cells A!:A12, press Ctrl+F3, enter the text MonthsList into the Names In workbook box,and click OK.
    3.Select Cell B1, press Ctrl+F3, enter the text MonthNumber into the Names in Workbook box, and click OK.


    Step 2: Add a Combo Box to a worksheet
    1. Select one of the toolbars, right-click, and select the Forms toolbar.
    2. Copy the Combo Box by clicking the Combo Box icon, and then release the mouse. Create a rectangle with the mouse in the worksheet, and then release the mouse.

    Step 3: Format the Combo Box


    1.Select the Combo Box; right-click; and from the shortcut menu that appears, select Format Control. Then select the Control tab

    2.In the Input range box, type the name MonthsList (You cannot press F3 to paste a name with an object).
    3.In the Cell link box, type the name MonthNumber.
    4.Click to select the 3-D shading box (more aesthetic).
    5.Click OK.
    Exit the formatting mode of Combo Box, and select a cell in the sheet. Open the list of items in the Combo Box, and select a month. Note that the new month number is shown in cell B1.




    ~Loving Irfan~




    Quickly undo

    Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.




    naz




    Shortcut to Merge Cells


    Excel allows you to merge cells together in two ways: using the Merge and Center tool on the toolbar, or by using the controls in the Alignment tab of the Format Cells dialog box. If you merge cells quite a bit, you might long for a shortcut that will merge whatever cells you've selected.

    Unfortunately, Excel doesn't include such a shortcut. You can, however, create one using a macro. The following is a simple macro to merge whatever cells you've selected:

    Sub MergeCells1()
    Selection.Merge
    End Sub
    After you create the macro, you can assign it to a keyboard shortcut and you are set to go. If you instead want a macro that is a shortcut for the Merge and Center tool, then you can use the following:

    Sub MergeCells2()
    With Selection
    .HorizontalAlignment = xlCenter
    .Merge
    End With
    End Sub



    sheem


    Recording a Data Entry Time


    There are several different ways you can accomplish this task. The first is to manually enter a time by selecting the adjacent cell in column B and pressing Ctrl+Shift+; (that's the semicolon). This shortcut enters the current time in the cell. The problem with this approach, of course, is that it isn't automatic and it takes some extra movement and keystrokes to implement.
    A better approach would be to use a formula to enter the time. The NOW function returns the current date and time, and you can use it in a cell in this manner:
    =NOW()
    Of course, this simple formula is updated every time the worksheet recalculates. That means that the function returns the current time every time you enter a value in column A. This is undesirable because you don't want previous times to update. You could try to use a formula to check to see if something is in column A, as in this manner:
    =IF(A3="","",IF(B3="",NOW(),B3))
    The problem is that a formula like this introduces a circular reference into the worksheet, which presents a whole host of challenges to work with. A better approach is to create a macro that automatically runs every time something is entered in column A. Right-click on the tab of the worksheet used for data entry and choose View Code from the Context menu. You'll see the Code window for the worksheet in the Visual Basic Editor, and then enter this into the window:
    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    Dim rCell As Range
    Dim rChange As Range

    On Error GoTo ErrHandler
    Set rChange = Intersect(Target, Range("A:A"))
    If Not rChange Is Nothing Then
    Application.EnableEvents = False
    For Each rCell In rChange
    If rCell > "" Then
    With rCell.Offset(0, 1)
    .Value = Now
    .NumberFormat = "hh:mm:ss"
    End With
    Else
    rCell.Offset(0, 1).Clear
    End If
    Next
    End If

    ExitHandler:
    Set rCell = Nothing
    Set rChange = Nothing
    Application.EnableEvents = True
    Exit Sub
    ErrHandler:
    MsgBox Err.Description
    Resume ExitHandler
    End Sub
    With the macro in place, anytime you enter something into a cell in column A, the adjacent cell in column B will contain the date and time (formatted to show only the time). If you delete something in column A, then the adjacent cell in column B is cleared, as well.



    chwaqasahmed


    To copy any cell press Ctrl+C and for paste use Ctrl+V.



    DaNgErOuS tEaRs





    Create Excel 2007 Files

    1) Click on the Start button. Then select Programs >> Microsoft Office >> Microsoft Office Excel 2007 menu item.

    2) A new blank workbook, Book1, will be displayed.

    aplon - ~ Polling for IT competittion of June 09 ~

    3) Upper the grid area, you will see the columns, named with letters from A.

    4) A t the left area, you will see the rows numbers. Then, cells are referenced by their column name and row number. As you can see in the above image, the cursor is positioned at cell D8.

    5) The Options Tape extends throughout the superior part of Excel and their related commands are organized in groups. Each group is related to a specific work that the people can make in Excel.

    iyoehi - ~ Polling for IT competittion of June 09 ~

    6) In order to see the different commands in each group, you must click in groups located in the superior part of the tape of options. The card Home, that is the first card beginning by the left, contains the habitual commands that people use more frequently.

    7) The commands are organized in small related groups. For example, the commands to edit cells are in the group Font, and the commands to work with cells are in the group Cells.

    23r6yo - ~ Polling for IT competittion of June 09 ~

    8) The first book opened is denominated Book1. This title appears in the bar at upper side of the window until the book is saved with a new name. Each new book has three sheets, like the pages of a document. Within the sheets you can specify data. Sometimes the sheets receive the name of spreadsheets. It is recommended to change the sheet's name to more easily identify the information contained in each one.

    zmo609 - ~ Polling for IT competittion of June 09 ~

    Now Creating a Work Book

    9) To create a new book, click on the Office button in the upper left side, then select the New menu item. Select Blank WorkBook from the window.

    110xis0 - ~ Polling for IT competittion of June 09 ~

    10) Columns extend from top to bottom in the spreadsheet, that is to say, vertically. Rows extend of left to right in the spreadsheet, that is to say, horizontally. Cells are the space where columns and rows are intersected. Each book has 16.384 columns and 1.048.576 rows. When you open a new book, the first cell is the active cell.

    Working with cells

    11) Cells are the space where data in the spreadsheet are specified. When you open a new book, the first cell that you see in the left superior corner of the spreadsheet appears in black, indicating that in it will be the showed data that you specify.

    12) You can specify data in the place that you wish by clicking in the corresponding cell of the spreadsheet to select it.

    k0pxg3 - ~ Polling for IT competittion of June 09 ~

    13) You can select an entire column by clicking in its name.

    23hq3w0 - ~ Polling for IT competittion of June 09 ~

    14) You can select an entire Row by clicking in its number.

    210atfk - ~ Polling for IT competittion of June 09 ~

    15) The Office button has replaced the older version's File menu. Here you will find the basic commands as Save, Save As ., etc.

    20s6ps9 - ~ Polling for IT competittion of June 09 ~

    16) The Quick Access toolbar is located at the top edge on the screen (upper the Options Tape) and contains the most used commands.

    mm5x8n - ~ Polling for IT competittion of June 09 ~


    Microsoft Excel 2007 Tutorial for beginners Saturday, June 20, 2007

    Welcome to MS Tips and Tricks
    Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories - Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,

    Microsoft Excel Tips and Tricks for beginners

    Keyboard abbreviated methods

    15) The Office button has replaced the older version's File menu. Here you will find the basic commands as Save, Save As ., etc.

    Illustration 9: Office button.

    16) The Quick Access toolbar is located at the top edge on the screen (upper the Options Tape) and contains the most used commands.

    Illustration 10: Quick Access toolbar.

    17) There are two ways to use the keyboard: to gain access to the groups and commands in the screen or use a couple of keys to execute some commands not related to the Options Tape.

    18) The access keys provide access to the tape of options. They relate directly to groups, the commands and other elements that are seen in the screen. The access keys are used by pressing ALT key at the same time with another key or a sequence of other keys.

    19) A key's combination executes specific commands. These key's combination are no related to the Options Tape.

    20) As soon as you press ALT key, you will see small labels or identifiers that will appear to show the suggestions of keys of all groups.

    21) After pressing a key to activate a concrete group, it will appear the identifiers that show the suggestions of keys for the commands of that group.

    2uorr7d - ~ Polling for IT competittion of June 09 ~

    22) The Tab key will allow you to navigate the Options Tape once ALT + Key was pressed.

    m7ylqc - ~ Polling for IT competittion of June 09 ~

    23) Press UPPER+TAB in order to cross the commands in opposite direction. Press ENTER to select the desired command.

    24) You can go to the different areas of the program window by pressing F6.

    25) The space bar activates and deactivates options checks.

    26) UPPER + F10 key activate the context's menus.

    27) ESC close context's menus.

  2. #2
    Join Date
    Mar 2008
    Location
    Canada
    Posts
    25,300
    Mentioned
    0 Post(s)
    Tagged
    442 Thread(s)
    Thanked
    0
    Rep Power
    11381699

    Default Re: ~ Polling for IT competittion of June 09 ~


    voted............

  3. #3
    Join Date
    Jun 2009
    Location
    Mama Papa k ghar mein
    Age
    30
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanked
    0
    Rep Power
    0

    Default Re: ~ Polling for IT competittion of June 09 ~

    hm yaha bote nai kr sakty kiya?..........

  4. #4
    Join Date
    Feb 2008
    Location
    Karachi, Pakistan, Pakistan
    Posts
    125,914
    Mentioned
    839 Post(s)
    Tagged
    9270 Thread(s)
    Thanked
    1181
    Rep Power
    21474971

    Default Re: ~ Polling for IT competittion of June 09 ~

    nahi 50 posts ke bad karsaktey ap vote.
    صرف آواز نہیں ، لفظ بھی مقفل ہیں مرے

    سوچ میں ہوں کہ اب تجھ کو پکاروں کیسے

  5. #5
    Join Date
    Jun 2009
    Location
    Mama Papa k ghar mein
    Age
    30
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanked
    0
    Rep Power
    0

    Default Re: ~ Polling for IT competittion of June 09 ~

    zalim samaaj yahan bhe array a gaya............
    @naz
    admin g
    bnda kisy member ko azazi torr pr bhe kuch ata kr daita hai
    exceptional cases r always there


    @topic
    Allah us bndy ka bhala kry jis nay hmein pahla vote day kr khud kashi krny say bachaya
    hm tou boht disheart thay
    bzy hony ke waja say kuch jaga muqably mein hisa nai lay paye thay
    aur jahan hisa liya
    wahan na koi vote day raha tha aur na he vote ke ijazat mil rahy thee
    any how aye na deeda hamdarad Allah teri umar daraz kry

  6. #6
    Join Date
    Mar 2008
    Location
    HEART
    Posts
    5,555
    Mentioned
    1 Post(s)
    Tagged
    96 Thread(s)
    Thanked
    8
    Rep Power
    21474851

    Default Re: ~ Polling for IT competittion of June 09 ~

    Voted................
    1317513431 - ~ Polling for IT competittion of June 09 ~
    pics 602437 - ~ Polling for IT competittion of June 09 ~

  7. #7
    Join Date
    Aug 2008
    Location
    ~Near to Heart~
    Age
    28
    Posts
    78,521
    Mentioned
    3 Post(s)
    Tagged
    2881 Thread(s)
    Thanked
    0
    Rep Power
    21474924

    Default Re: ~ Polling for IT competittion of June 09 ~

    Voted
    2112kjd - ~ Polling for IT competittion of June 09 ~

  8. #8
    Join Date
    Feb 2008
    Location
    Karachi, Pakistan, Pakistan
    Posts
    125,914
    Mentioned
    839 Post(s)
    Tagged
    9270 Thread(s)
    Thanked
    1181
    Rep Power
    21474971

    Default Re: ~ Polling for IT competittion of June 09 ~

    Voted
    صرف آواز نہیں ، لفظ بھی مقفل ہیں مرے

    سوچ میں ہوں کہ اب تجھ کو پکاروں کیسے

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •