Copy Excel 2007 data to a Word document

If you want to copy data from Excel to Microsoft word then follow these steps:

In  Excel

  1. Select the worksheet data (range) that you want to copy to a Word document.
  2. On the Home tab, Clipboard group, click

How to handle comments in Excel 2007

All commands (icons) that deal with comments are found in the Review tab, Comments group.

xl7comments1

To insert a new comment:

1. Select the cell where you want to insert the comment.
2. Click New Comment.
3. A new comment will be created. Type the required text then click outside the comment box.
4. The comment box will disappear but a small indicator will show on the top right corner of the cell.

xl7comments2

To show a comment:

1. Select the cell where you have the comment.
2. Click Show / Hide Comment.
3. If you have multiple comments then you can click Show All Comments to show all.

Note:

If the comment is already shown and you click Show / Hide Comment, then the comment will be hidden.

To edit a comment:

1. Select the cell where you have the comment.
2. Click Edit Comment.
3. The comment box will be shown. Click on it then edit the text.

To format a comment:

1. Select the cell where you have the comment.
2. Click Edit Comment.
3. The comment box will be shown.
4. Select the text that you want to format then right-click.

xl7comments3

5. Form the context menu select Format Comment.
6. in the Format Comment dialog box, select the formatting options that you want.

To move or resize a comment:

1. Select the cell where you have the comment then show the comment as explained previously.
2. Click the border of the comment box to show the sizing handles.
3. To move the comment, drag the border of the comment box, or press one of the arrow keys depending on which direction you want to move.

xl7comments4

4. To resize the comment, drag the handles on the sides and corners of the comment box.
xl7comments5

To copy a comment to another cell:

1. Select the cell where you have the comment.
2. In the Home tab, Clipboard group, click Copy (or just right click on the cell and select copy).
3. In the Home tab, Clipboard group, click the arrow below Paste, then select Paste Special (or just right click on the cell and select Paste Special).
4. In the Paste Special dialog box , under Paste, select Comments then click OK.

To delete a comment:

1. Select the cell where you have the comment.
2. Click Delete Comment.
3. The comment box and the comment indicator will both disappear.

To print a comment:

To print a comment check this post.

A macro to merge worksheets from two workbooks into a new workbook

If you have two workbooks, or more, and you want to merge or consolidate those workbooks into one, then you may find it a tedious task to move the worksheets manually.

The following macro reads two workbooks and copy all the worksheets into a new consolidated workbook. If you have more than two workbooks as input then you can modify the macro accordingly.

Sub MergeWorkbooks()
‘**********************************************************
‘ Merge worksheets from two workbooks into a new workbook *
‘**********************************************************
Dim OldBook1 As Workbook
Dim OldBook2 As Workbook
Dim NewBook As Workbook
Dim wSheet As Worksheet
‘ Stop screen flicker and speed up the execution of the macro
Application.ScreenUpdating = False
‘ Create a new workbook ( the destination for merging the old ones)
Workbooks.Add
Set NewBook = ActiveWorkbook
‘ Assign the old workbooks (must be open before running the macro)
Set OldBook1 = Workbooks(“TestBook1.xls”) ‘ Put the required file name here
Set OldBook2 = Workbooks(“TestBook2.xls”) ‘ Put the required file name here
‘ Loop thru the first workbook an copy its worksheets to the destination workbook
For Each wSheet In OldBook1.Worksheets
wSheet.Copy After:=NewBook.Worksheets(NewBook.Worksheets.Count)
Next
‘ Loop thru the second workbook an copy its worksheets to the destination workbook
For Each wSheet In OldBook2.Worksheets
wSheet.Copy After:=NewBook.Worksheets(NewBook.Worksheets.Count)
Next
‘ Save the destination workbook
NewBook.SaveAs Filename:=”C:/TestMerg2.xls” ‘ Put the required path and file name here
‘Set screen updating back to normal
Application.ScreenUpdating = True
End Sub

This code is also available in the Downloads page.

Copy the code to a new module in Visual Basic Editor, then run it like any other VBA macro.

Suggested Post:
How to write a VBA macro

Applies to: Excel 2003

How to copy or move worksheets within the same workbook

To copy or move worksheets within the same workbook follow these steps:

1. Switch to the workbook which has the sheet to be copied or moved.

2. in the Edit menu click Move or copy sheet.

3. The Move or copy dialogue will open.

4. The To book drop down will default to the current workbook. Leave this as it is.

5. in the Before sheet list click where you want the sheet to be moved (position within the workbook).

6. Select the Create a copy check box if you want to retain the original worksheet , or deselect it if you just want to move the worksheet to a new location withinthe workbook.

Applies to Excel 2003


How to copy or move worksheets between workbooks

To copy or move worksheets between workbooks follow these steps:

1. Switch to the workbook which has the sheet to be copied or moved.

2. in the Edit menu click Move or copy sheet.

3. The Move or copy dialogue will open.

4. In the To book drop down select the destination workbook. You can also choose to create a new workbook.

5. in the Before sheet list click where you want the sheet to be moved (position within the workbook).

6. Select the Create a copy check box if you want the worksheet to remain in the original workbook, or deselect it  to move the worksheet completely and delete it from the original workbook.

Applies to Excel 2003