Open the file that you want to add in to your Favorite list
If you have made any changes to the file after opening, you need to save it.
Go to View menu
Click Toolbars and select Web
You will see the toolbars as seen below
Click the Favorites button and save the file
Now when you open the Internet Explorer or Excel with the Web toolbar enabled, you can easily access the file.
If you have any questions or suggestions, please post a comment
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 and Excel will give a you a menu to select.
Click “Delete”
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.
Right click on the sheets tab
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
Now you can type the name you desire and Rename the sheet
Right Click the Sheets tab
Excel will give you the menu to select “Move or Copy” option
Move and Copy both function are in the same option, so it may be little confusing
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
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
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