Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    
1 comment

SOME KYEBOARD SHORT CUT

  


SOMSOME KYEBOARD SHORT CUT

Ctrl + A = Select all Ctrl + B = Bold Ctrl + C = Copy

Ctrl + D = Change character formatting

Ctrl + E = Align center

Ctrl + F = Find Ctrl + G = Go to Ctrl + H = Replace Ctrl + I = Italics Ctrl + J = Justify

Ctrl + K = Insert hyperlink

Ctrl + L = Left align

Ctrl + M = Indent

Ctrl + N = New document Ctrl + O = Open document Ctrl + P = Print

Ctrl + Q = Remove paragraph formatting

Ctrl + R = Right justify

Ctrl + S = Save

Ctrl + T = Create hanging indent (tab)

Ctrl + U = Underline

Ctrl + V = Paste

Ctrl + W = Close document

Ctrl + X = Cut

Ctrl + Y = Redo previously undone action

Ctrl + Z = Undo an action Ctrl + 1 = Single-space lines Ctrl + 2 = Double-space lines Ctrl + 5 = 1.5-line spacing


Ctrl + Left Bracket [ = decrease font size by 1 point Ctrl + Right Bracket ] = increase font size by 1 point Ctrl + Shift + A = selected text to all capital letters Ctrl + Shift + D = double underline to the selected text Ctrl + Shift + E = enable or disable revision tracking Ctrl + Shift + F = open font window

Ctrl + Shift + L = create a bullet point

Ctrl + Shift + * = view or hide non printing characters

Ctrl + Shift + > = increase font size Ctrl + Shift + < = decrease font size Ctrl + ] = increase font size

