Showing posts with label Tutorial. Show all posts
Showing posts with label Tutorial. Show all posts

Wednesday, December 23, 2009

Access 2007 Keyboard Shortcuts

Here are the Access 2007 Keyboard Shortcuts

Using the Navigation Pane

Down arrow Move to the next object.
Up arrow Move the previous object.
End Move to the last object.
Home Move to the first object.
Enter Open the selected object.
Ctrl+Enter Open the selected object in Design view.
F2 Rename the selected object.
F11 Hide or show the Navigation pane.


Navigating in Datasheet View

Tab or right arrow Move to the next field to the right, or to the first field of the next record if you’re in the last field of a record.
Shift+Tab or left arrow Move to the previous field to the left, or to the last field (the Add New Field column) of the previous record if you’re in the first field of a record.
Ctrl+Right arrow Move to the next word in the current field if the cursor is in the field.
Ctrl+Left arrow Move to the previous word in the current field if the cursor is in the field.
Home Move to the first field or move to the beginning of the current field if the cursor is in the field.
End Move to the last field (Add New Field) or move to the end of the current field if the cursor is in the field.
Up arrow Move to the current field in the previous record.
Down arrow Move to the current field in the next record.
Ctrl+Up arrow Move to the current field in the first record.
Ctrl+Down arrow Move to the current field in the last record.
Ctrl+Home Move to the first field of the first record.
Ctrl+End Move to the last field of the last record.
Alt+F5 Activate the Record Number box. To navigate to a specific record, type the record number and press Enter.
Ctrl+Shift+Down arrow Display the subdatasheet associated with the current record.
Ctrl+Shift+Up arrow Hide the subdatasheet associated with the current record.


Selecting Data in Datasheet View

F8 Extend the selection to the current word, all the text in the current field, the current field, the current record, and then all records.
Shift+F8 Collapse the selection to the current record, the text in the current records, and then the current word.
Shift+arrow keys Extend the current selection in the arrow key direction.
Shift+Spacebar Select the current record. (Press Shift+Spacebar again to select the first field in the current record.)
Ctrl+Spacebar Select the current field. (Press Ctrl+Spacebar again to select the first item in the current field.)
Ctrl+Shift+F8 Enter Move mode, which enables you to move the selected column left or right by pressing left arrow or right arrow. Press Esc to exit Move mode.
Ctrl+A Select all records.


Editing Data in Datasheet View

F2 Edit the current cell.
Shift+F2 Display the contents of the current field in the Zoom dialog box.
F9 Refresh the contents of a lookup field.
Ctrl+Alt+Spacebar Insert the default value for the field.
Ctrl+; Insert the current date.
Ctrl+: Insert the current time.
Ctrl+’ Copy the contents from the field directly above the current field.
Ctrl++ Add a new record.
Ctrl+- Delete the current record.
Ctrl+Enter Start a new line in a multiline field.
Shift+Enter Save changes to the current record.
Esc Undo the changes in the current field. Press Esc again to undo all changes to the current record.


Navigating in Form View

Tab or right arrow Move to the next field to the right or to the first field of the next record if you’re in the last field of a record.
Shift+Tab or left arrow Move to the previous field to the left or to the last field of the previous record if you’re in the first field of a record.
Ctrl+Right arrow Move to the next word in the current field if the cursor is in the field.
Ctrl+Left arrow Move to the previous word in the current field if the cursor is in the field.
Home Move to the first field or move to the beginning of the current field if the cursor is in the field.
End Move to the last field or move to the end of the current field if the cursor is in the field.
Ctrl+Up arrow Move to the current field in the first record.
Ctrl+Down arrow Move to the current field in the last record.
Ctrl+Page Up Move to the current field in the previous record.
Ctrl+Page Down Move to the current field in the next record.
Ctrl+Home Move to the first field of the first record.
Ctrl+End Move to the last field of the last record.
Alt+F5 Activate the Record Number box. To navigate to a specific record, type the record number and press Enter.


Working in Design View

F4 or Alt+Enter Toggle the Property Sheet pane for the current object on and off.
F5 Switch to Form view (from the form Design view).
F7 Display the Choose Builder dialog box. If the object already has code associated with it, pressing F7 displays the code.
Alt+F8 Toggle the Field List pane on and off.
Arrow keys Move the selected control in the arrow key direction.
Ctrl+arrow keys Move the selected control one pixel in the arrow key direction.
Shift+right arrow Increase the width of the selected control.
Shift+down arrow Increase the height of the selected control.
Shift+left arrow Decrease the width of the selected control.
Shift+up arrow Decrease the height of the selected control.

Source:
Tricks of the Microsoft Office 2007 Gurus by Paul McFedries


Outlook 2007 Keyboard Shortcuts

Here are the Outlook 2007 Keyboard Shortcuts.

Switching Folders

Ctrl+1 Switch to the Mail folder.
Ctrl+Shift+I Switch to the Inbox in the Mail folder.
Ctrl+Shift+O Switch to the Outbox in the Mail folder.
Ctrl+2 Switch to the Calendar folder.
Ctrl+3 Switch to the Contacts folder.
Ctrl+4 Switch to the Tasks folder.
Ctrl+5 Switch to the Notes folder.
Ctrl+6 Switch to the Folder List.
Ctrl+7 Switch to the Shortcuts folder.
Ctrl+8 Switch to the Journal folder.
Ctrl+Y Open the Go to Folder dialog box.


Creating New Items

Ctrl+N Create a new item in the current folder.
Ctrl+Shift+A Create a new appointment.
Ctrl+Shift+C Create a new contact.
Ctrl+Shift+E Create a new folder.
Ctrl+Shift+J Create a new journal entry.
Ctrl+Shift+K Create a new task.
Ctrl+Shift+L Create a new distribution list.
Ctrl+Shift+M Create a new e-mail message.
Ctrl+Shift+N Create a new note
Ctrl+Shift+P Create a new search folder.
Ctrl+Shift+Q Create a new meeting request.
Ctrl+Shift+S Create a new post in the current mail folder.
Ctrl+Shift+T Display the Choose InfoPath Form dialog box.
Ctrl+Shift+U Create a new task request.
Ctrl+Shift+X Create a new Internet fax.


