Pages

Saturday, 29 December 2012

Create a Custom Toolbar in Windows

            If you're constantly accessing a particular folder, you can add it to your taskbar for quick access.

Follow the Simple and easy steps

  1. Right-click the taskbar and scroll to Toolbars
  2. Then select New Toolbar.
  3. It will open an Explorer window, so browse to your folder and select it. 


It's also handy to add My Computer as a toolbar.


Enjoy the simple Shortcuts.....Make your desktop neat and clean using these quick access tools...


Mouse Triple Click Techniques

Advantages of Mouse Clicking

Triple-click your mouse to select a URL in your browser’s address bar. 

This makes it easy to copy and paste the URL. 

You can also triple-click a paragraph or double-click a word for faster selecting. 

Quickly Delete Blank Rows From A Long List in Excel 2010, 2007, 2003

                  Suppose you receive a list of data that contains blank rows that you want to remove without affecting the order of the list. This technique will allow you to delete all rows that have blank cells in a particular column. Just follow the simple steps
  1. First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
  2. Now, select the cells in one column from the top of your list to the bottom.
  3. Make sure that all the blank cells in this selected range are the rows you want to delete.
  4. Press the F5 key on your keyboard (or select Edit, Goto).
  5. Click the Special... button.
  6. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
  7. Now choose Edit, Delete, select the Entire Row option and click OK.
delete blank rows in excel

If you work with large lists of data in Excel, this tip will save you a lot of time. If you don't work with large lists often, remember this tip anyway, because sooner or later you're going to need this.

Cool Tips...Keep Cool...
Find this on Google+