Open any Microsoft(MS) Office program as a copy

Click open in the MS office program like MS excel or MS Word or any other Ms office programs.

Navigate and locate the file that you want to open

Click the arrow next to the open button

You will see the list of menu as seen below

Open file as a copy Click open as copy

Ms office will automatically create a copy of the file and will open the file that you need as a copy.

This will create a copy of the file in the same folder.

You can also Open files in read only mode by clicking Open Read-Only

If you have any questions or suggestions, please post a comment

Read more Excel Ms office tips and tricks from our website

MS Excel Work Sheet Tips and Tricks

How to Delete, insert, Organize, Color, group, Move or Copy work Sheets in Microsoft Excel?

Insert Excel Sheet

If you want store more related data and differentiate various information, you do not need to create multiple spreadsheets or Excel files.

You just need to insert many sheets and customize it as needed.

One simple way of creating a sheet in the same workbook is by pressing “Shift+F11” (Hold Shift key and press F11) You will see a new sheet created.

There is another method to create a new sheet with more options as follows

  • Right click on the sheets tab to get the menu like below
MS Excel insert Sheet
MS Excel insert Sheet
  • Click on the “Insert” menu
  • MS Excel will give you the below option
Ms Excel Insert Sheet Options
Ms Excel Insert Sheet Options
  • I do not want to deviate from this topic, so I am not going to explain all the options here. Click on the worksheet icon or the image
  • If you want to choose any other sheet type, like a chart or other downloaded template you can select the same
  • Click OK to insert the sheet and Excel will add a new sheet as below
MS Excel Insert Sheet
MS Excel Insert Sheet
  • Most of us want only to insert a plain worksheet so I suggest the fastest way to Press the Shift+F11

How to Delete a sheet?

Right Click on the Sheets Tab and Excel will give a you a menu to select.

Click “Delete”

Ms Excel Delete Sheet
Ms Excel Delete Sheet

When you delete a sheet, Excel will ask you for a confirmation, because you cannot get the data back. It will be lost forever.

When you delete a sheet without any data, Excel will not ask for the confirmation, and it will just delete the sheet.

MS Excel delete-sheet-confirmation while Data is in the sheet
MS Excel delete-sheet-confirmation while Data is in the sheet

How to Rename Excel worksheet?

Right click on the sheets tab

Excel Rename Sheet
Excel Rename Sheet

Excel will give you the menu to choose as below

Click “Rename”

The menu will disappear and the back ground of the sheet name is highlighted

Ms Excel rename sheet
Ms Excel rename sheet

Now you can type the name you desire and Rename the sheet

How to Move or Copy a sheet?

Right Click the Sheets tab

Excel will give you the menu to select “Move or Copy” option

Ms Excel Move or Copy
Ms Excel Move or Copy

Move and Copy both function are in the same option, so it may be little confusing

Excel Move or Copy option
Excel Move or Copy option
Ms Excel Move or Copy to current workbook
Ms Excel Move or Copy to current workbook

If you want to Move a sheet to the end position, just click “Move to end” and then Click “OK”. Do not click any other options

If you want to copy a sheet multiple times in the same workbook then click the check box at the bottom as shown in the below image

Excel Copy Sheet to current workbook
Excel Copy Sheet to current workbook

You can choose the location you want to copy the sheet. Before which sheet or at the end position or to another excel file or to a new workbook

If you want to Move any sheet or sheets within your current workbook, the simplest way is to drag the sheet to the desired position.

If you want to Move or copy the sheet to another workbook or excel file, do the following.

If you want to copy make sure the check box is clicked, you do not need to check the box if you want to move the sheet

Excel Move or Copy to another Excel sheet
Excel Move or Copy to another Excel sheet

I have 2 excel workbook opened

one is ” All Acc leads.csv”

another one is “Book1” which we are working currently

Excel gives me the option to choose where to move or copy the sheet.

And if you do not want to move this to any existing file and want to move it to a “new book”, excel provides option for that also as shown in the above image