Wednesday, November 13, 2013

microsoft excel keyboard shortkeys

Microsoft Excel shortcut keys


Shortcut Description
F2 Edit the selected cell.
F3 After a name has been created F3 will paste names.
F4 Repeat last action. For example, if you changed the color of text in another cell pressing F4 will change the text in cell to the same color.
F5 Go to a specific cell. For example, C6.
F7 Spell check selected text or document.
F11 Create chart from selected data.
Ctrl + Shift + ; Enter the current time.
Ctrl + ; Enter the current date.
Alt + Shift + F1 Insert New Worksheet.
Alt + Enter While typing text in a cell pressing Alt + Enter will move to the next line allowing for multiple lines of text in one cell.
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 + 1 Change the format of selected cells.
Ctrl + 5 Strikethrough highlighted selection.
Ctrl + P Bring up the print dialog box to begin printing.
Ctrl + Z Undo last action.
Ctrl + F3 Open Excel Name Manager.
Ctrl + F9 Minimize current window.
Ctrl + F10 Maximize currently selected window.
Ctrl + F6 Switch between open workbooks or 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.
Alt + = Create a formula to sum all of the above cells
Ctrl + ' Insert the value of the above cell into cell currently selected.
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 Select entire column.
Shift + Space Select entire row.
Ctrl + - Delete the slected column or row.
Ctrl + Shift + = Insert a new column or row.
Ctrl + Home Move to cell A1.
Ctrl + ~ Switch between showing Excel formulas or their values in cells.

software tips: Ms-words-keyboard-shortcuts

software tips: Ms-words-keyboard-shortcuts: Microsoft Word shortcut keys Shortcut Description Ctrl + 0 Adds or removes 6pts of spacing befor...

Ms-words-keyboard-shortcuts

Microsoft Word shortcut keys