Working with E-mail Messages

Enter Open the current message.
Alt+down arrow Display the next message (in the mail folder).
Alt+up arrow Display the previous message (in the mail folder).
Ctrl+> or Ctrl+. Display the next message (with the current message open in a window).
Ctrl+< or Ctrl+, Display the previous message (with the current message open in a window).
Ctrl+< or Ctrl+, Display the previous message (with the current message open in a window).
Spacebar Display the next screen of message text in the Reading pane.
Shift+Spacebar Display the previous screen of message text in the Reading pane.
Ctrl+D Delete the current message.
Ctrl+F Forward the current message.
Ctrl+Alt+F Forward the current message as an attachment.
Ctrl+R Reply to the sender of the current message.
Ctrl+Shift+R Reply to the sender and all recipients of the current message.
Ctrl+Alt+J Mark a message as not junk (in the Junk E-mail folder).
Ctrl+Q Mark the current message as read.
Ctrl+U Mark the current message as unread.
Ctrl+Shift+G Flag the current message for follow-up.
Insert Apply a Quick Flag to the current message.
Ctrl+Shift+V Move the current message to another folder.
Ctrl+Shift+W Select the Information bar and display its list of commands.
Ctrl+A Select all the messages in the current folder.
F9 Send and receive messages on all e-mail accounts.
Ctrl+Alt+S Open the Send/Receive Groups dialog box.
Ctrl+Alt+M Mark the current message header for downloading.
Ctrl+Alt+U Unmark all message headers selected for downloading.
Ctrl+K Check the validity of addresses (when composing a new mail message).
Alt+S Send the message (when composing a new mail message).


Working with Appointments

Ctrl+< Move to the previous appointment.
Ctrl+> Move to the next appointment.
Ctrl+Alt+1 Switch to Day view.
Ctrl+Alt+2 Switch to Work Week view.
Ctrl+Alt+3 Switch to Week view.
Ctrl+Alt+4 Switch to Month view.
Ctrl+G Open the Go To Date dialog box.
Ctrl+G Set the appointment recurrence (when an appointment window is open)
Ctrl+n Display n days in the calendar (where n is a number between 0 and 9; use 0 to display 10 days).
Ctrl+right arrow Move to the next day.
Ctrl+left arrow Move to the previous day.
Alt+down arrow Move to the same day in the next week.
Alt+up arrow Move to the same day in the previous week.
Alt+Page Down Move to the same day in the next month.
Alt+Page Up Move to the same day in the previous month.
Alt+Home Move to the start of the current week.
Alt+End Move to the end of the current week.


Working with Contacts

Alt+Shift+1 Alt+Shift+2 Alt+Shift+3
Shift+character Move to the first contact with a name that begins with character (you must be in a table or list view).
Ctrl+F Send the current contact in Outlook format via e-mail.
Ctrl+Shift+D Open the New Call dialog box.
Ctrl+Shift+X Display the current contact’s Web site.
F11 Activate the Search Address Books text box.
Alt+D Open the Check Address dialog box (in a contact window).
Display the contact’s main e-mail address (in a contact window).
Display the contact’s second e-mail address (in a contact window).
Display the contact’s third e-mail address (in a contact window).


Searching

Ctrl+E or F3 Activate the Instant Search box.
Ctrl+Alt+A Search all items in the current folder.
Ctrl+Alt+K Run a Windows desktop search.
Ctrl+Alt+W Toggle the Query Builder on and off.
Ctrl+Shift+F Open the Advanced Find dialog box.
Esc Clear the search results.


Miscellaneous

Alt+F1 Cycle the Navigation pane between on, minimized, and off.
Alt+F2 Cycle the To-Do Bar between on, minimized, and off.
Ctrl+Shift+F8 Display the Address Book window.
Ctrl+Shift+Y Copy the current item to another folder.


Thursday, December 17, 2009

PowerPoint 2007 Keyboard Shortcuts

Here are the PowerPoint 2007 Keyboard Shortcuts.

Navigating a Slide

Ctrl+Right arrow Move to the next word.
Ctrl+Left arrow Move to the previous word.
End Move to the end of the current line.
Home Move to the start of the current line.
Ctrl+Down arrow Move to the start of the next paragraph.
Ctrl+Up arrow Move to the start of the previous paragraph.
Ctrl+End Move to the end of the current placeholder.
Ctrl+Home Move to the start of the current placeholder.
Ctrl+Enter Move to the next placeholder. If the cursor is in the current slide’s last placeholder, pressing Ctrl+Enter inserts a new slide with the same layout as the current slide.


Selecting Data

Shift+navigation key Move the cursor as dictated by the navigation key (see “Navigating a Slide”) and also extends the current selection to that point.
Tab Select the next slide placeholder (another object on the slide must first be selected).
Shift+Tab Select the previous slide placeholder (another object on the slide must first be selected).
Enter Select all the text in a placeholder when the placeholder is selected.
Esc Select a placeholder when the cursor is inside the placeholder.
Ctrl+A (placeholder) Select all the text in a placeholder when the cursor is inside that placeholder.
Ctrl+A (Slides tab) Select all the objects in the presentation.
Ctrl+A (Outline tab) Select all the text in the presentation.
Ctrl+A (Slide Sorter) Select all the slides in the presentation.


Formatting Text

