skip to main | skip to sidebar

Saurav's HowTo

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

Wednesday, June 30, 2010

HOW TO Use Only Selected Parts of AutoFormat









Posted by hellosaurav at 1:00 AM 0 comments Links to this post
Email ThisBlogThis!Share to TwitterShare to Facebook
Labels: AutoFormat, Excel, format, HOW TO

Monday, June 21, 2010

HOW TO Use the SUBTOTAL Function with AutoFiltered Lists in Excel









Posted by hellosaurav at 4:00 AM 1 comments Links to this post
Email ThisBlogThis!Share to TwitterShare to Facebook
Labels: AutoFilter, Count, Excel, HOW TO, list, SUBTOTAL, SUM

Wednesday, June 9, 2010

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









Posted by hellosaurav at 6:45 AM 0 comments Links to this post
Email ThisBlogThis!Share to TwitterShare to Facebook
Labels: Calculate, Excel, formula, HOW TO, Row, SUM

Sunday, June 6, 2010

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









Posted by hellosaurav at 6:45 AM 0 comments Links to this post
Email ThisBlogThis!Share to TwitterShare to Facebook
Labels: Display, Excel, gridlines, HOW TO, Range, Sheet

Friday, May 28, 2010

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









Posted by hellosaurav at 6:45 AM 0 comments Links to this post
Email ThisBlogThis!Share to TwitterShare to Facebook
Labels: Convert, Dates, Excel, format, HOW TO, text

Friday, May 21, 2010

HOW TO print a portion of a worksheet in Excel









Posted by hellosaurav at 6:45 AM 0 comments Links to this post
Email ThisBlogThis!Share to TwitterShare to Facebook
Labels: Excel, HOW TO, Print, Range, Worksheets

Thursday, May 20, 2010

HOW TO delete duplicate rows from a list in Excel









Posted by hellosaurav at 6:45 AM 0 comments Links to this post
Email ThisBlogThis!Share to TwitterShare to Facebook
Labels: Duplicates, Excel, HOW TO, list, Row
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)
      • HOW TO Use Only Selected Parts of AutoFormat
      • HOW TO Use the SUBTOTAL Function with AutoFiltered...
      • HOW TO Use SUM Function on Only Odd or Even Rows i...
      • HOW TO Hide Gridlines in a Selected Area of a Work...
    • ►  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)
      • HOW TO: Solve Equations in Lotus Symphony spreadsh...
      • HOW TO: Protect cells in Lotus Symphony spreadshee...
      • HOW TO: Automatically adjust column width in Lotus...
      • HOW TO: Apply Conditional Formatting in Lotus Symp...
  • ►  2008 (27)
    • ►  Sep 2008 (6)
      • HOW TO: Highlight duplicate entries
      • HOW TO: Add a Drop-Down List
      • HOW TO: Shade Alternate Rows
      • HOW TO: Timestamp and add current Date or Time
      • HOW TO: Create an organization chart
      • HOW TO: Change the color of sheet tabs
    • ►  Aug 2008 (21)
      • HOW TO: Find width of a column in a formula
      • HOW TO: Hide Gridlines from Worksheets
      • HOW TO: Sort a Row from left to right
      • HOW TO: Filter unique items from a list
      • HOW TO: Change the Shape and Color of Cell comment...
      • HOW TO: Add the Workbook Path to the Header and Fo...
      • HOW TO: Use AutoFilter to filter records based on ...
      • HOW TO: Calculate the number of months between two...
      • HOW TO: Count Blank Cells in a Specified Range in ...
      • HOW TO: Compare Data in Two Columns for Duplicates...
      • HOW TO: Check Number of Records Returned in an Aut...
      • HOW TO: Convert text to numbers in Excel
      • HOW TO: Consolidate Multiple Worksheets to a Singl...
      • HOW TO: Check and manage the status of links in Ex...
      • HOW TO: Change the font in a Comment in Excel
      • HOW TO: Compare two cells and ignore leading and t...
      • HOW TO: Calculate the nth Root of a Number in Exce...
      • HOW TO: Display fractions in Excel
      • HOW TO: Make text in a cell display in multiple li...
      • HOW TO: Clear the Most Recently Used list in Excel...
      • Update: Freeing up the How-Tos
  • ►  2007 (1)
    • ►  Jun 2007 (1)
      • Welcome

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

About Me

My Photo
hellosaurav
Friendly, Honest and Sincere
Nature lover, Freelance Photographer, and IBMer
View my complete profile

Hubble Images

 

Disclaimer

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