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.
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.
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.
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.
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.
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.
13) You can select an entire column by clicking in its name.
14) You can select an entire Row by clicking in its number.
15) The Office button has replaced the older version's File menu. Here you will find the basic commands as Save, Save As ., etc.
16) The Quick Access toolbar is located at the top edge on the screen (upper the Options Tape) and contains the most used commands.
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.
22) The Tab key will allow you to navigate the Options Tape once ALT + Key was pressed.
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.
Mai aur Meri Tanhai
Re: ~ Polling for IT competittion of June 09 ~
​
Posting Permissions
