1)एक्सल फॉरम्युला फाइल 2.4 m.b 2)
EXCEL VIDEO IN HINDI - WEBSITE - या वेबसाइडवर आपणाला हिंदी तसेच इंग्रजी तुन व्हिडीओ पाहायला मिळतील ..
३)enable macros एक्सल मधील मक्रो इनबल कसे कराल चित्रमय स्वरुपात - फाइल १
Percentage
=(Total’s cell address/Total Marks)*100
=(f2/400)*100
Maximum
=max(Number1,Number2,Number3…..)
=max(b2:b11)
Minimum
=min(Number1,Number2,Number3…..)
=min(b2:b11)
Average
=average(Number1,Number2,Number3…..)
=average(b2:b11)
Result
=if(condition, True Value, False Value)
=IF(AND(B2>=35,C2>=35,D2>=35,E2>=35),"Pass","Fail")
B2, c2, d2 and e2 are subject’s cell address
Grade
=IF(G2<=34,"E",IF(G2<=49,"D",IF(G2<=59,"C",IF(G2<=74,"B","A"))))
G2 is percentage cell address
Remark
=IF(I2="E","Unsatisfied",IF(I2="D","Satisfied",IF(I2="C","Good",IF(I2="B","Very Good","Excellent"))))
I2 is Grade cell address
count
=count(Number1,Number2,Number3…..)
=count(b2:b11)
Countif
=countif(cell range, criteria)
=countif(b2:b11,”>=70”)
=countif(h2:h11,”Pass”)
Kiran font akarik sankalit shreni (Gread A1,a2,b1,b2)
=IF(E7>=91,"A1",IF(E7>=81,"A2",IF(E7>=71,"ba1",IF(E7>=61,"ba2",IF(E7>=51,"k 1",IF(E7>=41,"k 2",IF(E7>=33,"D",IF(E7>=21,"[ 1",IF(E7<=20,"[- 2")))))))))
v 6 TH PAY INCREMENT
=ROUND(P11251*38/100;0)
INCREMENT ROUND FIGURE
=IF(MOD(ROUND((J41*3/100);2);10)>0,99;INT(ROUND((J41*3/100);2)/10)*10+10;INT(ROUND((J41*3/100);2)/10)*10)
=IF(MOD(ROUND((D49*3/100);2);10)>0,99;INT(ROUND((D49*3/100);2)/10)*10+10;INT(ROUND((D49*3/100);2)/10)*10)
BAND PAY FIXATION BY OLD
=IF(MOD(ROUND(V42*1,86;2);10)>0,09;INT(ROUND(V42*1,86;2)/10)*10+10;INT(ROUND(V42*1,86;2)/10)*10)
|
|
The below basic shortcut keys are a listing of shortcut keys that will work with almost all IBM compatible computers and software programs. It is highly recommended that all users keep a good reference of the below short cut keys and/or try to memorize the below keys. Doing so will dramatically increase your productivity.
Shortcut Keys
|
Description
|
Alt + F
|
File menu options in current program.
|
Alt + E
|
Edit options in current program
|
F1
|
Universal Help in 90% of Windows programs.
|
Ctrl + A
|
Select all text.
|
Ctrl + X
|
Cut selected item.
|
Shift + Del
|
Cut selected item.
|
Ctrl + C
|
Copy selected item.
|
Ctrl + Ins
|
Copy selected item
|
Ctrl + V
|
Paste
|
Shift + Ins
|
Paste
|
Home
|
Goes to beginning of current line.
|
Ctrl + Home
|
Goes to beginning of document.
|
End
|
Goes to end of current line.
|
Ctrl + End
|
Goes to end of document.
|
Shift + Home
|
Highlights from current position to beginning of line.
|
Shift + End
|
Highlights from current position to end of line.
|
Ctrl + Left arrow
|
Moves one word to the left at a time.
|
Ctrl + Right arrow
|
Moves one word to the right at a time.
|
MICROSOFT WINDOWS SHORTCUT KEYS
Shortcut Keys
|
Operating System
|
Description
|
Alt + Tab
|
|
Switch between open applications.
|
Alt + Shift + Tab
|
|
Switch backwards between open applications.
|
|
|
|
Create a screen shot only for the program you are currently in.
|
Ctrl + Esc
|
|
Bring Up start button.
|
Alt + Esc
|
|
Switch Between open applications on taskbar.
|
F2
|
|
Renames selected Icon
|
F3
|
|
Starts find from desktop
|
F4
|
|
Opens the drive selection when browsing.
|
F5
|
|
Refresh Contents
|
Alt + F4
|
|
Closes Current open program.
|
Ctrl + F4
|
|
Closes Window in Program
|
Ctrl + (the '+' key on the keypad)
|
|
Automatically adjust the width's of all the columns in Windows explorer
|
Alt + Enter
|
|
Opens properties window of Selected icon or program.
|
Shift + F10
|
|
Simulates right click on selected item.
|
Shift + Del
|
|
Delete programs/files without throwing into the recycle bin.
|
Holding Shift
|
|
Boot safe mode or by pass system files.
|
Holding Shift
|
|
When putting in an audio CD will prevent CD Player from playing.
|
WINDOWS KEYBOARD SHORTCUTS
Shortcut Keys
|
Description
|
WINKEY + D
|
|
WINKEY + M
|
Minimizes all windows.
|
WINKEY + SHIFT + M
|
Undo the minimize.
|
WINKEY + E
|
Open Microsoft Explorer.
|
WINKEY + Tab
|
Cycle through open programs through the taskbar.
|
WINKEY + F
|
Display the Windows Search / Find feature.
|
|
|
Display the search for computers window.
|
WINKEY + F1
|
Display the Microsoft Windows help.
|
WINKEY + R
|
Open the run window.
|
WINKEY + Pause / Break key
|
Open the system properties window.
|
WINKEY + U
|
Open Utility Manager.
|
WINKEY + L
|
Lock the computer (Windows XP and above only).
|
Shortcut Keys
|
Description
|
F7
|
Spell check selected text and or document.
|
F11
|
Create chart.
|
Ctrl + Shift + ;
|
Enter the current time
|
Ctrl + ;
|
Enter the current date
|
Alt + Shift + F1
|
Insert New Worksheet
|
Shift + F3
|
Open the Excel formula window.
|
Shift + F5
|
Bring up search box.
|
Ctrl + A
|
Select all contents of the worksheet.
|
Ctrl + B
|
Bold highlighted selection.
|
Ctrl + I
|
Italic highlighted selection.
|
Ctrl + K
|
Insert link.
|
Ctrl + U
|
Underline highlighted selection.
|
Ctrl + 5
|
Strikethrough highlighted selection.
|
Ctrl + P
|
Bring up the print dialog box to begin printing.
|
Ctrl + Z
|
Undo last action.
|
Ctrl + F9
|
Minimize current window.
|
Ctrl + F10
|
Maximize currently selected window.
|
Ctrl + F6
|
Switch between open workbooks / windows.
|
Ctrl + Page up
|
Move between Excel work sheets in the same Excel document.
|
Ctrl + Page down
|
Move between Excel work sheets in the same Excel document.
|
Ctrl + Tab
|
Move between Two or more open Excel files.
|
Ctrl + Shift + !
|
Format number in comma format.
|
Ctrl + Shift + $
|
Format number in currency format.
|
Ctrl + Shift + #
|
Format number in date format.
|
Ctrl + Shift + %
|
Format number in percentage format.
|
Ctrl + Shift + ^
|
Format number in scientific format.
|
Ctrl + Shift + @
|
Format number in time format.
|
Ctrl + Arrow key
|
Move to next section of text.
|
Ctrl + Space
|
|
Shift + Space
|
|
Shortcut Keys
|
Description
|
Ctrl + A
|
Select all contents of the page.
|
Ctrl + B
|
Bold highlighted selection.
|
Ctrl + C
|
Copy selected text.
|
Ctrl + X
|
Cut selected text.
|
Ctrl + P
|
Open the print window.
|
Ctrl + F
|
Open find box.
|
Ctrl + I
|
Italic highlighted selection.
|
Ctrl + K
|
Insert link.
|
Ctrl + U
|
Underline highlighted selection.
|
Ctrl + V
|
Paste.
|
Ctrl + Y
|
Repeat the last action performed.
|
Ctrl + Z
|
Undo last action.
|
Ctrl + L
|
Aligns the line or selected text to the left of the screen.
|
Ctrl + E
|
Aligns the line or selected text to the center of the screen.
|
Ctrl + R
|
Aligns the line or selected text to the right of the screen.
|
Ctrl + M
|
Indent the paragraph.
|
Ctrl + Shift + F
|
Change the font.
|
Ctrl + Shift + >
|
Increase selected font +1.
|
Ctrl + ]
|
Increase selected font +1.
|
Ctrl + Shift + <
|
Decrease selected font -1.
|
Ctrl + [
|
Decrease selected font -1.
|
Ctrl + Shift + *
|
View or hide non printing characters.
|
Ctrl + <left arrow>
|
Moves one word to the left.
|
Ctrl + <right arrow>
|
Moves one word to the right.
|
Ctrl + <up arrow>
|
Moves to the beginning of the line or paragraph.
|
Ctrl + <down arrow>
|
Moves to the end of the paragraph.
|
Ctrl + Del
|
Deletes word to right of cursor.
|
Ctrl + Backspace
|
Deletes word to left of cursor.
|
Ctrl + End
|
Moves the cursor to the end of the document.
|
Ctrl + Home
|
Moves the cursor to the beginning of the document.
|
Ctrl + Spacebar
|
Reset highlighted text to the default font.
|
Ctrl + 1
|
Single-space lines.
|
Ctrl + 2
|
Double-space lines.
|
Ctrl + 5
|
1.5-line spacing.
|
Ctrl + Alt + 1
|
Changes text to heading 1.
|
Ctrl + Alt + 2
|
Changes text to heading 2.
|
Ctrl + Alt + 3
|
Changes text to heading 3.
|
F1
|
Open Help.
|
Shift + F3
|
Change the case of the selected text.
|
Shift + Insert
|
Paste.
|
F4
|
Repeat the last action performed (2000+)
|
F5
|
Open goto window.
|
F7
|
Spell check selected text and or document.
|
Shift + F7
|
Activate the thesaurus.
|
F12
|
Save as.
|
Shift + F12
|
Save
|
Mouse Shortcuts
|
Description
|
Click, hold, and drag
|
Selects text from where you click and hold to the point you drag and let go.
|
Double-click
|
If double-click a word selects the complete word.
|
Double- click
|
Double-clicking on the left, center, or right of a blank line will make the alignment of the text left, center, or right aligned.
|
Double-click
|
Double-clicking anywhere after text on a line will set a tab stop.
|
Triple-click
|
Selects the line or paragraph of the text the mouse triple-clicked.
|
Ctrl + Mouse wheel
|
Zooms in and out of document.
|
INTERNET EXPLORER SHORTCUT KEYS
Shortcut Keys
|
Description
|
Alt + Left Arrow
|
Back a page.
|
Alt + Right Arrow
|
Forward a page.
|
F5
|
Refresh current page / frame.
|
F11
|
Display the current website in full screen mode. Pressing F11 again will exit this mode.
|
Esc
|
Stop page or download from loading.
|
Ctrl + Enter
|
Quickly complete an address. For example type computerhope in the address bar and press CTRL + ENTER to get http://www.computerhope.com.
|
Ctrl + N
|
Open New browser window.
|
Ctrl + P
|
Print current page / frame.
|
Shortcut Keys
|
Description
|
Ctrl + C
|
Copy selected text.
|
Ctrl + X
|
Cut selected text.
|
Ctrl + P
|
Paste selected text.
|
Ctrl + K
|
Create a hyperlink.
|
Ctrl + B
|
Bold highlighted selection.
|
Ctrl + I
|
Italic highlighted selection.
|
Ctrl + U
|
Underline highlighted selection.
|
Ctrl + L
|
Left align the text.
|
Ctrl + R
|
Right align the text.
|
Ctrl + E
|
Center the text.
|
Ctrl + /
|
Display HTML tags.
|
Ctrl + S
|
Save document.
|
Ctrl + Tab
|
Switch between open web pages.
|
Ctrl + Ins
|
Enter Line break.
|
Ctrl + Enter
|
Move cursor above or below a table.
|
Ctrl + Shift + B
|
Preview in web browser window.
|
Ctrl + Shift + <
|
Decrease font size.
|
Ctrl + Shift + >
|
Increase font size.
|
Ctrl + Del
|
Deletes word to right of cursor.
|
Ctrl + Backspace
|
Deletes word to left of cursor.
|
|
More than 100 Keyboard Shortcuts must read
SHARE IT........
Keyboard Shorcuts (Microsoft Windows)
1. CTRL+C (Copy)
2. CTRL+X (Cut)
3. CTRL+V (Paste)
4. CTRL+Z (Undo)
5. DELETE (Delete)
6. SHIFT+DELETE (Delete the selected item
permanently without placing the item in the Recycle
Bin)
7. CTRL while dragging an item (Copy the selected
item)
8. CTRL+SHIFT while dragging an item (Create a
shortcut to the selected item)
9. F2 key (Rename the selected item)
10. CTRL+RIGHT ARROW (Move the insertion point
to the beginning of the next word)
11. CTRL+LEFT ARROW (Move the insertion point
to the beginning of the previous word)
12. CTRL+DOWN ARROW (Move the insertion point
to the beginning of the next paragraph)
13. CTRL+UP ARROW (Move the insertion point to
the beginning of the previous paragraph)
14. CTRL+SHIFT with any of the arrow keys
(Highlight a block of text)
SHIFT with any of the arrow keys (Select more than
one item in a window or on the desktop, or select
text in a document)
15. CTRL+A (Select all)
16. F3 key (Search for a file or a folder)
17. ALT+ENTER (View the properties for the
selected item)
18. ALT+F4 (Close the active item, or quit the
active program)
19. ALT+ENTER (Display the properties of the
selected object)
20. ALT+SPACEBAR (Open the shortcut menu for
the active window)
21. CTRL+F4 (Close the active document in
programs that enable you to have multiple
documents opensimultaneou sly)
22. ALT+TAB (Switch between the open items)
23. ALT+ESC (Cycle through items in the order that
they had been opened)
24. F6 key (Cycle through the screen elements in a
window or on the desktop)
25. F4 key (Display the Address bar list in My
Computer or Windows Explorer)
26. SHIFT+F10 (Display the shortcut menu for the
selected item)
27. ALT+SPACEBAR (Display the System menu for
the active window)
28. CTRL+ESC (Display the Start menu)
29. ALT+Underlined letter in a menu name (Display
the corresponding menu) Underlined letter in a
command name on an open menu (Perform the
corresponding command)
30. F10 key (Activate the menu bar in the active
program)
31. RIGHT ARROW (Open the next menu to the
right, or open a submenu)
32. LEFT ARROW (Open the next menu to the left,
or close a submenu)
33. F5 key (Update the active window)
34. BACKSPACE (View the folder onelevel up in My
Computer or Windows Explorer)
35. ESC (Cancel the current task)
36. SHIFT when you insert a CD-ROMinto the CD-
ROM drive (Prevent the CD-ROM from
automatically playing)
Dialog Box - Keyboard Shortcuts
1. CTRL+TAB (Move forward through the tabs)
2. CTRL+SHIFT+TAB (Move backward through the
tabs)
3. TAB (Move forward through the options)
4. SHIFT+TAB (Move backward through the
options)
5. ALT+Underlined letter (Perform the corresponding
command or select the corresponding option)
6. ENTER (Perform the command for the active
option or button)
7. SPACEBAR (Select or clear the check box if the
active option is a check box)
8. Arrow keys (Select a button if the active option
is a group of option buttons)
9. F1 key (Display Help)
10. F4 key (Display the items in the active list)
11. BACKSPACE (Open a folder one level up if a
folder is selected in the Save As or Open dialog
box)
Microsoft Natural Keyboard Shortcuts
1. Windows Logo (Display or hide the Start menu)
2. Windows Logo+BREAK (Display the System
Properties dialog box)
3. Windows Logo+D (Display the desktop)
4. Windows Logo+M (Minimize all of the windows)
5. Windows Logo+SHIFT+M (Restorethe minimized
windows)
6. Windows Logo+E (Open My Computer)
7. Windows Logo+F (Search for a file or a folder)
8. CTRL+Windows Logo+F (Search for computers)
9. Windows Logo+F1 (Display Windows Help)
10. Windows Logo+ L (Lock the keyboard)
11. Windows Logo+R (Open the Run dialog box)
12. Windows Logo+U (Open Utility Manager)
13. Accessibility Keyboard Shortcuts
14. Right SHIFT for eight seconds (Switch
FilterKeys either on or off)
15. Left ALT+left SHIFT+PRINT SCREEN (Switch
High Contrast either on or off)
16. Left ALT+left SHIFT+NUM LOCK (Switch the
MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either
on or off)
18. NUM LOCK for five seconds (Switch the
ToggleKeys either on or off)
19. Windows Logo +U (Open Utility Manager)
20. Windows Explorer Keyboard Shortcuts
21. END (Display the bottom of the active window)
22. HOME (Display the top of the active window)
23. NUM LOCK+Asterisk sign (*) (Display all of the
subfolders that are under the selected folder)
24. NUM LOCK+Plus sign (+) (Display the contents
of the selected folder)
MMC COnsole Windows Shortcut keys
1. SHIFT+F10 (Display the Action shortcut menu for
the selected item)
2. F1 key (Open the Help topic, if any, for the
selected item)
3. F5 key (Update the content of all console
windows)
4. CTRL+F10 (Maximize the active console
window)
5. CTRL+F5 (Restore the active console window)
6. ALT+ENTER (Display the Properties dialog box, if
any, for theselected item)
7. F2 key (Rename the selected item)
8. CTRL+F4 (Close the active console window.
When a console has only one console window, this
shortcut closes the console)
Remote Desktop Connection Navigation
1. CTRL+ALT+END (Open the Microsoft Windows
NT Security dialog box)
2. ALT+PAGE UP (Switch between programs from
left to right)
3. ALT+PAGE DOWN (Switch between programs
from right to left)
4. ALT+INSERT (Cycle through the programs in
most recently used order)
5. ALT+HOME (Display the Start menu)
6. CTRL+ALT+BREAK (Switch the client computer
between a window and a full screen)
7. ALT+DELETE (Display the Windows menu)
8. CTRL+ALT+Minus sign (-) (Place a snapshot of
the active window in the client on the Terminal
server clipboard and provide the same functionality
as pressing PRINT SCREEN on a local computer.)
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the
entire client window area on the Terminal server
clipboardand provide the same functionality
aspressing ALT+PRINT SCREEN on a local
computer.)
Microsoft Internet Explorer Keyboard Shortcuts
1. CTRL+B (Open the Organize Favorites dialog
box)
2. CTRL+E (Open the Search bar)
3. CTRL+F (Start the Find utility)
4. CTRL+H (Open the History bar)
5. CTRL+I (Open the Favorites bar)
6. CTRL+L (Open the Open dialog box)
7. CTRL+N (Start another instance of the browser
with the same Web address)
8. CTRL+O (Open the Open dialog box,the same as
CTRL+L)
9. CTRL+P (Open the Print dialog box)
10. CTRL+R (Update the current Web )
SHARE IT WITH YOUR FRIENDS
| Function keys in Microsoft Excel |
|
|
|
|
|
|
|
|
|
|
|
| Function Key | SHIFT | CTRL | ALT | CTRL+SHIFT | ALT+SHIFT |
| F1 | Display Help or the Office Assistant | What's This? | | Insert a chart sheet | | Insert a new worksheet |
| F2 | Edit the active cell | Edit a cell comment | | Save As command | | Save command |
| F3 | Paste a name into a formula | Paste a function into a formula | Define a name | | Create names by using row and column labels | |
| F4 | Repeat the last action | Repeat the last Find (Find Next) | Close the window | Exit | | |
| F5 | Go To | Display the Find dialog box | Restore the window size | | | |
| F6 | Move to the next pane | Move to the previous pane | Move to the next workbook window | | Move to the previous workbook window | |
| F7 | Spelling command | | Move the window | | | |
| F8 | Extend a selection | Add to the selection | Resize the window | Display the Macro dialog box | | |
| F9 | Calculate all sheets in all open workbooks | Calculate the active worksheet | Minimize the workbook | | | |
| F10 | Make the menu bar active | Display a shortcut menu (right click) | Maximize or restore the workbook window | | | |
| F11 | Create a chart | Insert a new worksheet | Insert a Microsoft Excel 4.0 macro sheet | Display Visual Basic Editor | | |
| F12 | Save As command | Save command | Open command | | Print command | |
| Microsoft Excel Action | Excel shortcut |
| Alternates between displaying cell values and displaying formulas in the worksheet. | CTRL+` |
| Alternates between hiding objects, displaying objects, and displaying placeholders for objects. | CTRL+6 |
| Applies or removes bold formatting | CTRL+2 |
| Applies or removes bold formatting | CTRL+B |
| Applies or removes italic formatting | CTRL+3 |
| Applies or removes italic formatting | CTRL+I |
| Applies or removes underlining | CTRL+4 |
| Applies or removes underlining | CTRL+V |
| Applies the Currency format with two decimal places | CTRL+$ |
| Applies the Date format with the day, month, and year | CTRL+# |
| Applies the Exponential number format with two decimal places | CTRL+^ |
| Applies the General number format | CTRL+~ |
| Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values | CTRL+! |
| Applies the outline border to the selected cells | CTRL+& |
| Applies the Percentage format with no decimal places | CTRL+% |
| Applies the Time format with the hour and minute, and AM or PM | CTRL+@ |
| Calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation | CTRL+ALT+F9 |
| Calculates all worksheets in all open workbooks | F9 |
| Calculates the active worksheet | SHIFT+F9 |
| Closes and reopens the current task pane | CTRL+F1 |
| Closes the selected workbook window | CTRL+F4 |
| Closes the selected workbook window | CTRL+X |
| Copies the selected cells | CTRL+C |
| Copies the value from the cell above the active cell into the cell or the Formula Bar" | CTRL+" |
| Creates a chart of the data in the current range | ALT+F1 |
| Creates a chart of the data in the current range | F11 |
| Cuts the selected cells | CTRL+Y |
| Displays or hides the outline symbols | CTRL+8 |
| Displays or hides the Standard toolbar | CTRL+7 |
| Displays the Create List dialog box. CTRL+N Creates a new, blank file | CTRL+L |
| Displays the Delete dialog box to delete the selected cells | CTRL+- |
| Displays the Find and Replace dialog box | CTRL+H |
| Displays the Format Cells dialog box | CTRL+1 |
| Displays the Go To dialog box | CTRL+G |
| Displays the Go To dialog box | F5 |
| Displays the Help task pane | F1 |
| Displays the Insert dialog box to insert blank cells | CTRL++ |
| Displays the Insert Function dialog box | SHIFT+F3 |
| Displays the Macro dialog box to run, edit, or delete a macro | ALT+F8 |
| Displays the Microsoft Office Clipboard | CTRL+C |
| Displays the Open dialog box to open or find a file | CTRL+O |
| Displays the Print dialog box | CTRL+R |
| Displays the Save As dialog box | F12 |
| Displays the shortcut menu for a selected item | SHIFT+F10 |
| Displays the Spelling dialog box to check spelling in the active worksheet or selected range | F7 |
| Edits a cell comment | SHIFT+F2 |
| Enters the current date | CTRL+; |
| Enters the current time | CTRL+: |
| Hides the selected columns | CTRL+0 |
| Hides the selected rows | CTRL+9 |
| Including cells not marked as needing to be calculated | CTRL+F9 |
| Inserts a new worksheet | ALT+SHIFT+F1 |
| Inserts a new worksheet | SHIFT+F11 |
| Maximizes or restores the selected workbook window | CTRL+F10 |
| Minimizes a workbook window to an icon | F10 |
| Pastes a defined name into a formula | F3 |
| Removes the outline border from the selected cells | CTRL+_ |
| Repeats the last command or action, if possible | CTRL+Z |
| Repeats the last command or action, if possible | F4 |
| Restores the window size of the selected workbook window | CTRL+F5 |
| Saves the active file with its current file name and location | CTRL+S |
| Selects all cells that contain comments | CTRL+SHIFT+O |
| Selects the current region | CTRL+A |
| Selects the entire worksheet | CTRL+A CTRL+A (two times) |
| Undo command | CTRL+U |
| Unhides any hidden columns within the selection | CTRL+ |
| Excel shortcut |
| CTRL+` |
| CTRL+6 |
| CTRL+2 |
| CTRL+B |
| Microsoft Word Action | Keybord shortcut |
| Application window-maximize | Alt-F10 |
| Application window-previous | Alt-Shift-F6 |
| Application window-restore | Alt-F5 |
| AutoFormat | Ctrl-Alt-K |
| AutoText-create | Alt-F3 |
| AutoText-insert entry | Ctrl-Alt-V |
| AutoText-insert | entry F3 |
| Bold | Ctrl-B |
| Bookmarks | Ctrl-Shift-F5 |
| Break-column | Ctrl-Shift-Enter |
| Break-page | Ctrl-Enter |
| Browse a document | Ctrl-Alt-Home |
| Browse next/previous item | Ctrl-PgDn/PgUp |
| Capatilize word | shift+f3 |
| Case-All Caps | Ctrl-Shift-A |
| Close | Ctrl-F4 |
| Close | Ctrl-W |
| Copy | Ctrl + C |
| Copy formatting | Ctrl-Shift-C |
| Create a nonbreaking hyphen | CTRL+HYPHEN |
| Create a nonbreaking space | CTRL+SHIFT+SPACEBAR |
| Customize a menu | Ctrl-Alt = |
| Customize a shortcut | Ctrl-Alt-Num + |
| Cut | Ctrl-X |
| Date Field | Alt-Shift-D |
| Decrease font size | CTRL+SHIFT+< |
| Dialog box next tabbed section | Ctrl-Tab |
| Dialog box previous tabbed section | Ctrl-Shift-Tab |
| Document window-move | Ctrl-F7 |
| Document window-restore | Ctrl-F5 |
| Document window-size | Ctrl-F8 |
| Drawing-constrain shape to symmetrical | Shift-drag |
| Drawing-draw from center | Ctrl-drag |
| Ellipsis | Ctrl-Alt- |
| Em Dash | Ctrl-Alt-Num - |
| Endnote | Ctrl-Alt-E |
| Exit application | Alt-F4 |
| Fields-display code | Shift-F9 |
| Fields-display codes (toggle) | Alt-F9 |
| Fields-double-click in field | Alt-Shift-F9 |
| Fields-insert blank field | Ctrl-F9 |
| Fields-lock a field | Ctrl-3 |
| Fields-lock a field | Ctrl-F11 |
| Fields-next | field F11 |
| Fields-previous field | Shift-F11 |
| Fields-unlink a field | Ctrl-6 |
| Fields-unlink a field | Ctrl-Shift-F9 |
| Fields-unlock a field | Ctrl-4 |
| Fields-unlock a field | Ctrl-Shift-F11 |
| Fields-update | Alt-Shift-U |
| Fields-update link in source | Ctrl-Shift-F7 |
| Fields-update selected | field F9 |
| Find | Find Ctrl + F |
| Font | Ctrl-D |
| Font | Ctrl-Shift-F |
| Font grow/shrink 1 pt | Ctrl- ] or [ |
| Font next/previous size | Ctrl-Shift- >or < |
| Font Size Ctrl-Shift-P | Font Size Ctrl-Shift-P |
| Footnote | Ctrl-Alt-F |
| Create a new blank document | Ctrl + N |
| Go Back | Ctrl-Alt-Z |
| Go Back | Shift-F5 |
| GoTo | Ctrl-G |
| GoTo Next/Previous Paragraph | Ctrl-Up/Down |
| GoTo Next/Previous Word | Ctrl-Left/Right |
| Graphic-crop | Shift-drag |
| Graphic-original proportions | Ctrl-click |
| Hanging indent-decrease | Ctrl-Shift-T |
| Hanging Indent-increase | Ctrl-T |
| Hard hyphen - | Ctrl-Shift - |
| Hard space | Hard space |
| Header/Footer-link to previous | Alt-Shift-R |
| Heading Level 1 | Ctrl-Alt-1 |
| Heading Level 2 | Ctrl-Alt-2 |
| Heading Level 3 | Ctrl-Alt-3 |
| Help | F1 |
| Help-Whats This? | Shift-F1 |
| Hidden text | Ctrl-Shift-H |
| Hyperlink | Ctrl-K |
| CTRL+SHIFT+> | Increase font size |
| Indent-decrease | Ctrl-Shift-M |
| Indent-increase | Ctrl-M |
| Ctrl-Alt-M | Insert Comment |
| Insert ListNum | field Ctrl-Alt-L |
| Italics | Ctrl-I |
| Justify-Center | Ctrl-E |
| Justify-Full | Ctrl-J |
| Justify-Left | Ctrl-L |
| Justify-Right | Ctrl-R |
| Line-spacing | Ctrl-1 |
| Line-spacing 1.5 | Ctrl-5 |
| Line-spacing 2 | Ctrl-2 |
| List Bullet Style | Ctrl-Shift-L |
| Macros-edit | Alt-F8 |
| Macros-view VBA code | Alt-F11 |
| Mark-Index entry | Alt-Shift-X |
| Mark-TOA citation | Alt-Shift-I |
| Mark-TOC entry | entry Alt-Shift-O |
| Maximize window | Ctrl-F10 |
| Menu Bar | F10 |
| Merge-data edit | Alt-Shift-E |
| Merge-field insert | Alt-Shift-F |
| Merge-preview | Alt-Shift-K |
| Merge-to document | Alt-Shift-N |
| Merge-to printer | Alt-Shift-M |
| Microsoft Script Editor | Alt-Shift-F11 |
| Microsoft System Info | Ctrl-Alt-F1 |
| Move between master/subdocument | Ctrl-\ |
| Newline within paragraph | Shift-Enter |
| Next window | Ctrl-F6 |
| Nonprinting characters | Ctrl-Shift-8 |
| Normal Style Ctrl-Shift-N | Ctrl-Shift-N |
| Open a document | Ctrl-O |
| Open | Ctrl + O Opens a saved document |
| Outlining-collapse | Alt-Shift-Num - |
| Outlining-expand | Alt-Shift = |
| Outlining-expand | Alt-Shift-Num + |
| Outlining-move | Alt-Shift-Up/Down |
| Outlining-promote/demote | Alt-Shift-Left/Right |
| Outlining-Show 1st line | Alt-Shift-L |
| Outlining-Show All Headings | Alt-Shift-A |
| Outlining-Show Heading 1 | Alt-Shift-1 |
| Outlining-Show Heading 2 | Alt-Shift-2 |
| Outlining-Show Heading 3 | Alt-Shift-3 |
| Outlining-Show Heading 4 | Alt-Shift-4 |
| Outlining-Show Heading 5 | Alt-Shift-5 |
| Outlining-Show Heading 6 | Alt-Shift-6 |
| Outlining-Show Heading 7 | Alt-Shift-7 |
| Outlining-Show Heading 8 | Alt-Shift-8 |
| Outlining-Show Heading 9 | Alt-Shift-9 |
| Page number field | Alt-Shift-P |
| Pane-Close | Alt-Shift-C |
| Paragraph Space Above (add/delete 12 pt.)Ctrl-0 | Ctrl-0 (zero) |
| Paste | Ctrl-V |
| Print | Ctrl-P |
| Print Preview | Ctrl-Alt-I |
| Redo the last action | CTRL+Y |
| Remove Character formats | Ctrl-Shift-Z |
| Remove menu item | Ctrl-Alt - |
| Remove Paragraph formats | Ctrl-Q |
| Remove paragraph or character formatting | CTRL+SPACEBAR |
| Repeat the last command | Ctrl-Y |
| Repeat Find | Ctrl-Alt-Y |
| Repeat Find Shift-F4 | Repeat Find Shift-F4 |
| Replace | Ctrl-H |
| Revision Marks on/off | Ctrl-Shift-E |
| Save As | F12 |
| Save | Ctrl-S |
| Select All | Ctrl-A |
| Selection extended | F8 |
| Selection reduced | Shift-F8 |
| Shortcut Menu | Shift-F10 |
| Small Caps | Ctrl-Shift-K |
| Soft hyphen - | Ctrl - |
| Spelling and Grammar check | F7 |
| Spell-It-display next misspelling | Alt-F7 |
| Spike-cut to | Ctrl-F3 |
| Spike-paste | Ctrl-Shift-F3 |
| Split a window | Ctrl-Alt-S |
| Style box | Ctrl-Shift-S |
| Subscript | Ctrl = |
| Symbol Font | Ctrl-Shift-Q |
| Table-remove border lines | Ctrl-Alt-U |
| Table-to column | bottom Alt-PgDn |
| Table-to column top | Alt-PgUp |
| Table-to row beginning | Alt-Home |
| Table-to row end | Alt-End |
| Thesaurus | Shift-F7 |
| Time Field | Alt-Shift-T |
| To bottom/top of screen | Ctrl-Alt-PgDn/PgUp |
| Type (c) | Ctrl-Alt-C |
| Type (r) | Ctrl-Alt-R |
| Type (tm) | Ctrl-Alt-T |
| underline | CTRL+U |
| Underline-double | Ctrl-Shift-D |
| Underline-word | Ctrl-Shift-W |
| Undo | Ctrl-Z |
| View-Normal | Ctrl-Alt-N |
| View-Outline | Ctrl-Alt-O |
| View-Page | Ctrl-Alt-P |
| Window pane-next | F6 |
| Window pane-previous | Shift-F6 |
| CTRL+3 |
| CTRL+I |
| CTRL+4 |
| Action | PowerPoint shortcut |
| Bold | Ctrl-B |
| Close | Ctrl-W |
| Close | Ctrl-F4 |
| Copy | Ctrl-C |
| Find | Ctrl-F |
| Italics | Ctrl-I |
| Menu bar | F10 |
| New slide | Ctrl-N |
| Next window | Ctrl-F6 |
| Open | Ctrl-O |
| Paste | Ctrl-V |
| Print | Ctrl-P |
| Repeat Find | Shift-F4 |
| Repeat/Redo | Ctrl-Y |
| Replace | Ctrl-H |
| Save | Ctrl-S |
| Slide Show: Begin | F5 |
| Slide Show: Black screen show/hide | B |
| Slide Show: End | Esc |
| Slide Show: Erase annotations | E |
| Slide Show: Go to next hidden slide | H |
| Slide Show: Hide pointer and button always | Ctrl-L |
| Slide Show: Hide pointer and button temporarily | Ctrl-H |
| Slide Show: Mouse pointer to arrow | Ctrl-A |
| Slide Show: Mouse pointer to pen | Ctrl-P |
| Slide Show: Next slide | N |
| Slide Show: Previous slide | P |
| Slide Show: Set new timings while rehearsing | T |
| Slide Show: Stop/restart automatic slide show | S |
| Slide Show: Use mouse-click to advance (rehearsing) | M |
| Slide Show: Use original timings | O |
| Slide Show: White screen show/hide | W |
| Spelling and Grammar check | F7 |
| Switch to the next presentation window | Ctrl-F6 |
| Switch to the next tab in a dialog box | Ctrl-Tab / Ctrl-Page Down |
| Switch to the previous presentation window | Ctrl-Shift-F6 |
| Switch to the previous tab in a dialog box | Ctrl-Shift-Tab / Ctrl-Page Up |
| Turn character formatting on or of | Num / |
| Underline | Ctrl-U |
| Undo | Ctrl-Z |
| CTRL+V |
| CTRL+$ |
| Enter data by using shortcut keys |
|
| To | Press |
| Complete a cell entry | ENTER |
| Cancel a cell entry | ESC |
| Repeat the last action | F4 or CTRL+Y |
| Start a new line in the same cell | ALT+ENTER |
| Delete the character to the left of the insertion point, or delete the selection | BACKSPACE |
| Delete the character to the right of the insertion point, or delete the selection | DELETE |
| Delete text to the end of the line | CTRL+DELETE |
| Move one character up, down, left, or right | Arrow keys |
| Move to the beginning of the line | HOME |
| Edit a cell comment | SHIFT+F2 |
| Create names from row and column labels | CTRL+SHIFT+F3 |
| Fill down | CTRL+D |
| Fill to the right | CTRL+R |
| Fill the selected cell range with the current entry | CTRL+ENTER |
| Complete a cell entry and move down in the selection | ENTER |
| Complete a cell entry and move up in the selection | SHIFT+ENTER |
| Complete a cell entry and move to the right in the selection | TAB |
| Complete a cell entry and move to the left in the selection | SHIFT+TAB |
|
|
| Work in cells or the formula bar by using shortcut keys |
|
| To | Press |
| Start a formula | = (EQUAL SIGN) |
| Cancel an entry in the cell or formula bar | ESC |
| Edit the active cell | F2 |
| Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents | BACKSPACE |
| Paste a name into a formula | F3 |
| Define a name | CTRL+F3 |
| Calculate all sheets in all open workbooks | F9 |
| Calculate the active worksheet | SHIFT+F9 |
| Insert the AutoSum formula | ALT+= (EQUAL SIGN) |
| Enter the date | CTRL+; (SEMICOLON) |
| Enter the time | CTRL+SHIFT+: (COLON) |
| Insert a hyperlink | CTRL+K |
| Complete a cell entry | ENTER |
| Copy the value from the cell above the active cell into the cell or the formula bar | CTRL+SHIFT+" (QUOTATION MARK) |
| Alternate between displaying cell values and displaying cell formulas | CTRL+` (SINGLE LEFT QUOTATION MARK) |
| Copy a formula from the cell above the active cell into the cell or the formula bar | CTRL+' (APOSTROPHE) |
| Enter a formula as an array formula | CTRL+SHIFT+ENTER |
| Display the Formula Palette after you type a valid function name in a formula | CTRL+A |
| Insert the argument names and parentheses for a function, after you type a valid function name in a formula | CTRL+SHIFT+A |
| Display the AutoComplete list | ALT+DOWN ARROW |
|
|
| CTRL+# |
| CTRL+^ |
| CTRL+~ |
| Format data by using shortcut keys |
| To | Press |
| Display the Style command (Format menu) | ALT+' (APOSTROPHE) |
| Display the Cells command (Format menu) | CTRL+1 |
| Apply the General number format | CTRL+SHIFT+~ |
| Apply the Currency format with two decimal places (negative numbers appear in parentheses) | CTRL+SHIFT+$ |
| Apply the Percentage format with no decimal places | CTRL+SHIFT+% |
| Apply the Exponential number format with two decimal places | CTRL+SHIFT+^ |
| Apply the Date format with the day, month, and year | CTRL+SHIFT+# |
| Apply the Time format with the hour and minute, and indicate A.M. or P.M. | CTRL+SHIFT+@ |
| Apply the Number format with two decimal places, 1000 separator, and – for negative values | CTRL+SHIFT+! |
| Apply the outline border | CTRL+SHIFT+& |
| Remove all borders | CTRL+SHIFT+_ |
| Apply or remove bold formatting | CTRL+B |
| Apply or remove italic formatting | CTRL+I |
| Apply or remove an underline | CTRL+U |
| Apply or remove strikethrough formatting | CTRL+5 |
| Hide rows | CTRL+9 |
| Unhide rows | CTRL+SHIFT+( |
| Hide columns | CTRL+0 (ZERO) |
| Unhide columns | CTRL+SHIFT+) |
|
|
|
|
|
|
|
|
| Edit data by using shortcut keys |
| To | Press |
|
|
| Edit the active cell | F2 |
| Cancel an entry in the cell or formula bar | ESC |
| Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents | BACKSPACE |
| Paste a name into a formula | F3 |
| Complete a cell entry | ENTER |
| Enter a formula as an array formula | CTRL+SHIFT+ENTER |
| Display the Formula Palette after you type a valid function name in a formula | CTRL+A |
| Insert the argument names and parentheses for a function, after you type a valid function name in a formula | CTRL+SHIFT+A |
|
|
| Insert, delete, and copy a selection by using shortcut keys |
|
| To | Press |
| Copy the selection | CTRL+C |
| Paste the selection | CTRL+V |
| Cut the selection | CTRL+X |
| Clear the contents of the selection | DELETE |
| Insert blank cells | CTRL+SHIFT+PLUS SIGN |
| Delete the selection | CTRL+ – |
| Undo the last action | CTRL+Z |
|
|
|
|
| Move within a selection by using shortcut keys |
|
| To | Press |
| Move from top to bottom within the selection (down), or in the direction that is selected on the Edit tab (Tools menu, Options command) | ENTER |
| Move from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab (Tools menu, Options command) | SHIFT+ENTER |
| Move from left to right within the selection, or move down one cell if only one column is selected | TAB |
| Move from right to left within the selection, or move up one cell if only one column is selected | SHIFT+TAB |
| Move clockwise to the next corner of the selection | CTRL+PERIOD |
| Move to the right between nonadjacent selections | CTRL+ALT+RIGHT ARROW |
| Move to the left between nonadjacent selections | CTRL+ALT+LEFT ARROW |
|
|
| CTRL+! |
| CTRL+& |
| Select data, cells, chart items, or objects by using shortcut keys |
|
|
|
| Select cells, columns, rows, or objects in worksheets and workbooks by using shortcut keys |
| To | Press |
| Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) | CTRL+SHIFT+* (ASTERISK) |
| Extend the selection by one cell | SHIFT+ arrow key |
| Extend the selection to the last nonblank cell in the same column or row as the active cell | CTRL+SHIFT+ arrow key |
| Extend the selection to the beginning of the row | SHIFT+HOME |
| Extend the selection to the beginning of the worksheet | CTRL+SHIFT+HOME |
| Extend the selection to the last cell used on the worksheet (lower-right corner) | CTRL+SHIFT+END |
| Select the entire column | CTRL+SPACEBAR |
| Select the entire row | SHIFT+SPACEBAR |
| Select the entire worksheet | CTRL+A |
| If multiple cells are selected, select only the active cell | SHIFT+BACKSPACE |
| Extend the selection down one screen | SHIFT+PAGE DOWN |
| Extend the selection up one screen | SHIFT+PAGE UP |
| With an object selected, select all objects on a sheet | CTRL+SHIFT+SPACEBAR |
| Alternate between hiding objects, displaying objects, and displaying placeholders for objects | CTRL+6 |
| Show or hide the Standard toolbar | CTRL+7 |
| In End mode, to | Press |
| Turn End mode on or off | END |
| Extend the selection to the last nonblank cell in the same column or row as the active cell | END, SHIFT+ arrow key |
| Extend the selection to the last cell used on the worksheet (lower-right corner) | END, SHIFT+HOME |
| Extend the selection to the last cell in the current row; this keystroke is unavailable if you selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command) | END, SHIFT+ENTER |
| With SCROLL LOCK on, to | Press |
| Turn SCROLL LOCK on or off | SCROLL LOCK |
| Scroll the screen up or down one row | UP ARROW or DOWN ARROW |
| Scroll the screen left or right one column | LEFT ARROW or RIGHT ARROW |
| Extend the selection to the cell in the upper-left corner of the window | SHIFT+HOME |
| Extend the selection to the cell in the lower-right corner of the window | SHIFT+END |
| Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to keep the same selection as you scroll, turn on SCROLL LOCK first. | |
|
|
| Select cells with special characteristics by using shortcut keys |
|
| To | Press |
| Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns) | CTRL+SHIFT+* (ASTERISK) |
| Select the current array, which is the array that the active cell belongs to | CTRL+/ |
| Select all cells with comments | CTRL+SHIFT+O (the letter O) |
| Select cells whose contents are different from the comparison cell in each row (for each row, the comparison cell is in the same column as the active cell) | CTRL+\ |
| Select cells whose contents are different from the comparison cell in each column (for each column, the comparison cell is in the same row as the active cell) | CTRL+SHIFT+| |
| Select only cells that are directly referred to by formulas in the selection | CTRL+[ |
| Select all cells that are directly or indirectly referred to by formulas in the selection | CTRL+SHIFT+{ |
| Select only cells with formulas that refer directly to the active cell | CTRL+] |
| Select all cells with formulas that refer directly or indirectly to the active cell | CTRL+SHIFT+} |
| Select only visible cells in the current selection | ALT+SEMICOLON |
|
|
| Select chart items by using shortcut keys |
|
| To | Press |
| Select the previous group of items | DOWN ARROW |
| Select the next group of items | UP ARROW |
| Select the next item within the group | RIGHT ARROW |
| Select the previous item within the group | LEFT ARROW |
| CTRL+% |
|
No comments:
Post a Comment