Q. Explain how to move information in a worksheet from one location to another. ?
Ans. You can move content of a cell or range of cells using different methods. You must first select the cell or range of cells to move the data
1. You can use cut and paste command to copy. Select Home Button /Clipboard/CUT , transfers contents of the selected cell or range of cells to the clipboard. After performing this, select the cell where you want to copy cell or range of cells and then choose Home/Clipboard/Paste option. Or you can just press the enter key in the destination cell.
2. You can use shortcut menu commands for cut and paste. After selecting the cell or range of cells right click the range and choose cut from the shortcut menu.
3. You can also use the shortcut key Control+ X to Cut and Control +V to Paste.
4. Drag and Drop method can also be used to move contents of a cell or range of cells. Select the cell or range of cells move the mouse to one of the selection border, now the mouse pointer is augmented with a Four Headed Arrow and then simply drag the selection to its new location.
Related Posts by Categories
Excel Notes How to create a template in excel 2007? Tips for Setting Up a Table in Excel Table Terms in Excel Sorting Data in Excel (Sort Button and Sort Dialog Box) Separating Text in Excel (Separating the Data) Separating Text in Excel (Considerations) Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents) Hiding Columns, Rows, and Cells in Excel (Redisplaying Rows) Hiding Columns, Rows, and Cells in Excel (Hiding Rows) Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns) Hiding Columns, Rows, and Cells in Excel (Hiding Columns) Find and Replace Features in Excel (Using the Replace Feature) Find and Replace Features in Excel (Using the Find Feature) Paste Special Feature in Excel (Paste Special Options) Paste Special Feature in Excel (Using the Paste Special Dialog Box) Using the Fill Command in Excel (Filling Cells, Filling Cells: Ribbon Option, Filling Cells: Mouse Option, Working with Custom Fills, Creating a Custom Fill, Importing Custom Fills, Using a Custom Fill) Working with Comments in Excel (Adding Comments, Adding Comments: Ribbon Option, Adding Comments: Mouse Option , Editing Comments, Editing Comments: Ribbon Option, Editing Comments: Mouse Option, Displaying/Hiding Comments, Displaying/Hiding Comments: Single Cell , Displaying/Hiding Comments: Ribbon Option, Displaying/Hiding Comments: All Cells , Moving Comments , Deleting Comments, Removing Comments from a Single Cell: Mouse Option, Removing Comments from a Single Cell: Ribbon Option, Removing Comments from All Cells, Printing Comments) Importing an External Data File in Excel Working with Rows and Columns in Excel (Adjusting Row Height and Column Width, Adjusting Row Height: Ribbon Option, Adjusting Row Height: Mouse Option, Adjusting Column Width: Ribbon Option, Adjusting Column Width: Mouse Option, Using AutoFit to Adjust Rows and Columns, Using AutoFit to Adjust Row Height: Ribbon Option, Using AutoFit to Adjust Column Width: Mouse Option, Using AutoFit to Adjust Column Width: Ribbon Option, Adding and Removing Rows and Columns, Adding Rows, Adding Columns, Deleting Rows, Deleting Columns) Calculating Subtotals in Excel (Adding Subtotals , Adjusting Views with Subtotals , To expand the view one level:, To collapse the view one level: , Removing Subtotals , Re-sorting the Data ) Calculating with Functions in Excel (Parts of a Function , Inserting Functions, Inserting Functions: Dialog Box Option, Inserting Functions: Ribbon Option, About the Function Arguments Dialog Box, To access the Function Arguments dialog box:, Inserting Functions with the Point and Click Method, Adding Cells Together, Adding a Range of Cells with the SUM Function) Editing Cell Contents in Excel (Moving Information, Drag and Drop vs. Cut and Paste, Moving Information: Drag and Drop , To Undo Drag and Drop:, Moving Information: Cut and Paste , Copying Formulas, Copy and Paste ) Working with Conditional Formatting in Excel (Applying Preformatted Rules , Applying Cell Highlighting , Applying Top, Bottom, and Average Rules , Applying Data Bars, Color Scales, and Icon Sets , Creating a Customized Rule , Editing Rules , Prioritizing Rules , Deleting Rules ) Formatting Numbers in Excel (Formatting Numbers: Toolbar Option , Formatting Numbers: Ribbon Option , Formatting Numbers: Dialog Box Option , Clearing Number Formatting ) Formatting Cells in Excel (Applying Cell Styles , Formatting Borders , Changing Borders, Changing Border Color , Changing Border Style , Deleting Borders , Using Conditional Formatting , Merging Cells , Creating a Cell Merge , Customizing a Cell Merge , Removing a Cell Merge , Wrapping Text, Copying Cell Formatting, Clearing Cell Formatting )
0 comments:
Post a Comment