Microsoft Excel Function Keys Shortcuts!

Most of the user know at least a handful of shortcuts for Microsoft Excel. However, an entire row of function keys shortcut  is often neglected and even unknown to users. We are talking about the Function keys  that  they just do not get enough attention from users of Microsoft Excel.

So let’s talk about Microsoft  Excel Function Keys, from left to right.

1. F1 by itself opens the Help task pane.
2. Ctrl+F1 shows or hides the Ribbon newer versions of Excel.
3. Alt+F1 will create a quick chart using data that is selected.
4. Alt+Shift+F1 inserts a brand new worksheet/macro sheet.
5. F2 moves the cursor to the end of the selected cell (edit cell mode).
6. Ctrl+F2 shows  Print Preview Window.
7. Alt+F2 brings up the Save As dialog.
8. Shift+F2 adds a comment.
9. F3 opens the Paste Name box.
10. Shift+F3 is a quick way to insert a function.
11. F4  repeats your last action.
12. Ctrl+F4 closes your window.
13. F5 opens the Go To dialog.
14. Ctrl+F5 restores the window size.
15. F6 switches to the task pane or second window.
16. F7 brings up Spell Check.
17. Shift+F7 opens the Research pane.
18. F8 turns on (or off) extended mode.
19. Shift+F8 allows you to add another range of cells to the selection.
20. F9 calculates all open workbooks.
21. Shift+F9 calculates the active worksheet.
22. F10 turns key tips on or off.
23. Ctrl+F10 maximizes or restores the window.
24. F11  creates an instant chart.
25. F12 brings up the Save As dialog.
26. Shift+F12 for the Save window.
27. Ctrl+F12 opens theOpen dialog.

That's all for Today, and keep in mind some of shortcuts also works in other Microsoft Office programs too, other shortcuts will be published soon!

ILYAS QASIM

Internet Explorer 9 Shortcut Keys

We all know that keyboard shortcuts make operating programs quicker, thats why we presenting Internet Explorer 9 shortcuts to make your browsing smooth!

Ctrl + +  (plus sign) – Zoom in a webpage
Ctrl + –  (minus sign) – Zoom out in a webpage
Ctrl + o  - Open a webpage
Ctrl + S – Save a web page for offline viewing.
Ctrl + Shift + Tab – Move back through tabs
Ctrl + Tab – Move forward through tabs.
Ctrl + T – Opens a new browser tab
Ctrl + w – Closes the current browser tab.
Ctrl + K – Copies the current browser tab and opens it.
Ctrl + N – Open a new Internet Explorer window.
Ctrl + J – Opens the Internet Explorer Download Manager.
Ctrl + L – Select the address bar so that you can type in a new address.
Ctrl + B – organize your Internet Explorer favorites.
Ctrl + D – Can be used to bookmark a webpage or add it to your Internet explorer favorites.

Power Tips N Tricks

Google Chrome Task Manager

The Task Manager in Chrome is very similar to the Windows Task Manager, in that memory, CPU usage and other activities are monitored. Another similarity is that it can be used to end a process.

There are a couple of ways to access the Chrome Task Manager. The easiest way, is the keyboard shortcut (Shift+Esc). Or, it can be accessed by clicking on the wrench icon in the upper right corner, and selecting Tools>Task manager from the menus.

Right clicking on one of the items in the list will bring up a menu, where the information on any checked items will be displayed in columns.

If you want to force a webpage or application to close, just click the End process button.

Mobile Only Social Networks With Blinko

Blinko

Blinko is the work of mobile firm Buongiorno. It is free and revolves around Facebook-style status updates, except that they can be text, photos or bookmarks (with video on the way). People can comment on each others updates, and the site allows free texting and instant messaging.

ILYAS QASIM

Sheet Tabs Navigation In Excel

If you created a large workbook in Microsoft Excel and having problem to navigate sheet tabs then, there is two solutions to this:

1. Right click on one of the arrows to the left of the sheet tabs, a list will appear that contains the names of all the tabs in current workbook. You can then select a tab from the list and this will takes you to the tab.
2. Use Ctrl + Page Down to move forward a worksheet.  Ctrl + Page Up moves backwards.  Ensure Num Lock is off.

Happy Navigation of Sheet Tabs!!

ILYAS QASIM

File Formats Dictionary of World Starting with B

FILE EXTENSIONS STARTING WITH B

• B4 Helix Nuts and Bolts file
• BAK Backup file
• BAS BASIC code
• BAT Batch file
• BFC Windows 95 Briefcase document
• BG Backgammon for Windows game
• BI Binary file
• BIF GroupWise initialization file
• BIN Binary file
• BK Sometimes used to denote backup versions
• BK$ Also sometimes used to denote backup versions
• BKS An IBM BookManager Read bookshelf
• BM1 Apogee BioMenace data file
• BMK An A bookmark file
• BMP Windows or OS/2 bitmap
• BRX A file for browsing an index of multimedia options
• BS1 Apogee Blake Stone data file
• BSP Quake map
• BTM Batch file used by Norton Utilities

