Tuesday, July 28, 2009

Excel | Select Visible Cells Only

Select the area you want to copy. Press F5 click Special, click visible cells only click OK. Copy, then paste where you want.


There is a toolbar button for visible cells only if you use it lots:

In MS Excel 2007, to add the Select Visible Cells Command, do the following steps:
Step 1: Right click on the toolbar on top and click Customize Quick Access toolbar.
Step 2: Under Choose Command From drop down menu
, select Commands Not in the Ribbon.
Step 3: Scroll down and click on Select Visible Cells.
Step 4: Click on Add and OK.
Now you should be able to see the command in the quick access toolbar.

Thursday, July 23, 2009

Excel: How to Create a Formula to Correctly Evaluate Blank Cells

If you are checking a cell for a zero value and the cell is blank, the test evaluates to true. For example, if you have the following formula in cell A1
=IF(B1=0,"zero","blank")
and B1 is blank, the formula returns "zero" and not "blank" as expected. If the range might contain a blank cell, you should use the ISBLANK function to test for a zero value, as in the following example:
=IF(ISBLANK(B2),"blank",IF(B2=0,"zero","other"))
Note that the above formula returns "zero" if there is a zero value in the cell, "blank" if the cell is blank, and "other" if anything else is in the cell. You must always use the ISBLANK formula first before you test for a zero value. Otherwise you will always return a "true" for the zero value, and never get to the test for the ISBLANK formula.

Add or Remove "Welcome Center" at Startup (Microsoft Vista)

Control Panel > System and Maintenance > Welcome Center

and check (or uncheck) the box "Run at startup

Friday, July 10, 2009

NYTimes: Q & A: Speeding Up a Slow Windows Startup

http://gadgetwise.blogs.nytimes.com/2009/05/07/q-a-speeding-up-a-slow-windows-startup/

Thursday, July 9, 2009

Add Facebook status to FriendFeed? - Yahoo! Answers

Add Facebook status to FriendFeed? - Yahoo! Answers: "How do I add my Facebook status feed to FriendFeed? I always get this error 'It appears that Facebook does not provide a Status feed for your account'!"

Posterous.com

http://posterous.com/

To "unfavorite" a "favorited" item:  "there's an unfavorite star that appears when you hover over the post


Thanks for using Posterous!

Sachin
Co-Founder
Posterous.com"

Tuesday, July 7, 2009

Fix printing problems by resetting the print spooler

Fix printing problems by resetting the print spooler - Microsoft Support

Next: reinstall the printer.

Seems to occur when printing adobe pdf files (sch statements)
Related Posts Plugin for WordPress, Blogger...