Skip to main content

Selection of Column differences

Selection of Column differences

This feature is mostly used, for to select the Column differences in the excel.

How to do this –
Step 1 - Please click on GoTo under Home tab or press F5, then click on special will open a new dialogue box


Step 2 - Choose the radio button Column differences
Step 3 - Then click on OKHow it works - First select the range of cells, then if we want to select the cells which are different from the active cell, this feature or trick will helps you a lot.
Remember - Active cell is the cell which will be displayed on Name box at the time of selection, if you want to change the active cell use tab key on your key board to move around the range selected. 

Labels:

Comments

Post a Comment

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.
Post a Comment
Read more

Consolidation of Data

Consolidation Helps to consolidate the different worksheets data.  Whenever there is update on the individual sheet tabs, we can update that sheet tab to consolidated sheet with this trick. Step 1: Created sales sheet tab for Jan, Feb with Data - Click on   Consolidate button   from Data tab or menu. Select the range of data from reference and then click on   add . (Repeat for all sets of data Example: Jan Sales, Feb Sales) Step 2: Click the check box Top Row and Left column, then click OK . So that we can publish the consolidated data where ever we needed Note : If you click the check box "Create links to sources data" will help us to show the result along with formula links. With Browse option we can select and add from external excel files as well.
Post a Comment
Read more

TIP - 51 : Pin the excel work books from Home

Pin the excel work books from Home There is no need for us every time to go the folders and open all the excel files which were used frequently or daily basis. We have trick which helps to save a lot of time - Step 1: Please click on File menu, then click on Home Step 2: Then click on “Recent”, select the excel file, then at the end of the file there appears a symbol of pin (), click on that symbol. That’s all… the file appears in the category of Pinned under Home (shown in image below)
Post a Comment
Read more