Excel Keyboard Shortcuts

	NOTE: These key assignments are for standard US-English keyboards. The mappings may be slightly different on non-US-English keyboards.
	Key Alone Shift Ctrl Alt Shift Ctrl F1 Help What's This Help   Insert Chart Sheet   F2 Edit Mode Edit Comment   Save As   F3 Paste Name Formula Paste Function Define Name   Names From Labels F4 Repeat Action Find Again Close Window Quit Excel Find Previous F5 Goto Find Restore Window Size     F6 Next Pane Prev Pane Next Window Previous Window Prev Workbook F7 Spell Check   Move Window     F8 Extend Selection Add To Selection Resize Window Macro List   F9 Calculate All Calculate Worksheet Minimize Workbook     F10 Activate Menu Context Menu Maximize Window     F11 New Chart New Worksheet New Macro Sheet VB Editor   F12 Save As Save Open   Print A     Select All    Formula Arguments B     Bold     C     Copy     D     Fill Down Data Menu   E       Edit Menu   F     Find File Menu Font Name G     Goto     H     Replace Help Menu   I     Italics Insert Menu   J           K     Insert  Hyperlink     L           M           N     New Workbook     O     Open Workbook Format Menu Select Comments P     Print   Font Size Q           R     Fill Right     S     Save     T       Tools Menu   U     Underline     V     Paste     W     Close Workbook Window Menu   X     Cut     Y     Repeat Active     Z     Undo     ` (~)     Toggle Formula View   General Format 1 (!)     Cell Format   Number Format 2 (@)     Toggle Bold   Time Format 3 (#)     Toggle Italics   Date Format 4 ($)     Toggle Underline   Currency Format 5 (%)     Toggle Strikethru   Percent Format 6 (^)     Toggle Object Display   Exponent Format 7 (&)     Show/Hide Standard Toolbar   Apply Border 8 (*)     Outline   Select Region 9 (()     Hide Rows   Unhide Rows 0 ())     Hide Columns   Unhide Columns -     Delete Selection Control Menu No Border = (+) Formula   Calculate All Auto Sum Insert Cells [     Direct Precendents   All Precendents ]     Direct Dependents   All Dependents ; (semicolon)     Insert Date Select Visible Cells Insert Time ' (apostrophe)     Copy Formula From Above Style Copy Value Above : (colon)     Insert Time     /     Select Array   Select Array \     Select Differences   Select Unequal Cells Insert Insert Mode   Copy     Delete Clear   Delete To End Of Line     Home Begin Row   Start Of Worksheet     End End Row   End Of Worksheet     Page Up Page Up   Previous Worksheet Left 1 screen   Page Down Page Down   Next Worksheet Right 1 screen   Left Arrow Move Left Select Left Move Left Area     Right Arrow Move Right Select Right Move Right Area     Up Arrow Move Up Select Up Move Up Area     Down Arrow Move Down Select Down Move Down Area Drop down list   Space Bar Space Select Row Select Column Control Box Select All Tab Move Right Move Left Next Window Next Application Previous Window Enter   Move Up Fill Selection With Active Cell Insert Row   BackSpace   Collapse Selection To Active Cell Goto Active Cell
	You can download this as an Excel workbook here.

I want to use my computer as a personal FTP server.

situation
	I want to use my computer as a personal FTP server.
problem
	Filezilla How to make the Filezilla aa personal FTP server, working in non usual 21 port, for security reasons. Even if you change the port Filezilla, you may get the error:   425 Can't open data connection.
difficulty level
	5/10 :>
compatibility
	FTP, Filezilla, all other FTP server software
solution
	1. Open on computers firewall the port 52000 2. On router, forward the follow port range to your computer (static ip required) 52000-52000. 3. Install Filezilla, setup user, their passwords and the folders that will have access. 4. Open Filezilla server panel and go Edit -> Settings 5. At “General Settings” set as “Listen on these ports:” the value 55006 6. At “Passive mode settings” check the “use custom port range” and se as range the 52001-52200. With 6th step you solve the 425 error.

there is a lime green line on all videos i watch

Problem
there is a lime green line on all videos i watch

Solution
Have solved this problem sorta of.   Right click on video to bring up the Adobe Flash Player box. Uncheck the hardware acceleration.  This will eliminate the double image and the green line. I am wondering if Adobe did something with their flash player.

Unable to change my desktop background Windows 7 Starter

Yes!!! Microsoft sucks... anyway....

There is no personalization feature. However, you can get around this very easily by downloading Oceanis; it's safe, it's free and has been a solution for so many people with the same problem as you. Here is the link:

http://dl2.sevenforums.com/dl/Oceanis_Change_Background_W7.zip

outlook 2010 is not appeared at all after its startup - ad226134775

problem
microsoft outlook 2010 is not appeared at all after startup, cannot be restored, its window position is somewhere not visible
even the new derived windows are not appeared

this works (at least) in versions 2002-2010

solution
To resolve this behavior, delete the relevant registry value and then restart Outlook to recreate the value:

    Click Start on the taskbar, and then click Run.
    Type regedit, and then click OK to start Registry Editor.
    On the registry tree in the left pane, locate the following registry key:
    HKEY_CURRENT_USER\Software\Microsoft\Office\1???\Outlook\Office Explorer\
    In the right pane, right-click the Frame value, and then click Delete.
    Quit Registry Editor.
    Start Outlook

Ms Outlook 2010 stuck on “loading profile”

This problem occurred when computers comes from “sleep”.

In case you are using the Microsoft Messenger, try to close it (at all) (from the main window, press Alt, and select File -> Exit messenger). The try to load the Outlook again. 

In case you using it and it is closed at the time where Outlook has this problem, load it!

This problem exists because the Outlook gets info about your contacts that uses Messenger also. Something is getting wrong in this communication.

Excel, how to get a value of a cell according is coordinates, like X,Y

You may wonder, why CELL formula in Excel didn't used to return a value of Cellaccording its coordinates? Well CELL formula is used to return some Properties of a referenced cell, see the help about the CELL formula.

What if you want to the a value of a cell according is coordinates, like X,Y or in Excel's worlds Column,Row number. INDEX is named the formula that can do this! It used for other purposes also, I demonstrate it for the thing we want to do.

syntax:
=INDEX(<array where will take place>;<row number>;<column number>)

example:
get the the x=1 and y=10,
with other words: the the value of the 10th row of the 1st row:
=INDEX(A:Z;10;1)

The A:Z means all the columns and row from the column A to column Z; you may define more specific are like:
=INDEX(B1:C30;10;1)
In this case, the 10th row of the 1st row will be applied in the are B1:C30.