Copying Moving and Pasting Data in Excel

When we are working with the data most of the time we may required to copy/move the data from one location (range) to another location. This tutorials will explains you Copying Moving and Pasting Data in Excel.

Moving a Range in Excel

We can Move the data from one range to another range by using either short cuts or in-built commands.
If you want to Move the data from one range another location:

First we need to Select the existing Range => Cut it => Choose a New Range => Paste it

Select Range to Move:

Cut it: Press Ctrl+ X or right click and select Cut command.

Choose a New Loaction:
 

Paste it: Press Ctrl+ V or right click and select Paste commands.
 

Output:

Copying a Range in Excel

We can Copy the data from one range to another range by using either short cuts or in-built commands.
If you want to Copy the data from one range another location:

First we need to Select the existing Range => Copy it => Choose a New Range => Paste it

Select Range to Copy:

Copy it: Press Ctrl+ C or right click and select Copy command.
 

Choose a New Loaction:
 

Paste it: Press Ctrl+ V or right click and select Paste commands.

Output:
 

Read More...

Formatting Data and Formatting Cells in Excel

Microsoft Excel provides us the tools to make rich formats, we can format the numbers, fonts, font color, background color, alignments and many more things we can do in Excel. This tutorial section will help you to learn Formatting Data and Formatting Cells in Excel.

We have many tools in Excel to work with Formatting

Home Tab

If you observe the Home Tab, you can see many commands to work with formats.

Font

We can use these commands to format the Fonts Styles like Bold, Underline, Italic, Font size, Background Color, Font Color etc. You can click on the icon at bottom-right corner to see the more Font Settings.

Alignment

We can align the data in a Cell using these Commands to align Left,right, Center, etc. Also we have another two frequently used Commands like Wrap Text and Merge Commands

Number

We can format the numbers to currency, percentages, decimals and other formats. We will see in more detailed manner in another topic only on number formats.

Right Click: Format Cells Dialog/ Quick Options

You can also right click on the Cell and Select ‘Format Cells…” Command from the properties list to view the Format Cells Dialog.

Useful Shortcut Keys for Formatting Data

You can use the following Shortcut Keys to Quickly Format the Data.

To Format	Short-cut Key
Bold	Ctrl+b
Italic	Ctrl+I
Underline	Ctrl+u
Strike through	Ctrl+5
Open the style dialog box	alt+’
Open the format cells dialog box	Ctrl+1
Apply the general format	Ctrl+Shift+~
Apply the currency format	Ctrl+Shift+$
Apply the percentage format	Ctrl+Shift+%
Apply the date format	Ctrl+Shift+#
Apply the time format	Ctrl+Shift+@
Apply the number format	Ctrl+Shift+!
Apply the exponential number format	Ctrl+Shift+^
Apply an outline border to the selection	Ctrl+Shift+&
Remove an outline border from the selection	Ctrl+Shift +_

Read More...

Entering Data and Moving in Excel Worksheet

Entering Data and Moving in Excel Worksheet is very easy and you find that it is the time saver for data entry. You can enter any numbers, text, dates in Excel and you can format as per your requirement.

Entering Data

In order in enter data into your worksheet, you need to activate the cell by locate your mouse point to any cell When your cell is activated, it become Active Cell. Active Cell is the place where we enter the data. When we open a new Excel Workbook, by default it activates A1 (top-left corner of a Worksheet) position of a Worksheet and we can start entering the data.

We can see the cell A1 is activate and you can see the Address of the active Cell in the Address bar (rounded with red circle), you can also observe the sample text in A1.

We can also activate a Cell and enter the data in Formula bar.

So, we can activate any Cell and enter the data as per our requirement, below is the example data entered in a worksheet.

Editing Data

We can simply select any Cell and enter new data to edit the existing data in a Cell.
If you want to edit a particular part of existing data, then you need to activate (by pressing F2 or double clicking with the mouse), then goto the particular position and change the data. You may also use Formula bar for editting data, it will give more flexibility to enter the data. To do this, select a Cell and go to Formula bar then start editing or entering the data.

You can also use, Go To Command (You can enable the Go To Command by pressing the Ctr+G. For example, if you want to Activate B8, enter B8 in the Reference space of the Go To Command and then press OK button.

You can also use Address bar to move around the Worksheet and Activate a particular Cell. For example, if you want to Activate B9, enter B9 in the Adress Bar and then press Enter Key.

Read More...