Author: Hamza Waseem

Once you have created the Pivot Table, it does not automatically refresh when you add new data or change the existing data. Since your Pivot Table is created using the Pivot cache, when the existing data changes or when you add a new row or column to the data, the Pivot Table does not update itself automatically, and hence, the Pivot Table also does not update. You have to need to force a refresh every time there are changes. Once you force a refresh, the Pivot Table Cache gets updated, which is reflected in the Pivot Table. This is the…

In Windows 10 white theme is painful during night time. Microsoft expanded the dark theme for all parts of the file explorer. This theme gives a somewhat clean dark look to Windows 10. Dark mode changes the appearances of OneNote interface elements from light to dark. It turns your windows black. The dark mode was originally created so that Windows would display less light. This feature also offers up some battery life savings too. Many have found that they prefer to use a dark theme at all times as they like it. You don’t have to be jealous of Mac…

MS Excel provides the ability for cells in one worksheet to be linked with another worksheet. But we can create a link between two worksheets or workbooks to automatically updated data in another sheet if it first worksheets. We can link the worksheet and automatically. The link is a dynamic formula that pulls data from a cell of one worksheet to other worksheets by automatically updated that data. We can link these two worksheets using the below method. First of all, select the text cells, copy the text by right-clicking on any cell and select the copy option. You can…

Excel is a spreadsheet developed by Microsoft especially for Windows and Mac. This program is used for the analysis of numerical data. Most of the peoples use Header and Footer in the document in Excel. The purpose of Header and Footer in Excel is similar to that of Hardcopy documents or books. If you use the Header and Footer in your Excel spreadsheet and you want to remove the Header and Footer from the Excel worksheet then follow the below steps. Click on the Page Layout tab, click on the small square shape dot to open the Page Setup dialogue…

Facebook is the largest social platform in the world. It gives us a very friendly user interface that’s why most of the blog websites use Facebook comments instead of the default comments. WordPress is one of the best blog websites. It also uses Facebook comments instead of its own default comments.  A WordPress plugin is the easiest way to add Facebook comments to WordPress. But there is another way to add comments in WordPress is by using Lazy Facebook Comments. Setting Up Facebook Comments in WordPress If you have a site on WordPress and you planned to add the Facebook…

Flash Fill is one of the amazing features provided by Excel. It grabs a task that would take hours to be performed manually and executes it automatically in a flash. And it does so quickly and simply without you having to do a thing. Flash Fill is a special tool that analyzes the information you are entering and automatically fills data when it identified a pattern. Each time, Flash Fill combines Excel of small programs that might accomplish the tasks. If you want to Flash Fill the Data in Excel then the following examples may help you. Extract Countries from…

Excel is the sheet working application included in the MS Office pack. Excel allows the user to completes your daily tasks more accurately. Insert and delete a new Column or Rows organize your worksheet batter. Column organizes your data in Excel. If you are a beginner with this application then you have to know the simple table manipulation methods in Excel. If you want to insert a column in the spreadsheet then you have to follow the following steps to insert the column in the spreadsheet. Click on the Start button and type the Excel in the screech bar then click on…

When you are collaborating with others on your spreadsheet, inserting comments can save you a lot of time. Instead of the email your comments and feedback back and forth or trying to communicate in the cells of the spreadsheet, you can leave a comment. You can add a comment to cells. When a cell has a comment, an indicator appears in the corner of the cell in red color. If you want to insert a comment in a cell then follow the below steps. Open the Excel by tying the Excel in the Start menu. Then open the Blank Sheet…

When you install any application or software it contains many languages. The chrome browser also comes with hundreds of languages. When you change the language of the chrome browser, it will impact every setting and menus within the browser. After using a chrome browser in the English language for a while, you might want to change the Chrome browser’s display language. You can also change the language to your mother language if supported, even if you accidentally change the display language of your chrome browser. If you want to change the language of your chrome browser then follow the following…