Skip to main content

TIP - 55 : Watch window - to know changes on your sheet tab


Watch window - to know changes on your sheet tab

This will be used to observe any particular cell or range of cells –
One way is to see the result of a formula of cell which can be observed from watch window, no need to move around the worksheet.
Second way is we can use this as a selecting and moving to the required cell from watch window.

Step 1: Please click on Watch window from Formula tab

Step 2: From the dialogue box “Watch Window”, click on Add watch and select the cells or range, then finally click on Add (based on your requirement)

So that we can watch the result or move through via watch window, which can also be added to your screen at formula bar (whenever is required click on watch window)

Comments

Post a Comment

Popular posts from this blog

TIP - 45 : Text to columns do not import (skip) option

Text to columns do not import (skip) option When we have a data for text to columns, where we need only few columns rest you do not want to publish Here comes the solution in excel - Step 1: Please select the data that we want to do text to columns, click on Text to Columns from Data Tab Step 2: From the dialogue box Text to Columns Wizard, click of your choice Delimited or Fixed width Step 3: Click on next, select the delimiters then click on next again Step 4: Now select the column which you want to skip which will be highlighted in black then click on “Do not import column (skip), finally click on Finish Only columns which are not highlighted will be published .
Post a Comment
Read more

Blank Cell - Color code and formatting

Blank Cell - Color code and formatting This feature is mostly used to identify blank cells and if any time some one has accidentally  deleted any value in the cell which can be identified with this trick. How to do this – Step 1 - Please click on new rule (conditional formatting) under Home tab Step 2 - Select rule type as “Format only cells that contains” Step 3 - Under edit rule section choose blanks from the drop down and click on format and select fill with color of your choice, then click on OK , again click on OK
Post a Comment
Read more

Hide cell contents by changing the cell format (in Excel)

Hide cell contents by changing the cell format (in Excel) Useful in situations where you have a small amount of data you want to hide but still want to be able to work with (and you’re not required to hide the entire column or row). And when you print the data as well the cell hided will not be printed. Step 1 – Select the cell or cells you want to hide. In this example, cell C3 to C6 is selected. Step 2 – Select the option Format Cells or click Ctrl + 1  Step 3 – The Format Cells options will appear; select Custom Step 4 – Type a three semi-colon marks (;) under  Type Step 5 – Select  OK See below, Cell C3 to C6 will appear as hidden (and hidden for printing) but included in the formulas.
Post a Comment
Read more