Saurav's HowTo

HOW TO Use Only Selected Parts of AutoFormat

2010-06-30T01:00:00.001-04:00

HOW TO Use the SUBTOTAL Function with AutoFiltered Lists in Excel

2010-06-21T04:00:00.000-04:00

HOW TO Use SUM Function on Only Odd or Even Rows in Excel

2010-06-09T06:45:00.001-04:00

HOW TO Hide Gridlines in a Selected Area of a Worksheet in Excel

2010-06-06T06:45:00.002-04:00

HOW TO convert dates in imported files from yy/mm/dd to mm/dd/yy Format in Excel

2010-05-28T06:45:00.001-04:00

HOW TO print a portion of a worksheet in Excel

2010-05-21T06:45:00.003-04:00

HOW TO delete duplicate rows from a list in Excel

2010-05-20T06:45:00.000-04:00

HOW TO convert columns to rows, or rows to columns in Excel

2010-05-19T06:45:00.001-04:00

HOW TO: Solve Equations in Lotus Symphony spreadsheet

2009-08-12T09:00:00.002-04:00

HOW TO: Protect cells in Lotus Symphony spreadsheet

2009-08-12T06:30:00.000-04:00

HOW TO: Automatically adjust column width in Lotus Symphony spreadsheet

2009-08-05T14:00:00.002-04:00

HOW TO: Apply Conditional Formatting in Lotus Symphony spreadsheet

2009-08-03T10:00:00.003-04:00

HOW TO: Highlight duplicate entries

2008-09-09T04:00:00.001-04:00

HOW TO: Add a Drop-Down List

2008-09-08T04:00:00.001-04:00

HOW TO: Shade Alternate Rows

2008-09-05T04:00:00.001-04:00

HOW TO: Timestamp and add current Date or Time

2008-09-04T04:00:00.001-04:00

HOW TO: Create an organization chart

2008-09-03T04:00:00.001-04:00

HOW TO: Change the color of sheet tabs

2008-09-02T04:00:00.002-04:00

HOW TO: Find width of a column in a formula

2008-08-29T04:00:00.002-04:00

HOW TO: Hide Gridlines from Worksheets

2008-08-28T04:00:00.001-04:00

HOW TO: Sort a Row from left to right

2008-08-27T04:00:00.002-04:00

HOW TO: Filter unique items from a list

2008-08-26T04:00:00.001-04:00

HOW TO: Change the Shape and Color of Cell comments

2008-08-25T04:00:00.000-04:00

HOW TO: Add the Workbook Path to the Header and Footer in Excel

2008-08-22T04:00:00.002-04:00

HOW TO: Use AutoFilter to filter records based on cell formatting in Excel

2008-08-21T04:00:00.001-04:00

HOW TO: Calculate the number of months between two dates in Excel

2008-08-20T04:00:00.002-04:00

HOW TO: Count Blank Cells in a Specified Range in Excel

2008-08-19T04:00:00.003-04:00

HOW TO: Compare Data in Two Columns for Duplicates in Excel

2008-08-18T04:00:00.002-04:00

HOW TO: Check Number of Records Returned in an AutoFilter in Excel

2008-08-15T04:00:00.002-04:00

HOW TO: Convert text to numbers in Excel

2008-08-14T04:00:00.002-04:00

HOW TO: Consolidate Multiple Worksheets to a Single Sheet in Excel

2008-08-13T04:00:00.003-04:00

HOW TO: Check and manage the status of links in Excel

2008-08-12T16:00:00.002-04:00

HOW TO: Change the font in a Comment in Excel

2008-08-11T04:00:00.003-04:00

HOW TO: Compare two cells and ignore leading and trailing spaces in Excel

2008-08-08T04:00:00.002-04:00

HOW TO: Calculate the nth Root of a Number in Excel

2008-08-07T04:00:00.002-04:00

HOW TO: Display fractions in Excel

2008-08-06T04:00:00.002-04:00

HOW TO: Make text in a cell display in multiple lines

2008-08-05T04:00:00.002-04:00

HOW TO: Clear the Most Recently Used list in Excel

2008-08-04T04:00:00.002-04:00

Update: Freeing up the How-Tos

2008-08-01T04:00:00.003-04:00

Recently, while listening to a friend of mine, I decided that I should open these How-Tos up - for free. Soon I will be adding the How-Tos to this blog and merge the two sites (sauravpandey.com and this blog) into one.

Welcome

2007-06-02T12:37:00.000-04:00

Hi, and welcome to this blog. We plan to use this space for discussion on the How-Tos presented at my site - www.sauravpandey.com

The idea behind the site - Saurav's How-Tos, started with friends and acquaintances seeking advice on how to do this, or how to do that. Most of the time I found myself repeating the advice to different people. With this collection of advices gathering, I wondered if sharing this to the whole web community could be of any help.

Now, I know that many of you would say, 'why not? any advice on the web should be welcome'. I went a step ahead and added a small donation required to view the collection. A payment of $0.99 securely through PayPal © (www.paypal.com) is all it takes to view all of the how-tos for a day (or a browsing session, whichever closes first).

This service does not offer any guarantees or warranties, express or implied. This is only a personal effort to help fellow web surfers in return for a small payment. The intent of the payment is not to cover the advice or content, but simply to help me pay for the costs to host and maintain the content online.

Post your queries on this blog and I will make my best effort to help respond to it. You could post about anything - a new How-To, further questions on existing How-Tos, payment queries...

Cheers!
Saurav