ILYAS QASIM

File Formats Dictionary of World Starting with A

• ABK Corel Draw AutoBackup
• ACL Corel Draw 6 keyboard accelerator
• ACM Used by Windows in the system directory
• ACP Microsoft Office Assistant Preview file
• ACT Microsoft Office Assistant Actor file
• ACV OS/2 drivers that compress and decompress audio data
• AD After Dark screensaver
• ADB Appointment database used by HP 100LX organizer
• ADD OS/2 adapter drivers used in the boot process
• ADM After Dark MultiModule screensaver
• ADP Used by FaxWorks to do setup for fax modem interaction
• ADR After Dark Randomizer screensaver
• AF2 ABC Flowchart file
• AF3 ABC Flowchart file
• AFM Adobe font metrics
• AI Adobe Illustrator drawing
• AIF Apple Mac AIFF sound
• ALB JASC Image Commander album
• ALL Arts & Letters Library
• AMS Velvert Studio music module (MOD) file
• ANC Canon Computer Pattern Maker file that is a selectable list of pattern colors
• ANI Animated Cursor
• ANS ANSI text
• API Application Program Interface file; used by Adobe Acrobat
• APR Lotus Approach 97 file
• APS Microsoft Visual C++ file
• ARC LH ARC (old version) compressed archive
• ARJ Robert Jung ARJ compressed archive
• ART Canon Crayola art file
• ART Xara Studio drawing
• ASA Microsoft Visual InterDev file
• ASC ASCII text
• ASD WinWord AutoSave
• ASM Assembler language source file
• ASP Active Server Page (an HTML file containing a Microsoft server-processed script)
• ASP Procomm Plus setup and connection script
• AST Claris Works "assistant" file
• ATT AT&T Group 4 bitmap
• AVI Microsoft Video for Windows movie
• AWD FaxView document

ILYAS QASIM

View Your Most Recently Deleted Files

By default, the Recycle Bin lists files alphabetically. However, when looking for accidentally deleted files, it’s more convenient to look at the files you’ve most recently deleted. To do so, click the Date Deleted column header. When you do, your latest deletion will appear at the top of the list.

Now control on Recycle Bin.


ILYAS QASIM

Catch The Cache In Internet Explorer

Are you running out of space on your Windows hard drive partition? If so, there is a fair change that your Web Browser’s Internet cache/browsing history is taking up a good portion of your drive. If you have plenty of room on another drive then an option other than just cleaning everything out, is to actually move it to this other drive.

For Internet Explorer create a folder on the drive with plenty of space where you want the new cache/browsing history files to go. Now go Start Menu/Control Panel/Internet Option, in the general tab (Browsing History) click the Setting button. From here you can control the cache/browsing history properties. Click the Move folder button and select the drive, then the new folder and press Ok, and again and once more to fix the setting.

Happy Internet Browsing!



ILYAS QASIM

Selective Printing In Microsoft Word

Word for Windows lets you easily print noncontiguous pages in a document. The key to this operation is the manner in which you identify the individual page or page ranges you want to print, using the Pages text box within the Print dialog box. Individual pages are separated with commas; page ranges are identified by hyphens. Entering the following notation into the Pages text box, for example, prints page I through 4, followed by the three specified individual pages: 1-4, 6, 10, 14.

Enjoy Easy Selective Printing

ILYAS QASIM

Working with Large Lists in Microsoft Excel

There are a lot of times when you're working with a data sheet containing a lot of information where you essentially want to filter the information - find only those rows that have information you care about.  It's a pretty simple thing to do with the handy AutoFilter feature in Microsoft Excel.  Just highlight your data (be sure to get all of it - all rows and columns in your data table) and select Data, Filter, AutoFilter.

When you do, you'll notice new list box arrows at the top of each column.  Click that list box arrow and you'll have several options for selecting information.  You'll be able to select specific values, ranges of values, top n values and so-forth.  It's really a great way to help manage large number of rows of data - and make it more straightforward to work with in your analysis.

If you have multiple columns of data, you can select first from one, then the other.  The filters will, in essence, be combined.  For example if one column was State and one was City, working with the entire data set could be tedious.  Add in the AutoFilter and then select State of Arizona.  Next, you can select Miami and you'll only be looking at the Miami in Arizona, not in Florida.  Simple example, but hopefully you get the idea.

To return to "regular" unfiltered mode, just select Data, Filter, AutoFilteragain and the list boxes will be removed.

Now! easily filter your data in Microsoft Excel.


ILYAS QASIM.