Shared workbooks feature in excel

If several users who need to work from the same workbook at the same time, you can use Shared Workbook feature. To use this feature, select Tools | Share Workbook, and Excel will allow more than one users to update the workbook. You can set options that control when changes are updated and how to handle conflicting edits by different users. You can choose to save updates when a user clicks Save, or you can specify a time interval for…

Continue Reading

Break Link to remove the linked file sources

When you work on a large file which contains link from different files, the file size becomes large and removing the link by searching different links may be difficult.To remove these link easly and to make the linked contents as paste special values you can follow these steps.·         Go to Data tab and click on Edit links.·         You can see the different source files linked to this workbook.·         Select the file you want to remove the link and click on…

Continue Reading

Quick access to worksheets

When there are many worksheets in a workbook and all the worksheets are not visible in the worksheet tab. The user has to search for the required worksheet. To search the sheet quickly you can right click on the any of the tab scrolling buttons, a short cut menu will pop-up and you can select the worksheet you want.

Continue Reading

Large file size due to names with error in excel

Some times, when you move sheets from different file, the file size will be too large even though the contents of the file are very less.The reason for this may be the Names defined in the original file which is moved to new file. These Names may not be required in this file and if the link for the defined Name is linked to sheet which is not moved, it will be of no use and it will show the…

Continue Reading

Open a particular workbook automatically when excel opened.

If you work regularly on a particular workbook, and if you want to open that file when the excel application is launched, you can follow these steps.Create a shortcut of that particular excel file.Copy that shortcut and paste that to XLSTART which you can find in excel program files.(You can find this folder in C:Program FilesMicrosoft OfficeOffice)After placing the shortcut, close the excel and restart. Excel file will open automatically.

Continue Reading

View or Print all formulas in a Sheet

If you want to View or Print all formulas in excel cell, you can select that cell and view the formula in formula bar. You can also view the formula of selected cell by pressing the F2 Key. But if you want to see the formulas in a sheet, you can go to Formulas Tab and click on Show Formulas. It will show all the formulas in that sheet instead of formula results. You can also use the keyboard shortcut…

Continue Reading

Income tax assessee profiles and assessment status in excel

In this excel utility Income tax profiles of the assessee's and the assessment status of 3 years can be maintained. Key features:·Assessee's profile details like Name, Address, Mobile No., E-Mail can be stored.·Details for last 3 assessment year can be maintained ( AY 2014-15, AY 2013-14, AY 2012-13)·Link the related file and open by one click.·Open the websites with auto fill of assesse detailsTo create a profile, you have to enter the PAN in the list sheet and double click…

Continue Reading

Insert table from excel to Gmail or Blogger

If you have information in excel in the form of table and you want to copy and paste it to gmail, or in the blogger compose box, the formatting will not be pasted in gmail compose window. It will paste the data without border and colours.To paste the table with formatting in Gmail, follow these steps:1. Copy the table in Excel workbook you want to paste in Gmail.2. Open a new word document and paste the table you have copied…

Continue Reading

Password Manager for incometaxindiaefiling.gov.in user details.

In this excel workbook, you can manage the username and password details for incometaxindiaefiling.gov.in website.Enable macros to use this workbook.Click on the User list button to update the login details. First time when you click on User List, it will ask you to create the password.User Name and password will be secured and each time it will ask password to view and update the user list.Date of birth for login, password to open ITR V and Password to open 26AS…

Continue Reading

Change the comma separator from lakhs to million

Change the comma separator from lakhs to million: Numbers entered in excel shows the comma separator when the format of the cells are accounting format. Comma separator may be for lakhs or for million based on the region selected in the windows operating system. Sometimes you may want to show the numbers in millions but excel will show in lakhs. If your excel is showing comma for lakhs, this can be changed to million by changing the region in the…

Continue Reading
Close Menu
×

Cart