Skip to main content

Books

 

          

 








Comments

Post a Comment

Popular posts from this blog

Compare two columns with Go To Special

  In the figure below, say that you want to find any changes between column A and column D. Select the data in A2:A9 and then hold down the Ctrl key while you select the data in D2:D9. Select, Home, Find & Select, Go To Special. Then, in the Go To Special dialog, choose Row Differences. Click OK. Only the items in column A that do not match the items in column D are selected. Use a red font to mark these items, as shown below. Caution This technique works only for lists that are mostly identical. If you insert one new row near the top of the second list, causing all future rows to be offset by one row, each of those rows is marked as a row difference
Post a Comment
Read more

How many types of the predefined freeze panes are there in Excel?

  Freeze Panes in Excel is used to fix any frame or row or section of the table to access the data located so down below so that the user can see the header’s name as well. There is 3 type of Freeze Panes option available in View menu tab under Window section, Freeze Panes, Freeze Top Row and Freeze First Column. Freeze Panes is used to freeze the worksheet from the point where we keep our cursor. This freezes both the row and column both. Then to freeze a Row and a Column, we have a separate option to freeze each of them. Once we do that, we will see some portion of the worksheet will not move until we unfreeze it.
Post a Comment
Read more