skip to main | skip to sidebar

Saurav's HowTo

A discussion on the various HowTos available on my website at www.sauravpandey.com

Friday, May 28, 2010

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









Posted by Saurav Pandey at 6:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Convert, Dates, Excel, format, HOW TO, text

Friday, May 21, 2010

HOW TO print a portion of a worksheet in Excel









Posted by Saurav Pandey at 6:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Excel, HOW TO, Print, Range, Worksheets

Thursday, May 20, 2010

HOW TO delete duplicate rows from a list in Excel









Posted by Saurav Pandey at 6:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Duplicates, Excel, HOW TO, list, Row

Wednesday, May 19, 2010

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









Posted by Saurav Pandey at 6:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Columns, Convert, Excel, HOW TO, Row
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Donate

Like what you see? Please support with a donation.

Site Search

Labels

  • AutoFilter (3)
  • AutoFormat (1)
  • Blank (1)
  • Calculate (4)
  • Cell (8)
  • Chart (1)
  • Clear (1)
  • Color (2)
  • Columns (5)
  • Comment (2)
  • Compare (3)
  • Consolidate (1)
  • Convert (3)
  • Count (2)
  • Dates (3)
  • Display (5)
  • Duplicates (4)
  • Excel (33)
  • Filter (2)
  • font (1)
  • Footer (1)
  • format (4)
  • formula (5)
  • fractions (1)
  • Free (1)
  • gridlines (1)
  • Header (1)
  • HOW TO (39)
  • links (1)
  • list (2)
  • Months (1)
  • numbers (1)
  • PayPal (1)
  • Print (1)
  • Range (4)
  • Records (1)
  • Root (1)
  • Row (5)
  • Sheet (4)
  • Sort (1)
  • spaces (1)
  • status (1)
  • SUBTOTAL (1)
  • SUM (2)
  • Symphony (4)
  • text (3)
  • Welcome (1)
  • Workbook (1)
  • Worksheets (4)

Blog Archive

  • ▼  2010 (8)
    • ►  Jun 2010 (4)
    • ▼  May 2010 (4)
      • HOW TO convert dates in imported files from yy/mm/...
      • HOW TO print a portion of a worksheet in Excel
      • HOW TO delete duplicate rows from a list in Excel
      • HOW TO convert columns to rows, or rows to columns...
  • ►  2009 (4)
    • ►  Aug 2009 (4)
  • ►  2008 (27)
    • ►  Sep 2008 (6)
    • ►  Aug 2008 (21)
  • ►  2007 (1)
    • ►  Jun 2007 (1)

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

About Me

My photo
Saurav Pandey
Friendly, Honest and Sincere
Nature lover, Freelance Photographer, and IBMer
View my complete profile
 

Disclaimer

Disclaimer: The postings on this site are my own and do not necessarily represent IBM's positions, strategies, or opinions