Ctrl + [ = decrease font size

Ctrl + / + C = insert a cent sign (¢)

Ctrl + Del = delete word right of cursor

Ctrl + Backspace = delete word left of cursor

Ctrl + End = move the cursor to the end of the document Ctrl + Home = Move the cursor to the beginning of the document

Ctrl + Spacebar = Reset highlighted text to the default font

Ctrl + Enter = Insert a page break

Alt + F, A = save the document under a new name

Alt + X = show the Unicode code of a highlighted character 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 Esc = cancel a command


MS Word Short cUts

The below shortcuts will work if you have the function keys on your keyboard.

 


F1 = opens help panel

Shift + F1 = opens reveal formatting panel

Alt + F1 = jumps to the next field

Alt + Shift + F1 = Jumps to the previous field

 

F2 = move text or objects

Ctrl + F2 = open the print window

Alt + Shift + F2 = save your document

Alt + Ctrl + F2 = pop up the open window

 

F3 = Expand an AutoText entry

Alt + F3 = Create an AutoText entry

Shift + F3 = Change the case of selected text Ctrl + F3 = Cut selected text to the Spike Ctrl + Shift + F3 = Insert the contents of the Spike

 

F4 = repeat your last action

Shift + F4 = repeat the last “Find” action Ctrl + F4 = close the current document Alt + F4 = quit Microsoft Word

 

F5 = open “Go To” tab on the Find and Replace window

Shift + F5 = jump the previous edit you made in your document

Ctrl + Shift + F5 = open Bookmark window

 

F6 = Go to the next pane or frame in your Word window

Shift + F6 = Go to the previous pane or frame Ctrl + F6 = Go to the next open document window

Ctrl + Shift + F6 = Go to the previous open document window


F7 =Open the Editor pane and start a spelling and grammar check

Shift + F7 = Open the thesaurus

Alt + F7 = Find the next spelling or grammar error

Alt + Shift + F7 = Open the Translation pane

 

F8 = Enter Word’s selection mode and expand a selection

Shift+F8 = Reduce a selection

Ctrl + Shift + F8 = Selects a column

 

F9: Update a field

Shift+F9: Reveal a field’s code

Ctrl+F9: Insert new Empty Field {} braces

Ctrl+Shift+F9: Unlink a field

Alt+F9: Toggle the display of a field’s code

 

F10: Show key tips

Shift+F10: Display a context menu

Ctrl+F10: Maximize document window Alt+Shift+F10: Display a menu or window for an available selection

 

F11: Jump to the next field in your document Shift+F11: Jump to the previous field in your document

Ctrl+F11: Lock a field so it cannot be edited

Ctrl+Shift+F11: Unlock a field

Alt+Shift+F11: Start the Microsoft Script Editor

 

F12: Open the Save As window Shift+F12: Save your document Ctrl+F12: Open the Open window Ctrl+Shift+F12: Open the Print window

 

Comments

Post a Comment

POPULAR POSTS

essential BAsic excel formulas a quick guide

Image
  Here are some tips for using Excel formulas: All formulas start with an equal sign (=) To refer to a cell, enter the column letter followed by the row number. For example, B2 refers to the cell at the intersection of column B and row 2.           The formula bar shows the formula you enter in a cell. You can see it whenever that cell is selected. Here are some basic Excel formulas you can use for common tasks: 1. SUM Adds a range of numbers. =SUM(A1:A10) 2. AVERAGE Calculates the average of a range of numbers. =AVERAGE(B1:B10) 3. COUNT Counts the number of cells that contain numbers. =COUNT(C1:C10) 4. MAX Finds the maximum value in a range. =MAX(D1:D10) 5. MIN Finds the minimum value in a range. =MIN(E1:E10) 6. IF Performs a logical test and returns one value for TRUE and another for FALSE. =IF(F1 > 10, "Yes", "No") 7. CONCATENATE (or &) Joins two or more strings together. =CONCATENATE(G1, " ", H1) =G1 & " " & H1 8...
Read more

Some important tips to learn MS Word

Image
    Some important tips to learn MS Word   ·       Steps:           Open Word   ·         Click   start   ·         click   program   ·         Click   MS word   Steps:    Find ·         click on edit menu ·         click find ·         Type the text you want to find ·         Click on Find Next button.   Steps: Replace ·           Click on the Edit menu ·         click replace ·         Type the text you want to replace on the first line ·         On the second line, type the text you want to replace on the first line ·         Click on the Replace All button.   Steps: Go to ·           Click on t...
Read more

Insert Serial Numbers in Roman Numerals, Alphabets, and Numbers in Excel

Image
  How to Insert Serial Numbers in Roman Numerals, Alphabets, and Numbers in Exce l To easily generate serial numbers in Roman numerals, alphabets, or numbers, follow these simple formulas in Excel: SL NO in  Roman Numerals: Click on the cell where you want to start the serial number (e.g., A1). Enter the following formula: =ROMAN(ROW(A1)) After entering the formula, drag the fill handle (small square at the bottom-right corner of the cell) down to apply it to additional cells. SL NO in Alphabets Click on the cell where you want the alphabet sequence to begin (e.g., A1). Enter this formula: =CHAR(64 + ROW(A1)) Drag the fill handle down to continue the alphabet sequence.    Sl no in Numbers: Click on the cell where you want to start numbering (e.g., A1). Enter the formula: =ROW(A1) Drag the fill handle down to generate a sequence of numbers. By using these simple formulas, you can quickly generate serial numbers in Roman numerals, alphabets, or numbers across your spre...
Read more

How to find sum of numbers with units in a range in Excel?

Image
  How to find sum of numbers with units in a range in Excel? In Excel, you can use a formula to handle this task. Select a blank cell, and type this formula =SUM(SUBSTITUTE(B1:B7, "kg", "") + 0) into it, and then press  Shift + Ctrl + Enter  keys simultaneously to get the correct result. OR USE THIS  FORMULA  SELECT A BLANK CELL AND TYPE THIS FORMULA=SUM(--LEFT(B1:B7,2)) USE CTL+SHIFT+ENTER . A                                   B APPLE 20KG PEAR 30KG MANGO 10KG BANANA 11KG GRAPES 50KG ORANGE 22KG POTATO 30KG   173 = SUM(--LEFT(B1:B7,2)) USE CTL+SHIFT+ENTER Tip:  in above formula, B1:B7 is the numbers with units you want to sum up, kg is the unit in the data ...
Read more

Rearrange columns in excel sheet using a quick trick

Image
    Rearrange columns in excel sheet using a quick trick     No need to copying, pasting, or dragging , just used a simple trick  Select all the table by pressing CTRL +A, This highlight all the cells in your sheet. Next press  ALT +HSU,  This opens the  sorting dialouge box,. In this dialogue box click on option and selct left to right Now choose the row you want to sort by. you will get a  revised table of data as per your need.   scan
Read more

TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET

Image
  TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET USING A COMAND AND TRICKS             To insert a serial number (SL NO) in an Excel sheet using a command, you can use a simple formula. Here’s how you can do it: Open Excel and navigate to the cell where you want to start your serial numbers (e.g., A1).   Enter the Formula : In cell A1, type 1 to start the numbering. In cell A2, type the formula =A1 + 1 . This will add 1 to the value above.   AutoFill the Series : Click on the small square at the bottom-right corner of cell A2 (the fill handle). Drag it down to fill the cells below with sequential numbers as you desired. 1       =A1+1                 TRICKS   TO INSERT...
Read more