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 Saurav Pandey at 1:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: AutoFormat, Excel, format, HOW TO

Monday, June 21, 2010

HOW TO Use the SUBTOTAL Function with AutoFiltered Lists in Excel









Posted by Saurav Pandey at 4:00 AM 1 comment:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
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 Saurav Pandey at 6:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
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 Saurav Pandey at 6:45 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Display, Excel, gridlines, HOW TO, Range, Sheet
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)
      • 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)
  • ►  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