View & work with same worksheet in more that 2 places at a time

you can work with different places in same workbook at a time

Window Menu > New window 

You can see two instances of same workbook

Note : For more easy perfomance, Make workbook window in "Restore Mode" not in "maximize" mode

Switch / Toggle between Excel work books opened

There is a quick method of switching between spreadsheet windows that uses the keyboard. To do this, simply press Ctrl+F6. This will cycle you between your open workbooks. For instance, if you have three workbooks open, and you press Ctrl+F6 three times, you will be back to your original workbook window.

Worksheet Shortcuts - Very useful

 

Action	Key
Moving Forward to next worksheet	Ctrl + pagedown
Moving Backward to next worksheet	Ctrl+ Pageup
Selecting Multiple worksheets- Forward	Ctrl + Shift + pagedown
Selecting Multiple worksheets- Backward	Ctrl + Shift + pageup

 

Excel Shortcuts: Selecting These shortcuts help you to quickly select items in your Excel file in various ways. Shift+Spacebar: Select the current Row Ctrl+Spacebar: Select the current column Ctrl+A: Select All, will select everything on the current worksheet. This is most often used in conjunction with the copy shortcut.

Defining & Deleting Global Names

 Defining a Name

 Names are used so that you can refer to a single cell or a cell range using something meaningful to you. You can define a name using Excel's menus by following these steps:

1. Select the cell or cell range you want the name to represent.
2. Choose Name from the Insert menu, and then Define from the resulting submenu. Excel displays the Define Name dialog box. 
   
3. Replace the suggested name (if any) with the name you want to use for the cell or cell range you selected in step 1.
4. Click on Add. Your name is now defined.
5. Click on OK to close the Define Name dialog box.

The names you define in Excel can be up to 255 characters in length and contain any numbers or letters, as well as the period, backslash, question mark or underscore. Names cannot contain any other special characters, including spaces. In addition, names must start with either a letter, backslash or the underscore.
You can also define a name by using the formula bar. To use this method, follow these steps:

1. Select the cell or cell range you want the name to represent.
2. Click in the area at the very left of the formula bar.
3. Type the name you want to define, pressing Enter when done.

The name is defined and appears in the formula bar area whenever the cell or cells are selected.

Deleting Names

 

There may come a time when you want to delete names you previously defined and used in Excel. To do this, follow these steps:

1. Choose Name from the Insert menu, and then Define from the resulting submenu. Excel displays the Define Name dialog box. :)  It sounds strange to choose Define when you want to delete something, but that is the way Excel is designed.
2. In the list of available names, select the one you want to delete.
3. Click on the Delete button. The name is removed from the list.
4. Repeat steps 2 and 3 for other names you want to delete
5. Click on OK to close the Define Name dialog box.

Give Superb look for your excel sheet

1. Remove Annoying Gridlines from your sheet Click here

2.Remove Page Breaks

Steps
1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult Page Breaks are ticked, Untick it , Click ok Button

3. Remove Row & Coloumn Headers 

 Steps
1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult Row & Coloumn Headers  are ticked, Untick it , Click ok Button

4. Remove Scroll bars

Steps
1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult Horizondal Scroll bars & Vertical Scroll bars  are ticked, Untick both  , Click ok Button

5. Remove sheet Tabs
Note: Only Use this option if you have only 1 worksheet / you have hyperlinks to other sheets.
Steps
1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult sheet Tabs  are ticked, Untick it  , Click ok Button

Remove Gridlines From excel sheet

Fed up with watching gridlines in you excel sheet ?

Steps

1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult Gridlines are ticked, Untick it , Click ok Button

Then You have it


Note: If you want to change color of gridlines, there is an option under it, change gridlines color in it & Tick Gridlines.

Removing Borders in Excel

Adding borders to cells is a very common thing in Excel. You may add them to help draw attention to number, or to divide numbers from column headings in a table.

Here is a quick way you can remove any borders applied to a cell or group of cells: simply press Ctrl+_ Ie, Ctrl + Shift + _ . (That is the underscore, which means you must hold down the Shift key as well.) Excel leaves the other formatting of the cell set, but removes any borders.

Excel Shortcuts

>

EXCEL

 Note: A plus sign indicates that the keys need to be pressed at the same time.

Action Keystroke Document actions Open a file CTRL+O New file CTRL+N Save As F12 Save CTRL+S Print CTRL+P Find CTRL+F Replace CTRL+H Go to F5 Cursor Movement One cell up up arrow One cell down down arrow One cell right Tab One cell left SHIFT+Tab Top of worksheet (cell A1) CTRL+Home End of worksheet (last cell with data) CTRL+End End of row Home End of column CTRL+left arrow Move to next worksheet CTRL+PageDown Formulas Apply AutoSum ALT+= Current date CTRL+; Current time CTRL+: Spelling F7 Help F1 Macros ALT+F8

Action Keystroke Selecting Cells All cells left of current cell SHIFT+left arrow All cells right of current cell SHIFT+right arrow Entire column CTRL+Spacebar Entire row SHIFT+Spacebar Entire worksheet CTRL+A Text Style Bold CTRL+B Italics CTRL+I Underline CTRL+U Strikethrough CTRL+5 Formatting Edit active cell F2 Format as currency with 2 decimal places SHIFT+CTRL+$ Format as percent with no decimal places SHIFT+CTRL+% Cut CTRL+X Copy CTRL+C Paste CTRL+V Undo CTRL+Z Redo CTRL+Y Format cells dialog box CTRL+1

How to Enter same data to Multiple Columns in Excel

I've Given an Example

Its Simple- Just need a control over mouse & Keyboard

Its going to enter " Coimbatore " in Branch Column as given below

 Step 1.  Select the  Target columns as given below

 

 Step 2 . Enter data ("Coimbatore") without deselecting the columns.

 

 Step 3. Press [ Control Key + Enter ] without deselecting, then you have it

 

Dont forget to Thank me for my efforts, If its useful for you.