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

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

Wednesday, August 12, 2009

HOW TO: Solve Equations in Lotus Symphony spreadsheet









Posted by Saurav Pandey at 9:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Calculate, formula, HOW TO, Symphony

HOW TO: Protect cells in Lotus Symphony spreadsheet









Posted by Saurav Pandey at 6:30 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Cell, HOW TO, Symphony

Wednesday, August 5, 2009

HOW TO: Automatically adjust column width in Lotus Symphony spreadsheet









Posted by Saurav Pandey at 2:00 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Columns, HOW TO, Symphony

Monday, August 3, 2009

HOW TO: Apply Conditional Formatting in Lotus Symphony spreadsheet









Posted by Saurav Pandey at 10:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: format, HOW TO, Symphony

Tuesday, September 9, 2008

HOW TO: Highlight duplicate entries









Posted by Saurav Pandey at 4:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Cell, Compare, Duplicates, Excel, Filter, HOW TO

Monday, September 8, 2008

HOW TO: Add a Drop-Down List









Posted by Saurav Pandey at 4:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Cell, Display, Excel, HOW TO

Friday, September 5, 2008

HOW TO: Shade Alternate Rows









Posted by Saurav Pandey at 4:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Color, Columns, Display, Excel, formula, HOW TO, Row

Thursday, September 4, 2008

HOW TO: Timestamp and add current Date or Time









Posted by Saurav Pandey at 4:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Dates, Excel, formula, HOW TO

Wednesday, September 3, 2008

HOW TO: Create an organization chart









Posted by Saurav Pandey at 4:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Chart, Excel, HOW TO

Tuesday, September 2, 2008

HOW TO: Change the color of sheet tabs









Posted by Saurav Pandey at 4:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Color, Excel, HOW TO, Sheet, Worksheets

Friday, August 29, 2008

HOW TO: Find width of a column in a formula









Posted by Saurav Pandey at 4:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Calculate, Cell, Columns, Excel, formula, HOW TO

Thursday, August 28, 2008

HOW TO: Hide Gridlines from Worksheets









Posted by Saurav Pandey at 4:00 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Display, Excel, HOW TO, Sheet, Worksheets
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