Showing posts with label office. Show all posts
Showing posts with label office. Show all posts

Saturday, 27 September 2014

Powerpoint Tricks And Shortcuts





CommandShortcut

Group objects

Ctrl+Shift+G
Ungroup objectsCtrl+Shift+H
Show or hide gridShift+F9
Show or hide guidesAlt+F9
Change grid or guide settingsCtrl+G
Show AutoShape menu and insert shapeAlt+U -> Ctrl+ENTER
Insert perfect squaresPress shift first, start drawing figure
Move selection in specific directionCtrl+ARROW
ZoomCtrl+mouse wheel
Duplicate selectedshapesCtrl+D
Insert new slideCtrl+M
Draw multiple similar figuresDouble-click corresponding toolbar icon
Repeatlast actionF4
Activate menu barF10
Context menuShift+F10 or Windows special key
Work with presentationsShortcut

Create new presentation

Ctrl+N
Insertnew slideCtrl+M
Duplicate selected slideCtrl+D
Open a presentationsCtrl+O
Close presentationCtrl+W
Print presentationCtrl+P
Save presentationCtrl+S
Quit PowerPointAlt+F4
Find textCtrl+F
Replace textCtrl+H
Repeat the last find actionShift+F4
Insert a hyperlinkCtrl+K
Undo an actionCtrl+Z
Redo or repeat an actionCtrl+Y
Switch to the next paneF6
Switch to the previous paneShift+F6
Cancel an actionESC
Carry out Save As commandF12
Carry out Save commandShift+F12
Carry out Open commandCtrl+F12
Carry out Print commandCtrl+Shift+F12
Display Visual Basic codeAlt+F11
Text operationsShortcut

Delete one word to the left

Ctrl+BACKSPACE
Delete one word to the rightCtrl+DELETE
Cut selected objectCtrl+X
Copy selected objectCtrl+C
Paste cut or copied objectCtrl+V
Move cursor one word to the leftCtrl+LEFT ARROW
Move cursor one word to the rightCtrl+RIGHT ARROW
Changecase letters (toggles through sentence case, lowercase, and uppercase)Shift+F3
Center paragraphCtrl+E
Justify paragraphCtrl+J
Left align paragraphCtrl+L
Right align paragraphCtrl+R
PromoteparagraphAlt+Shift+LEFT ARROW
Demote paragraphAlt+Shift+RIGHT ARROW
Move selected paragraphs upAlt+Shift+UP ARROW
Move selected paragraphs downAlt+Shift+DOWN ARROW
Format font styleCtrl+T
Changefont sizeCtrl+Shift+P
Increasefont sizeCtrl+Shift+>
Decrease font sizeCtrl+Shift+<
Apply bold formattingCtrl+B
Apply an underlineCtrl+U
Apply italic formattingCtrl+I
Apply subscript formattingCtrl+EQUAL SIGN
Apply superscript formattingCtrl+Shift+PLUS SIGN
Remove manual character formattingCtrl+SPACEBAR
Copy formatsCtrl+Shift+C
Paste formatsCtrl+Shift+V
Insert a tab in a table cellCtrl+TAB
Addnew row at the bottom of a tableTAB at the end of the last row
Check spellingF7
Find next misspelling (Automatic Spell Checking enabled)Shift+F7
SelectionShortcut

Select next object (with an object selected)

TAB or Shift+TAB
Select text within selected objectENTER
Select all objectsCtrl+A (in slide pane)
Select all slidesCtrl+A (in slide sorter view)
Select all textCtrl+A (in text field)
Move to the end of a lineEND
Move to the beginning of a lineHOME
Move up one paragraphCtrl+UP ARROW
Move down one paragraphCtrl+DOWN ARROW
Control slide showsShortcut

Start slideshow from current slide