Shift+F3 Cycle the case of the current word or selection through UPPERCASE, lowercase, and Title Case.
Ctrl+= Apply subscript to the selected text.
Ctrl++ Apply superscript to the selected text.
Ctrl+> Apply the next highest font size to the selected text.
Ctrl+] Grow the font size of the selected text by one point.
Ctrl+< Apply the next lowest font size to the selected text.
Ctrl+[ Shrink the font size of the selected text by one point.
Ctrl+Shift+F Display the Font dialog box with Font selected.
Ctrl+L Apply Align Left to the selected text.
Ctrl+E Apply Center to the selected text.
Ctrl+R Apply Align Right to the selected text.
Ctrl+J Apply Justify to the selected text.
Ctrl+Space or Ctrl+Shift+Z Clear the character formatting of the selected text.


Editing a Presentation

Tab Demote the current paragraph.
Shift+Tab Promote the current paragraph.
Alt+Shift+up arrow Move the current paragraph up.
Alt+Shift+down arrow Move the current paragraph down.
Ctrl+D Duplicate the current object.
Ctrl+M Insert a new slide using the default layout.
Ctrl+Shift+M Insert a new slide using the same layout as the most recently inserted slide.


Controlling the Outline

Alt+Shift+1 Show only the slide titles.
Alt+Shift+A Show all outline text.
Alt+Shift++ Expand the current outline item.
Alt+Shift+– Collapse the current outline item.
Alt+F9 Toggle the drawing guides on and off.
Shift+F9 Toggle the grid on and off.
F5 Switch to Slide Show view and start the current presentation from the first slide.


Controlling a Slide Show

N Advance to the next slide or run the next animation. PowerPoint also supports the following keys for this task: Spacebar, Enter, right arrow, down arrow, or Page Down.
PReturn to the previous slide or reverse the most recent animation. PowerPoint also supports the following keys for this task: Backspace, left arrow, up arrow, or Page Up.
n, Enter Jump to slide number n.
S or + Pause or resume an automatic slide show.
B or . Toggle the black screen on and off.
W or , Toggle the white screen on and off.
A Toggle the mouse pointer and slide show navigation tools on and off.
Ctrl+A Change the mouse pointer to an arrow if the mouse is currently displayed as a pen or eraser.
Ctrl+P Change the mouse pointer to a pen.
E Erase ink annotations.
H Display the next slide, if that slide is hidden.
Ctrl+T Display the Windows taskbar.
Esc End the slide show. PowerPoint also ends the slide show if you press hyphen [-] or Ctrl+Break.

Wednesday, December 16, 2009

Excel 2007 Keyboard Shortcuts

Here are the Excel 2007 Keyboard Shortcuts.

Navigating a Document

Arrow keys Move left, right, up, or down one cell.
Home Move to the beginning of the row.
Page Down Move down one screen.
Page Up Move up one screen.
Alt+Page Down Move one screen to the right.
Alt+Page Up Move one screen to the left.
Ctrl+Home Move to the beginning of the worksheet.
Ctrl+End Move to the bottom, right corner of the used portion of the worksheet.
Ctrl+arrow keys Move in the direction of the arrow to the next nonblank cell if the current cell is blank or to the last nonblank cell if the current cell isnonblank.
Ctrl+Backspace Scroll the worksheet to bring the active cell of the current selection into view.
F5 or Ctrl+G Open the Go To dialog box.
Ctrl+Page Up Move to the previous worksheet.
Ctrl+Page Down Move to the next worksheet.


Selecting Data

Shift+navigation key Move the active cell as dictated by the navigation key (see “Navigating a Worksheet”) and also extend the current selection to that point.
Ctrl+* Select the rectangular area that includes every cell adjacent to the current cell.
Ctrl+Spacebar Select the entire column (or columns) that contains the active cell (or cells).
Shift+Spacebar Select the entire row (or rows) that contains the active cell (or cells).
F8 Toggle extend mode on and off. (When extend mode is on, use the navigation keys to extend the selection.)
Shift+F8 Toggle add mode on and off. (When add mode is on, select a cell or range to add it to the current selection.)
Ctrl+Shift+O Select all the cells in the current worksheet that contain comments.
Ctrl+/ Select the array containing the active cell.
Ctrl+\ Select the cells that don’t match the active cell in the current horizontal selection.
Ctrl+| Select the cells that don’t match the active cell in the current vertical selection.
Ctrl+[ Select the cells directly referenced by the formula in the active cell.
Ctrl+{ Select the cells directly or indirectly referenced by the formula in the active cell.
Ctrl+] Select the cells with formulas that directly reference the active cell.
Ctrl+} Select the cells with formulas that directly or indirectly reference the active cell.
Ctrl+A Select the rectangular area that includes every cell adjacent to the active cell.
Press Ctrl+A again to select the entire worksheet.B


Moving the Active Cell in a Selection

Enter Move the active cell down rows and left-to-right across columns.
Shift+Enter Move the active cell up rows and right-to-left across columns.
Tab Move the active cell left-to-right across columns and down rows.
Shift+Tab Move the active cell right-to-left across columns and up rows.
Ctrl+. Move the active cell clockwise from corner to corner.
Ctrl+Alt+right arrow Move the active cell to the next noncontiguous selection to the right.
Ctrl+Alt+left arrow Move the active cell to the next noncontiguous selection to the left.


Editing a Worksheet

F2 Edit the active cell.
Shift+F2 Insert or edit a comment in the active cell.
Alt+= Enter an AutoSum formula into the current cell.
Alt+Enter Insert a carriage return in a cell formatted with wrapped text.
Ctrl+Enter Fill the selected cells with the contents of the Formula Bar.
Ctrl+Shift+Enter Enter the contents of the Formula Bar into the current cell as an array formula.
Ctrl+Shift+U Toggle the expanded version of the Formula Bar on and off.
Ctrl+` Toggle the worksheet between showing formulas and cell values.
Ctrl++ Insert an entire row or column before the currently selected row or column.
Ctrl+– Delete the currently selected row or column.
Ctrl+; Insert the current date.
Ctrl+: Insert the current time.
Ctrl+’ Copy the contents from the cell directly above the current cell.
Ctrl+” Copy the value of the cell directly above the current cell.
Ctrl+< Copy the contents from the cell directly above the current cell and adjust cell references.
Ctrl+> Copy the contents from the cell directly to the left of the current cell and adjust cell references.
Ctrl+A Open the Function Arguments for the current function (place the cursor to the right of the function name before pressing Ctrl+A).
Ctrl+Shift+A Insert a function’s arguments into the current cell (place the cursor to the right of the function name before pressing Ctrl+Shift+A).
Ctrl+D Fill the contents and formatting of the topmost cell in the current vertical selection down to the rest of the cells in the selection.
Ctrl+R Fill the contents and formatting of the leftmost cell in the current horizontal selection right to the rest of the cells in the selection.
Ctrl+T Open the Create Table dialog box.
F3 Open the Paste Names dialog box.
Shift+F3 Open the Insert Function dialog box.
Ctrl+Shift+F3 Open the Create Names from Selection dialog box.
Shift+F11 Insert a new worksheet.
F11 Insert a new chart sheet and create a chart from the current selection.


Formatting Text

Ctrl+1 Open the Format Cells dialog box with the most recently used tab displayed.
Ctrl+5 Apply strikethrough to the current selection.
Ctrl+6 Toggle objects on and off.
Ctrl+8 Toggle outlining symbols on and off.
Ctrl+9 Hide the row or rows containing the current selection.
Ctrl+( Unhide any rows that lie in the current selection.
Ctrl+0 Hide the column or columns containing the current selection.
Ctrl+) Unhide any columns that lie within the current selection.
Ctrl+& Apply an outline border to the selection.
Ctrl+_ Remove an outline border from the selection.
Alt+’ Open the Style dialog box.
Alt+Shift+right arrow Group the selected rows or columns for an outline.
Alt+Shift+left arrow Ungroup the selected rows or columns for an outline.
Ctrl+Shift+F Open the Format Cells dialog box with the Font tab displayed.
Ctrl+Shift+D Apply double underline to the current selection.
Ctrl+5 Apply strikethrough to the current selection.
Ctrl+~ Apply the General format to the current selection.
Ctrl+! Apply the Number format (two decimal places; using thousands separator) to the current selection.
Ctrl+$ Apply the Currency format (two decimal places; using dollar sign; negative numbers surrounded by parentheses) to the current selection.
Ctrl+% Apply the Percentage format (zero decimal places) to the current selection.
Ctrl+^ Apply the Scientific format (two decimal places) to the current selection.
Ctrl+# Apply the Date format (d-mmm-yy) to the current selection.
Ctrl+@ Apply the Time format (h:mm AM/PM) to the current selection.


Working with Workbooks and Windows

F9 Recalculate all open workbooks.
Shift+F9 Recalculate the active worksheet.
Ctrl+Alt+Shift+F9 Recalculate all open workbooks, even formulas that are unchanged since the previous calculation.
Ctrl+F9 Minimize the current window.
Ctrl+F5 Restore the current window.

Sunday, March 29, 2009

Word 2007 Keyboard Shortcuts

Using Word 2007 Keyboard Shortcuts will help us to use keyboard efficiently when we are typing. Nothing slows down a typing session like having to constantly move our hand over to the mouse to navigate a document, select an object, or run a command. Not only slows us down, it is also dangerous. There many keyboard shortcut for Word 2007. In this post, I have listed those shortcuts.

Navigating a Document

Ctrl+Right arrow Move to the next word.
Ctrl+Left arrow Move to the previous word.
End Move to the end of the current line.
Home Move to the start of the current line.
Ctrl+Down arrow Move to the start of the next paragraph.
Ctrl+Up arrow Move to the start of the previous paragraph.
Ctrl+Alt+Page Down Move to the end of the window.
Ctrl+Alt+Page Up Move to the start of the window.
Ctrl+End Move to the end of the document.
Ctrl+Home Move to the start of the document.
Ctrl+Alt+Home Display the Browse by Object window.
Ctrl+Page Down Move to the next object (based on your selection in the Browse by Object window).
Ctrl+Page Up Move to the previous object (based on your selection in the Browse by Object window).
Shift+F5 or Ctrl+Alt+Z Cycle through the four most recently edited locations in the current document.
Ctrl+Shift+F5 Open the Bookmark dialog box.


Selecting Text

Shift+navigation key Move the cursor as dictated by the navigation key (see “Navigating a Document,” above) and also extend the current selection to that point.
Ctrl+A Select the entire document.
F8 Expand the selection to the current word, sentence, paragraph, and then document.
Shift+F8 Collapse the selection to the current paragraph, sentence, and then word.
F8, character Expand the selection from the current cursor position to the next instance of character (this is case-sensitive).
Esc Exit Extend mode (which is activated by pressing F8 or Shift+F8).


Editing Text

Ctrl+Backspace Delete from the current cursor position to the beginning of the word.
Ctrl+Delete Delete from the current cursor position to the end of the word.
Shift+Home, Delete Delete from the current cursor position to the beginning of the line.
Shift+End, Delete Delete from the current cursor position to the end of the line.
Ctrl+Shift+Down arrow, Delete Delete from the current cursor position to the end of the paragraph.
Ctrl+Shift+Up arrow, Delete Delete from the current cursor position to the beginning of the paragraph.
Alt+Shift+Down arrow Move the current paragraph down by one paragraph.
Alt+Shift+Up arrow Move the current paragraph up by one paragraph.
F2 Move the selected text (place the cursor in the new position, and then press Enter).
Shift+F2 Copy the selected text (place the cursor in the new position, and then press Enter).
Ctrl+Alt+Y Repeat the most recent Find.
Ctrl+G or F5 Open the Find and Replace dialog box with the Go To tab displayed.
Alt+F3 Open the Create New Building Block dialog box.
Ctrl+F3 Cut the selected text to the Spike.
Ctrl+Shift+F3 Paste the text that has been cut to the Spike.
Ctrl+Alt+M Insert a comment.
Ctrl+Shift+E Toggle Track Changes on and off.
Alt+Shift+C Close the Reviewing Pane.
Alt+Shift+I Mark the selected text as a citation.
Alt+Shift+O Mark the selected text as a table of contents entry.
Alt+Shift+X Mark the selected text as an index entry.
Alt+Ctrl+F Insert a footnote for the selected text.
Alt+Ctrl+D Insert an endnote for the selected text.
Ctrl+Shift+G Open the Word Count dialog box.


Formatting Text

Shift+F1 Display the Reveal Formatting pane.
Shift+F3 Cycle the case of the current word or selection through UPPERCASE, lowercase, and Title Case.
Ctrl+Shift+A Apply uppercase to the selected text.
Ctrl+Shift+D Apply double underline to the selected text.
Ctrl+Shift+H Apply Hidden formatting to the selected text.
Ctrl+Shift+K Apply small caps to the selected text.
Ctrl+Shift+W Underline each word in the selected text.
Ctrl+= Apply subscript to the selected text.
Ctrl++ Apply superscript to the selected text.
Ctrl+Shift+Q Apply the Symbol font to the selected text.
Ctrl+> Apply the next highest font size to the selected text.
Ctrl+] Grow the font size of the selected text by one point.
Ctrl+< Apply the next lowest font size to the selected text.
Ctrl+[ Shrink the font size of the selected text by one point.
Ctrl+D or Ctrl+Shift+F Display the Font dialog box with Font selected.
Ctrl+Shift+P Display the Font dialog box with Size selected.
Ctrl+Shift+N Apply the Normal style to the selected text.
Alt+Ctrl+1 Apply the Heading 1 style to the selected text.
Alt+Ctrl+2 Apply the Heading 2 style to the selected text.
Alt+Ctrl+3 Apply the Heading 3 style to the selected text.
Ctrl+Shift+S Display the Apply Styles task pane.
Ctrl+Alt+Shift+S Display the Styles task pane.
Ctrl+L Apply Align Left to the selected text.
Ctrl+E Apply Center to the selected text.
Ctrl+R Apply Align Right to the selected text.
Ctrl+J Apply Justify to the selected text.
Ctrl+T Increase the hanging indent of the selected text.
Ctrl+Shift+T Decrease the hanging indent of the selected text.
Ctrl+M Increase the indent of the selected text.
Ctrl+Shift+M Decrease the indent of the selected text.
Ctrl+Shift+L Apply bullets to the selected text.
Ctrl+0 Add or remove one line space prior to the current paragraph.
Ctrl+1 Set the paragraph line spacing to 1 for the selected text.
Ctrl+5 Set the paragraph line spacing to 1.5 for the selected text.
Ctrl+2 Set the paragraph line spacing to 2 for the selected text.
Ctrl+* Show/Hide ¶ (formatting symbols).
Ctrl+Space or Ctrl+Shift+Z Clear the character formatting of the selected text.
Ctrl+Q Clear the paragraph formatting of the selected text.


Creating Borders

---+Enter Create a thin border.
___+Enter Create a thick border.
===+Enter Create a double border.
###+Enter Create a triple border (two thin, one thick).
~~~+Enter Create a wavy border.
***+Enter Create a dotted border.


Inserting Symbols

Shift+Enter Insert a line break.
Ctrl+Enter Insert a page break.
Ctrl+Shift+Enter Insert a column break.
Ctrl+Alt+- (numeric keypad) Insert an em dash (—).
Ctrl+- (numeric keypad) Insert an en dash (–).
Ctrl+- Insert an optional hyphen.
Ctrl+Shift+- Insert a nonbreaking hyphen.
Ctrl+Shift+Spacebar Insert a nonbreaking space.
Ctrl+Alt+C Insert a copyright symbol (©).
Ctrl+Alt+E Insert a euro symbol (€).
Ctrl+Alt+R Insert a registered trademark symbol (®).
Ctrl+Alt+T Insert a trademark symbol (™).
Ctrl+Alt+. (period) Insert an ellipsis (…).
Ctrl+Alt+Shift+? Insert an inverted question mark (¿).
Ctrl+Alt+Shift+! Insert an inverted exclamation point (¡).
Ctrl+`,` Insert a single opening quotation mark.
Ctrl+’,’ Insert a single closing quotation mark.
Ctrl+`,Shift+` Insert a double opening quotation mark.
Ctrl+’, Shift+’ Insert a double closing quotation mark.
Ctrl+/, C Insert a cents sign (¢).
Ctrl+@, Spacebar Insert a degrees symbol (°).


Changing the View

Ctrl+Alt+N Switch to Draft view.
Ctrl+Alt+O Switch to Outline view.
Ctrl+Alt+P Switch to Print Layout view.
Ctrl+Alt+I Switch between the current view and Print Preview.
Ctrl+Alt+S Display the split bar for the current document window (use the up and down arrow keys to position the split bar and then press Enter).
Alt+Shift+C Remove the split bar from the current document.


Working in Outline View

Alt+Shift+Left arrow Promote the current paragraph.
Alt+Shift+Right arrow Demote the current paragraph.
Ctrl+Shift+N Demote the current paragraph to body text.
Alt+Shift+Up arrow Move the selected text up.
Alt+Shift+Down arrow Move the selected text down.
Alt+Shift+Plus sign Expand the text under a heading.
Alt+Shift+Minus sign Collapse the text under a heading.
Alt+Shift+A Expand or collapse all text or headings.
/ (numeric keypad) Hide or display character formatting.
Alt+Shift+L Show the first line of body text or all body text.
Alt+Shift+1 Show all headings with the Heading 1 style.
Alt+Shift+n Show all headings up to Heading n.
Ctrl+Tab Insert a tab character.


Working with Fields

Alt+Shift+D Insert a DATE field.
Alt+Shift+P Insert a PAGE field.
Alt+Shift+T Insert a TIME field.
Ctrl+Alt+L Insert a LISTNUM field.
F9 Update the selected field or fields.
Ctrl+F9 Begin a new field.
Shift+F9 Display the code for the selected field.
Alt+F9 Display the codes for all the document’s fields.


Saturday, March 14, 2009

Office 2007 keyboard shortcut

Pivoting our arm to move from keyboard to mouse and back again is fraught with peril and can cause the painful malady known as mouse elbow. It helps to know how to use the keyboard to perform many everyday chores such as navigating and editing text, selecting data, applying formatting, working with documents and windows, and running program commands. Keyboard shortcut tricks will help us to keep our hands on the keyboard as much as possible.


Office 2007 is loaded with hundreds of keyboard shortcut tricks that we can take advantage of. These tricks will help us to keep our hands on the keyboard as much as possible.


Here's some general Office 2007 keyboard shortcut:



Press To
Ctrl+F1 Hide or show the Ribbon (the tabs remain in view).
Alt+F Display the Office menu.
Alt or F10 Move the focus to the active tab. This also displays the KeyTips over the tabs. (Press a KeyTip character to display the associated tab.)
Alt, left arrow Select the next tab.
Alt, right arrow Select the previous tab.
Alt, Tab Select the next command in the active tab.
Alt, Shift+Tab Select the previous command in the active tab.
Spacebar or Enter Display the selected gallery or menu.
Ctrl+C Copy the current selection to the Clipboard.
Ctrl+X Cut the current selection to the Clipboard.
Ctrl+V Paste the most recently cut or copied selection from the Clipboard.
Ctrl+Alt+V Open the Paste Special dialog box.
Ctrl+F Open the Find and Replace dialog box with the Find tab displayed.
Ctrl+H Open the Find and Replace dialog box with the Replace tab displayed.
Ctrl+K Open the Insert Hyperlink dialog box.
Ctrl+Y or F4 Redo the most recent action.
Ctrl+Z Undo the most recent action.
Ctrl+Alt+V Copy the formatting of the currently selected text or object.
Ctrl+Shift+V Paste the most recently copied formatting to the selected text or object.
Ctrl+B Apply bold to the selected text.
Ctrl+I Apply italics to the selected text.
Ctrl+U Apply underline to the selected text.
Ctrl+N Create a new document.
Ctrl+O or Ctrl+F12 Display the Open dialog box.
Ctrl+P Print the current document.
Ctrl+S Save the current document.
Ctrl+F2 Switch between the current view and Print Preview.
Ctrl+F4 Close the current document.
Ctrl+F6 Switch to the next open window.
Ctrl+Shift+F6 Switch to the previous open window.
Ctrl+F10 Maximize the current document window; restore a maximized document window.
F12 Display the Save As dialog box.
F1 Get context-sensitive Help.
F6 Move the focus forward through the available window sections: the current document, the status bar, the Ribbon, open task panes, non-modal dialog boxes (such as Find and Replace), and so on.
Shift+F6 Move the focus backward through the available window sections: the current document, the status bar, the Ribbon, open task panes, non-modal dialog boxes, and so on.
F7 Run the spelling checker.
Alt+F4 Exit the application.
Alt+F8 Display the Macros dialog box.
Alt+Shift+F10 Display the menu associated with a smart tag.
Alt+F11 Switch between the Visual Basic Editor and the application.



These general Office 2007 keyboard shortcuts work on all of Office 2007 programs such as word, excell, powerpoint, etc.


Thursday, February 26, 2009

How to Make a blog on Blogspot

On this section, we will talk about how to make a blog on Blogspot (a.k.a Blogger). Before we start, I’ll try to review a little about blog. Blog (abbreviation from Web log) is sites which more dominant in private characteristic. This means, most of the content will be affected (realize or not) by the characteristic of the Blogger user himself. Blog was made by the designers of the blog provider in order to work automatically and easily to be operated on, even if we don't know the programming language to make website.

logo blog Blogger (Blogspot) is Google’s free features to makes a blog. Blogger is one kind from a lot of platforms which we can use to make a blog. Some other blog provider which famous nowadays, are wordpress.com, wordpress.org, or blogsome. On this article will talk about how to make an account or sign-up on Blogger or Blogspot. To make an account or sign-up on Blogger we must already have e-mail account.

Note:
Because Blogger (Blogspot) is Google’s free features, it's better if we use gmail account.


To make an account or sign-up on Blogger, Follow this instructions:


Go to blogger on http://www.blogspot.com (or you can click on the address). You'll see the page like on the picture below.
How to Make a blog on Blogspot - blogger Start
  1. Language; we can choose our blog language here. On this session, I'm using English (UK). If you prefer to use other language, you can choose one in the language dropdown menu.
  2. 3 easy steps to creating blogger account; those are the steps we'll use on this section.
  3. Sign in to use blogger; if you already have blogger account, sign in here.

Click an arrow sign, inscribed with “CREATE YOUR BLOG NOW”. Then you'll see the
blogger sign-up form (Create account form)page like on the picture below.
blogger Form

Fill the blogger sign-up form by following this guidance:
  • Email Address; Fill it with our email address, or we can create an email account then, if we don’t have it. [Note: The new Blogger requires a Google Account to access your blogs.]
  • Enter a Password; Fill it with password that we easy to remember
  • Retype Password; Re-write our password again here
  • Display Name; Name that we want to be displayed in our posts
  • Word Verivication; Fill it with alphabet that shown on the image
  • Acceptance of Term; Click on the check box "I Accept the Terms of Service", it means we agree to follow the rules on blogger "Terms of Service". If you read the rules first, click on “Terms of Service” link.

After finishing to fill up all necessary field, click the arrow inscribed with “CONTINUE”. Then you'll see the page like on the picture below.
Name your blog

Fill the blogger naming form by following this guidance:
  • Blog Title; Name of our blog, we can make title for our blog here, example "my blog", we can change it if we need.
  • Blog Address (URL); It’s our blog’s address. Ex: if we type "myblog", so our blog address is http://myblog.blogspot.com. Click on "Check Availability" to check if the address were used. If it’s not available, it means we have to looking for other blog address and check the availability again. If it available, it means we can use this address for our blog.
  • Advance Setup; Don’t have to pay attention on it yet, we can learn it later.

After finishing to fill up all necessary field, click the arrow inscribed with “CONTINUE”. Then you'll see the page like on the picture below.
Blogger Template
Those are 12 Blogger ready to use templates. Choose one template you like (You can change it later, if you want).

Click the arrow inscribed with “CONTINUE”.

Wait a moment. Then we'll see the page like on the picture below.
Your blog has been created

That's it, now we have a blog on the blogger. We can start to use the new blog by write down (Start Posting) articles. Feel free to fill up your blog with everything you want (as long it's not violating blogger Terms of Service).

Note: For one account, we can have more than one blog.

Monday, February 23, 2009

Vista Search Box

Vista Search box allows you to search your entire computer for files, folders, or programs. To use the Search box, open the Start menu, type your search text. Search results are displayed in the left pane of the Start menu. Clicking an item in the results list opens that item. To clear the search results and return to normal view, click the Clear button to the right of the Search box or press the Esc key.

Note:
Because the Search box is the only text entry field on the Start menu, you don’t need to click in the Search box before you begin typing. Just type your search text.


Computer searches are performed by Windows Search Service. Windows Search Service searches the entire computer using the search text you’ve specified. The search proceeds on several levels:
  • Matches the search text to words that appear in the title of any program, file, or folder and then returns any matches found.
  • Matches the properties of programs, files, and folders as well as the contents of textbased documents.
  • Looks in the Favorites and History folders for matches.

Because Windows Search Service indexes content and caches properties as part of its normal processes, results typically are returned quickly. You can configure the types of items searched in the Start Menu Properties dialog box.

Windows Vista can perform several other types of searches as well:

  1. Local Folder Search; When you open a folder, you’ll find a Search text box in the upperright corner of the Windows Explorer window. By default, typing search text in this text box and pressing Enter performs localized searches of the currently open folder and its subfolders. Unlike the Search box on the Start menu, you must click in this Search text box prior to entering your search text. You can use the Search In list to specify alternative search locations.
  2. Internet Search; Click the Options button to the right of the Search text box, and then select the Search The Internet option. Search The Internet uses the computer’s default search provider to search the Internet using the search text you’ve provided. The default search provider is MSN Search. You can set the default search provider using the Internet Options utility in Control Panel.

Windows Vista How To: Customize the Start Menu 02

This is the 2nd part of customizing windows vista start menu, for the 1st part read on Windows Vista How To: Customize the Start menu 01

Note:
Some of the following steps do not apply if you're using the Classic Start menu.


Vista Taskbar and Start Menu Properties

Vista Customize Start Menu

Customize the Right Pane of the Start Menu
You can add or remove items, such as Computer, Control Panel, and Pictures, that appear on the right side of the Start menu. You can also change some items so that they appear as links or menus. To Customize the Right Pane of the Start Menu follow these steps:
  1. Open Taskbar and Start Menu Properties by clicking the Start button , clicking Control Panel, clicking Appearance and Personalization, and then clicking Taskbar and Start Menu.
  2. Click the Start Menu tab, and then click Customize.
  3. In the Customize Start Menu dialog box, select the options in the list that you want, and then click OK.
  4. Finish

Restore Start Menu Default Settings
To restore the Start menu to its original default settings, follow these steps:
  1. Open Taskbar and Start Menu Properties by clicking the Start button , clicking Control Panel, clicking Appearance and Personalization, and then clicking Taskbar and Start Menu.
  2. Click the Start Menu tab, and then click Customize.
  3. In the Customize Start Menu dialog box, click Use Default Settings, and then click OK.
  4. Finish

Add the Run command to the Start menu
To add the Run command to the Start menu, follow these steps:
  1. Open Taskbar and Start Menu Properties by clicking the Start button , clicking Control Panel, clicking Appearance and Personalization, and then clicking Taskbar and Start Menu.
  2. Click the Start Menu tab, and then click Customize.
  3. In the Customize Start Menu dialog box, scroll through the list of options to find the Run command check box, select it, and then click OK.
  4. Finish

Windows Vista How To: Customize the Start menu 01


Windows Vista Start Menu would need a bunch of new customization features. Organizing the Start menu can make it easier to find your favorite programs and folders.
Note:
Some of the following steps do not apply if you're using the Classic Start menu.



Vista Start Menu

Pin a program icon to the Start menu

If you use a program regularly, you can create a shortcut to it by pinning the program icon to the Start menu. Pinned program icons appear on the left side of the Start menu, above the horizontal line.
  • Right-click the program icon you want to pin to the Start menu, and then click Pin to Start Menu.
  • To unpin a program icon, right-click it, and then click Unpin from Start Menu.
  • To change the order of a pinned item, drag the program icon to a new position in the list.


Remove a Program Icon from the Start menu
Removing a program icon from the Start menu doesn't remove it from the All Programs list or uninstall the program. To
Remove a Program Icon follow these steps:
  1. Click the Start button .
  2. Right-click the program icon you want to remove from the Start menu, and then click Remove from this list.
  3. Finish

Move the Start button
The Start button is located on the taskbar (in the bottom of the screen). To change the location to one of the four edges of the desktop, follow these steps:
  1. Right-click an empty space on the taskbar. If Lock the Taskbar has a check mark beside it, click it to remove the check mark.
  2. Click an empty space on the taskbar, and then hold down the mouse button as you drag the taskbar to one of the four edges of the desktop. When the taskbar is where you want it, release the mouse button.
  3. Lock the taskbar into place, right-click an empty space on the taskbar, and then click Lock the Taskbar so that the check mark reappears.
  4. Finish

Clear recent items from the Start menu
Clearing the Recent Items list does not delete the items from your computer. To Clear recent items from the Start menu, follow this steps:
  1. Click the Start button .
  2. Right-click Recent Items, and then click Clear Recent Items List.

Change the Start menu to Classic view
If you like the Classic view, you can change to the Classic view, follow these steps:
  1. Open Taskbar and Start Menu Properties by clicking the Start button , clicking Control Panel, clicking Appearance and Personalization, and then clicking Taskbar and Start Menu. Vista Taskbar and Start Menu Properties
  2. Click the Start Menu tab, click Classic Start menu, and then click OK.
  3. Finish

Adjust the number of shortcuts for frequently used programs
Windows displays shortcuts on the Start menu for the programs you use most frequently. To change the number of program shortcuts displayed, follow these steps:
  1. Open Taskbar and Start Menu Properties by clicking the Start button , clicking Control Panel, clicking Appearance and Personalization, and then clicking Taskbar and Start Menu.
  2. Click the Start Menu tab, and then click Customize.
  3. In the Customize Start Menu dialog box, in the Number of recent programs to display box, enter the number of programs you want to display on the Start menu, and then click OK.Vista Customize Start Menu
  4. Finish


Sunday, February 22, 2009

Vista Start Menu 02

The right pane on the Vista Start menu provides access to commonly used folders and features. The right pane also provides the Power button (puts the computer in sleep mode or shuts it down, depending on the system configuration), the Lock button (locks the computer), and the Options button (displays the following options: Switch User, Log Off, Lock, Restart, Sleep, and Shut Down).

To understand these changes, let’s review the option buttons provided in the right pane. From top to bottom, the option buttons are as follows:


Vista Start Menu

Current user; The name of the currently logged on user. Clicking this option opens the user’s personal folder in Windows Explorer.

Documents; Opens the %UserProfile%\Documents folder in Windows Explorer.

Pictures; Opens the %UserProfile%\Pictures folder in Windows Explorer.

Music; Opens the %UserProfile%\Music folder in Windows Explorer.

Games; Opens the %ProgramFiles\Microsoft Games folder in Windows Explorer. The Games item is not listed in the Start menu for business editions of Windows Vista.

Tip:
In Windows Vista Home Premium, games available include Chess Titans, Hearts, Minesweeper, Solitaire, FreeCell, Mahjong Titans, Purble Place, and Spider Solitaire. Windows Vista Home Basic has all the games except Chess Titans and Mahjong Titans. Saved data for games is stored in the %UserProfile%\Saved Games folder. Click the Options menu to configure the Set Up Game Updates And Options dialog box options to keep games up to date automatically, clear history details on the most recently played games, and unhide games. Group Policy can be used to control the availability of the Games option.



Search; Opens a local computer search in Windows Explorer. Use the Search In list to select or specify an alternative search location.

Recent Items; A menu view that lists recently opened files.

Computer; Opens a window where you can access hard disk drives and devices with removable storage.

Tip
The Computer window is the fastest way to open Windows Explorer and access a computer’s disks. In the Computer window, double-click a disk to browse its contents. By default, the Search box in Windows Explorer performs localized searches of the currently open folder and its subfolders.



Network; Opens a window where you can access the computers and devices on your network. Also provides quick access to Network Center and the Connect To A Network wizard.

Connect To; Displays the Connect To A Network dialog box for connecting to wireless networks.

Control Panel; Opens Control Panel, which provides access to system configuration and management tools.

Default Programs; Displays the Default Programs window, which lets you choose the programs that Windows Vista uses by default for documents, pictures, and more. You can also associate file types with programs and configure AutoPlay settings.

Help And Support; Displays the Windows Help And Support console, which you can use to browse or search help topics.

Several additional options can be added to the right pane, including:

Administrative Tools; Clicking this option displays a list of system administration tools. To display the Administrative Tools option on the Start menu, right-click the Start button, and then select Properties. In the Taskbar And Start Menu Properties dialog box, click the Customize button on the Start Menu tab. In the Customize Start Menu dialog box, scroll to the end of the available options. For System Administration Tools, select Display On The All Programs Menu And The Start Menu.

Printers; Opens a Printers window, which lists and provides access to currently configured printers.

Run; Displays the Run dialog box, which can be used to run commands. To display the Run option, right-click the Start button, and then select Properties. In the Taskbar And Start Menu Properties dialog box, click the Customize button on the Start Menu tab. In the Customize Start Menu dialog box, scroll down and then select the Run Command check box.

Note;
Because the Search box can be used to open and run commands, you might not need to use the Run option. For example, to open a Microsoft Management Console, you can click the Start button, type MMC, and then press Enter. You don’t need to click in the Search box before you begin typing. Pressing Enter opens the first item in the results list. If for some reason MMC isn’t the first item, you would need to click MMC in the results list rather than pressing Enter.



Vista Start Menu 01

Clicking the Start button on the taskbar displays the Start menu. You can also display the Start menu by pressing the Windows logo key. As with Windows XP, the Start menu in Windows Vista has two views:

  1. The Start menu (or Simple Start menu, as it is sometimes referred to) is the default view which provides easy access to programs, folders, and search.
  2. The Classic Start menu is an alternative view which provides the look and functionality of the Start menu in Windows 2000 and earlier versions of Windows.

The Start menu has three key areas:


Vista Start Menu

Programs list; Displays recently used programs and programs that have been pinned to the Start menu. By default, Internet Explorer and Windows Mail (previously called Microsoft Outlook Express) are pinned to the Start menu, and up to eight recent programs are displayed as well.

Search box; Allows you to search your entire computer for files, folders, or programs. To use the Search box, open the Start menu, type your search text, and then press Enter. The Clear button appears when you type your search text. Click the Clear button to clear the search results and return to the normal view.

Right pane; Provides access to commonly used folders and features. The right pane also provides the Power button (puts the computer in sleep mode or shuts it down, depending on the system configuration), the Lock button (locks the computer), and the Options button (displays the following options: Switch User, Log Off, Lock, Shut Down, and Restart). For more read on Vista Start Menu 02

Managing Programs List on the Start Menu

The left pane on the Start menu displays recently used programs and programs that have been pinned to the Start menu. By default, Internet Explorer and Windows Mail (previously called Outlook Express) are pinned to the Start menu, and up to eight recent programs are displayed as well.

When you are working with the standard Start menu, you can modify the programs list in several ways. To modify the default settings, right-click the Start button, and then select Properties. In the Taskbar And Start Menu Properties dialog box, the Start Menu tab is selected by default. Click Customize, and then set the Number Of Recent Programs To Display option as appropriate. By configuring the Show On Start Menu options, you can stop displaying links for the Web browser and mail program or configure a different browser and mail program to which you want to link.

Tip: If you want to provide quick access to programs, you can pin those programs to the Start menu. To do this, click the Start button, navigate to the program you want to be able to quickly access, and then right-click the program name. Select Pin To Start Menu to add the program to the Start Menu.