Headlines
Published On:Friday 6 January 2012
Posted by Muhammad Atif Saeed

Modifying a Worksheet

Insert Cells, Rows, and Columns
To insert cells, rows, and columns in Excel:
  • Place the cursor in the row below where you want the new row, or in the column to the left of where you want the new column
  • Click the Insert button on the Cells group of the Home tab
  • Click the appropriate choice: Cell, Row,  or Column
Insert Drop Down Menu 
Delete Cells, Rows and Columns
To delete cells, rows, and columns:
  • Place the cursor in the cell, row, or column that you want to delete
  • Click the Delete button on the Cells group of the Home tab
  • Click the appropriate choice:  Cell, Row, or Column
Delete Drop Down Menu
Find and Replace
To find data or find and replace data:
  • Click the Find & Select button on the Editing group of the Home tab
  • Choose Find or Replace
  • Complete the Find What text box
  • Click on Options for more search options
Find and Replace Dialog Box
Go To Command
The Go To command takes you to a specific cell either by cell reference (the Column Letter and the Row Number) or cell name. 
  • Click the Find & Select button on the Editing group of the Home tab
  • Click Go To
Go To Drop Down
Spell Check
To check the spelling:
  • On the Review tab click the Spelling button
Spelling Button

About the Author

Posted by Muhammad Atif Saeed on 16:56. Filed under . You can follow any responses to this entry through the RSS 2.0. Feel free to leave a response

By Muhammad Atif Saeed on 16:56. Filed under . Follow any responses to the RSS 2.0. Leave a response

0 comments for "Modifying a Worksheet"

Leave a reply

Visit Counters

About Me

My photo
I am doing ACMA from Institute of Cost and Management Accountants Pakistan (Islamabad). Computer and Accounting are my favorite subjects contact Information: +923347787272 atifsaeedicmap@gmail.com atifsaeed_icmap@hotmail.com

    Online Visitors:

    Blog Archive

x

Welcome to eStudy.Pk....Get Our Latest Posts Via Email - It's Free

Enter your email address:

Delivered by FeedBurner