Move, copy, hide and unhide worksheets

You can move spreadsheets in the order that works best for your needs. Simply click on sheet you wish to move and drag it left or right

Move or copy

You can also move a sheet to another file. Simply right click on the sheet and click on move or copy as shown below.

The following screen will show:

Go to the "to book:" drop down, and there you can select to simply paste it in the current file, which will make a copy for you, or more it out of the current file.

Please note that this is a dangerous function to use. You can only copy/duplicate the sheet in another file or move the sheet. When you move it will not be present in the old anymore. This also means that all your links may get corrupted.

Hide or unhide worksheets

You can also hide sheet if you do not wish to see them. This will not delete it but simply not be visible. Right click on the sheet name as above and click hide. You can do the same to unhide. You can also go to Home tab > Format and hide or unhide sheet there.

<-----Back to index

Next topic----->