Thursday, March 7, 2013

Blank Cells

Fill Blank Cells of Title Cell

To fill blank cells
Steps as follows:


  • Find blank cells using Go To Special [Find & Select, Editing, Home Tab]
  • When blank cells selected Press Ctrl Key
  • Enter =above cell [e.g. =A1] in formula bar
  • Press Ctrl + Enter
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)