Shift+F5
Slideshow from beginningF5
Perform next animation or advance tonext slideENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, SPACEBAR, or mouse click
Perform previous animation or return toprevious slideP, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE
Go to slide<number>+ENTER
Display a black screen, or return to slide show from black screenB or PERIOD
Display a white screen, or return to the slide show from a white screenW or COMMA
Stop or restartautomatic slide showS or PLUS SIGN
End slide showESC, Ctrl+BREAK, or HYPHEN
Erase on-screen annotationsE
Go to next hidden slideH
Set new timings while rehearsingT
Use original timings while rehearsingO
Use mouse-click to advance while rehearsingM
Return to first slideHOME or both mouse buttons for 2 seconds
Redisplay hidden pointer and/or change the pointer to a penCtrl+P
Redisplay hidden pointer and/or change the pointer to an arrowCtrl+A
Hidepointer and button immediatelyCtrl+H
Hidepointer and button in 15 secondsCtrl+U
Display shortcut menuShift+F10 or right-click or special windows key
Go to first or next hyperlink on slideTAB
Go to last or previous hyperlink on slideShift+TAB
Perform "mouse click" behavior of selected hyperlinkENTER while hyperlink is selected
Perform "mouse over" behavior of selected hyperlinkShift+ENTER while hyperlink is selected
Display list of controlsF1

Friday, 26 September 2014

MS Excel Shortcuts




Excel is useful in the organization of data, including dates, times, percentages and other numbers. In this section, learn shortcuts to better format the cells and their respective data.
WINDOWS
Ctrl + 1
Format cells dialog
Ctrl + b
(or ctrl + 2)
Apply / remove bold
Ctrl + i
(or ctrl + 3)
Apply / remove italic
Ctrl + u
(or ctrl + 4)
Apply / remove underline
Ctrl + 5
Apply / remove strikethrough
Ctrl + Shift + f
Display the Format Cells with Fonts Tab active. Press tab 3x to get to font-size
Alt + ' (apostrophe)
Display the Style dialog box
Number Formats
Ctrl + Shift + $
Apply the Currency format with two decimal places
Ctrl + Shift + ~
Apply the General number format
Ctrl + Shift + %
Apply the Percentage format with no 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 am or pm
Ctrl + Shift + !
Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values
Ctrl + Shift + ^
Apply the Scientific number format with two decimal places
F4
Repeat last formatting action: Apply previously applied Cell Formatting to a different Cell
Apply Borders to Cells
Ctrl + Shift + &
Apply outline border from cell or selection
Ctrl + Shift + _ (underscore)
Remove outline borders from cell or selection
Ctrl + 1, then Ctrl + Arrow Right/Arrow Left
Access border menu in 'Format Cell' dialog. Once border was selected, it will show up directly on the next Ctrl + 1
Alt + t
In Cell Format in 'Border' Dialog Window, set top border
Alt + b
In Cell Format in 'Border' Dialog Window, set bottom border
Alt + l
In Cell Format in 'Border' Dialog Window, set left border
Alt + r
In Cell Format in 'Border' Dialog Window, set right border
Alt + d
In Cell Format in 'Border' Dialog Window, set diagonal and down border
Alt + u
In Cell Format in 'Border' Dialog Window, set diagonal and up border
Align Cells
Alt + h, ar
Align Right
Alt + h, ac
Align Center
Alt + h, al
Align Left

Wednesday, 24 September 2014

Accessing Blocked Websites Without Any Software




Are you fed up with blocked websites at your workplace ? We have a solution for you.

Most of us want to explore internet in our college, school or office, but in that network we have a lot of blocked websites which irritate us a lot.

To overcome those restrictions, we have a small but very useful trick for you.

1. Go to link given below:

http://www.google.com/translate?hl=&sl=en&tl=hi&u=www.winlinware.blogspot.in





2. Change www.winlinware.blogspot.in
 to the website you like to visit and disable safe mode.

.
3. Done!

If you use this trick, you are not sure to protect your privacy, this kind of connection lets you see blacklisted or banned pages but does not hide your 
IP address.