Shortcut function keys in excel

by Jeya Eskalin under Software

Here is a list of shortcut keys in Microsoft Excel.

1. F1: Opens a help task pane
2. F1 + Ctrl: Opens or closes the help window
3. F2: To edit the text in the active cell
4. F2 + Shift: To write a comment in the active cell
5. F2 + Alt: Opens the save as dialog box
6. F3 + Shift: opens the insert dialog box
7. F3 + Ctrl: Opens the define name dialog box
8. F3 + Shift + Ctrl:  Opens the create name dialog box
9. F4:  To redo the last command
10. F4 + Ctrl: To close the workbook window
11. F4 + Alt: To close the excel program
12. F5: Opens the Goto dialog box
13. F5 + Ctrl: brings back to the first level of workbook
14. F6: To shift between help taskbar and the excel window
15. F6 + Shift: To goto the previous square in the open worksheet
16. F6 + Ctrl: If more than one workbook is open to switch between them
17. F7: To open spelling correction window
18. F7 + Ctrl: When workbook window is not maximised it will move the window
19. F8: To activate / deactivate extended mode
20. F9: Will calculate all the worksheets in all open workbooks
21. F9 + Shift: Will calculate the active worksheet
22. F9 + Ctrl: To Minimise the workbook window
23. F10: Will select the menu bar
24. F10 + Ctrl: To open minimised window
25. F11: Will create a chart using the current range
26. F11 + Shift: To select a new worksheet
27. F11 + Alt: To switch between visual basic editor and the worksheet
28. F11 + Alt + Shift: Opens microsoft script editor
29. F12: Opens save as dialog box
30. F12 + Shift: Saves the active workbook
31. F12 + Ctrl: To open the Open dialog box

F12 + Ctrl + Shift: Opens the print dialog box

Read more »

Living Tomorrow: house of the future

Read more »

Microsoft's Future Vision in HD ; Windows Home Concept

Read more »

Microsoft's future vision on retailing

Read more »

Manufacturing Future Vision

Read more »

Health Future Vision

Read more »

New Future Technology

Read more »

Mobile phones concepts

Read more »

Future Designer laptop - ROLLTOP

Read more »

3 Alternative Ways To Get Map Directions Online Using ZIP Codes

by Rich Menga on Oct 31, 2011 

                                                                                                         For the most part, the way people type out directions using a mapping service like Google Maps or Bing Maps is exact-address-to-exact-address. Well, you don’t have to do that. If you know your ZIPs, you can get the directions info you want faster and easier.

1. Abbreviate, skip the Town/State and use the ZIP

This is a good one to know because there are many instances where the mapping service won’t "understand" the town you listed, but will understand the ZIP.
For example, 306 East Jackson Street, Tampa, FL 33602 can simply be mapped as 306 E Jackson St 33602 and it will show up properly. "East" was shortened to E, the town/state was completely skipped, I used the ZIP and was still able to map the location easily.

2. Use "from ZIP to ZIP" for less typing

If I want to map a route from Clearwater, Florida to Safety Harbor, Florida, it’s easier to type from 33755 to 34695 compared to typing out the city names.

3. Use "[Point of Interest] ZIP" to quickly find the closest location to you

If for example you wanted to know the closest Best Buy store, you would type in Best Buy followed by your home ZIP code and the mapping service will find it. It doesn’t matter if the Best Buy is in your ZIP area or not as it will still find the closest one to you.
Important note: This to the best of my knowledge only works with Google Maps.
Example: best buy 33602 (note that several locations are listed, with "A" being the closest to 33602)
This type of Google Maps search works with just about anything you’d want to locate closest to you. "police [ZIP]", "dmv [ZIP]", "post office [ZIP]", "library [ZIP]" or whatever else you can think of, Google Maps will find the closest one.

Read more »