Shortcut Description
Ctrl + 0 Adds or removes 6pts of spacing before a paragraph.
Ctrl + A Select all contents of the page.
Ctrl + B Bold highlighted selection.
Ctrl + C Copy selected text.
Ctrl + D Open the font preferences window.
Ctrl + E Aligns the line or selected text to the center of the screen.
Ctrl + F Open find box.
Ctrl + I Italic highlighted selection.
Ctrl + J Aligns the selected text or line to justify the screen.
Ctrl + K Insert link.
Ctrl + L Aligns the line or selected text to the left of the screen.
Ctrl + M Indent the paragraph.
Ctrl + P Open the print window.
Ctrl + R Aligns the line or selected text to the right of the screen.
Ctrl + T Create a hanging indent.
Ctrl + U Underline highlighted selection.
Ctrl + V Paste.
Ctrl + X Cut selected text.
Ctrl + Y Redo the last action performed.
Ctrl + Z Undo last action.
Ctrl + Shift + L Quickly create a bullet point.
Ctrl + Shift + F Change the font.
Ctrl + Shift + > Increase selected font +1pts up to 12pt and then increases font +2pts.
Ctrl + ] Increase selected font +1pts.
Ctrl + Shift + < Decrease selected font -1pts if 12pt or lower, if above 12 decreases font by +2pt.
Ctrl + [ Decrease selected font -1pts.
Ctrl + / + c Insert a cent sign (¢).
Ctrl + ' + Insert a character with an accent (grave) mark, where is the character you want. For example, if you wanted an accented รจ you would use Ctrl + ' + e as your shortcut key. To reverse the accent mark use the opposite accent mark, often on the tilde key.
Ctrl + Shift + * View or hide non printing characters.
Ctrl + Moves one word to the left.
Ctrl + Moves one word to the right.
Ctrl + Moves to the beginning of the line or paragraph.
Ctrl + 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.
Alt + Ctrl + F2 Open new document.
Ctrl + F1 Open the Task Pane.
Ctrl + F2 Display the print preview.
Ctrl + Shift + > Increases the highlighted text size by one.
Ctrl + Shift + < Decreases the highlighted text size by one.
Ctrl + Shift + F6 Opens to another open Microsoft Word document.
Ctrl + Shift + F12 Prints the document.
F1 Open Help.
F4 Repeat the last action performed (Word 2000+)
F5 Open the find, replace, and go to window in Microsoft Word.
F7 Spellcheck and grammar check selected text or document.
F12 Save as.
Shift + F3 Change the text in Microsoft Word from uppercase to lowercase or a capital letter at the beginning of every word.
Shift + F7 Runs a Thesaurus check on the word highlighted.
Shift + F12 Save.
Shift + Enter Create a soft break instead of a new paragraph.
Shift + Insert Paste.
Shift + Alt + D Insert the current date.
Shift + Alt + T Insert the current time.
In addition to the above shortcut keys users can also use their mouse as a method of quickly do something commonly performed. Below some are examples of mouse shortcuts.
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.

Sunday, November 10, 2013

Autocad keyboard shortcuts




SHORTCUT

COMMAND

COMMENT

A

ARC

Draw an arc

AL

ALIGN

Align an object with another

AP

APPLOAD

Opens application load dialogue box

AR

ARRAY

Opens array dialogue box

AUDIT

AUDIT

Audit drawing for errors

AV

DSVIEWER

Opens ariel view of drawing

B

BLOCK

Opens block dialogue box

C

CIRCLE

Draw a circle

CO

COPY

Copy an object

CHA

CHAMFER

Chamfer between 2 non-parallel lines

COL

COLOR

Opens select color dialogue box

CUI


Opens customise user interface dialogue

D

DIMSTYLE

Opens dimstyle manager

DC

ADCENTER

Opens designcenter

DI

DIST

Check a distance

DIV

DIVIDE

Inserts point node a set division

DO

DONUT

Draw a solid donut shape

DV

DVIEW

Perspective view

E

ERASE

Erase a selection

EX

EXTEND

Extend a selection

F

FILLET

Draw an arc between 2 intersecting lines

FI

FILTER

Opens filter dialogue box

FLATTEN

FLATTEN

Converts 3D to 2D

G

GROUP

Launches the group dialogue box

H

HATCH

Opens hatch and gradient dialogue box

I

INSERT

Insert a block

IM

IMAGE

Launches image manager

J

JOIN

Joins 2 objects to form single object



JPGOUT

JPGOUT

Creates a JPEG file of current drawing

L

LINE

Draw a line

LA

LAYER

Opens layer manager

LE

QLEADER

Draw a leader line (may need to adjust settings)

LEAD

LEADER

Leader line with annotation

LI or LS

LIST

Display information about objects in a text window

LO

-LAYOUT

Creates a new layout tab

LTS

LTScale

Change the linetype scale

M

MOVE

Move a selection

MA

MATCHPROPERTIES

Match properties of an object

ME

MEASURE

Inserts point node at input distance

O

OFFSET

Offset a selection

OP

OPTIONS

Launches options dialogue box

P

PAN

Pan in drawing

PE

POLYEDIT

Edit a polyline

PL

PLINE

Draw a polyline

PLOT

PLOT

Opens plot/print dialogue box

PO

POINT

Point marker or node - DDPTYPE to change pointstyle

PR

PROPERTIES

Opens properties dialogue box

PRE

PREVIEW

Preview a plot

PU

PURGE

Opens purge dialogue box to remove unused elements

RE

REGEN

Regenerate the display

REC

RECTANG

Draw a rectangle

REN

RENAME

Opens rename dialogue box to rename blocks, layers, etc

RO

ROTATE

Rotate a selection

SP

SPELL

Spell check a selection - ALL to check entire drawing

T

MTEXT

Insert multiline text

TB

TABLE

Opens insert a table dialogue box

TP

TOOLPALETTES

Displays toolpalette

TR

TRIM

Trim a selection

U

UNDO

Undo last command

UN

UNITS

Opens units dialogue box

V

VIEW

Opens view dialogue box

W

WBLOCK

Write a block



WHOHAS

WHOHAS

Displays who has a drawing open

X

EXPLODE

Explode a selection

XR

XREF

Opens x-reference manager

Z

ZOOM

Zoom in display - A=All, E=EXTENTS, W=WINDOW