Do want to track changes in excel? We often share our excel spreadsheet with other people to overview it or if required make some changes or updation to it. To know what changes have been made to your excel spreadsheet by others, you can turn on tracking. As soon as the tracking of an Excel sheet is turned on, it becomes the shared workbook to which multiple users can make changes and those … [Read more...]
How to Spell Check in Excel?
In excel we don’t write text in sentences or paragraph. The main motive of using excel is to store data or information in tabular form so there is not much need for spell check in excel. Sometimes people even forget to check spellings in excel. The spell check in excel is not similar to spell check of MS Word. Excel never highlight the incorrect spelling by underlining it with the red wavy … [Read more...]
How to Change Default Font in MS Word
Each time when you create a new MS word document you have to adjust the font type, font style, font size, colour of the font, the effect of fonts and many more. Doing this each time may be a little annoying. MS Word allows you to change default font settings. In this section, we will discuss how you can change the default font set by MS Word and make it a way you like. You can make your … [Read more...]
How to Create Named Range in Excel?
It easy to use a cell or the range of cells by a name instead of their references. In excel we can create named range which makes the working in excel easier. However, using the named range also saves our time and provide efficiency thereby avoiding mistakes which occur while typing the reference for the range of cells. In this section, we will discuss the steps to: Name a Single Cell … [Read more...]
How to Lock Formulas or Cells in Excel?
Sometimes we share our excel sheet with others but we don’t want others to edit it. Or we want to prevent the sheet from getting edited mistakenly. Sometimes the Excel sheet may have formulas in some cells which when edited mistakenly may lead to the wrong result. Excel provides us with the facility to lock formulas or cells in the sheet. All the cells of an excel sheet 'by default' are … [Read more...]
How to Create a Graph in Excel?
A graph helps us to visualize the data in a better way as we are able to recognize the hike and fall down events very easily. This helps the viewer to analyse the data and take further crucial steps. Excel provides us with an easy way to create a graph and it also provides the tools to upgrade the graph. In this section, we will discuss the steps to create a graph in Excel. We will also explore … [Read more...]
How to Hide Formula in Excel?
In excel when you click on any cell it’s content are displayed on the formula bar. Sometimes, we want that formula applied to a cell must not be visible in the formula bar for the sake of protection. Excel allows us to hide the formula applied to any cell and you can even make that no one is allowed even to click on the cell. That means you can restrict the permission to access the cell. To hide … [Read more...]
How to Merge Cells, Columns & Rows in Excel?
Whenever we create any data in an excel sheet and we want to provide it with a title which must be centred over the entire range of the data, we have to merge cells of that particular section. The Merge & Centre option of Excel merges all the cells of the selected range and only the text in the upper left-most box is preserved and is placed at the centre of the merged cells. In this … [Read more...]
How to Concatenate Multiple Cells in MS Excel 2016?
Concatenate is a text function which is used to concatenate multiple cells in excel. The Concatenate function does not provide the delimiter. Like, it does not provide spacing between the texts that you want to concatenate. The Syntax of the Concatenate function is given below: =CONCATENATE(text1, [text2],......) In the above syntax, text1 is the first item to consider while … [Read more...]
How to Create a Pivot Table in Excel?
The pivot table in Excel which allows you to arrange and summarize the complex data easily. You can create a pivot table within a few seconds without worrying about any formula. There are many advantages of using the pivot table as it fast and flexible. Below are the benefits of using the pivot table. Benefits of Pivot Table: A pivot table allows you to summarize and calculate the data … [Read more...]
- « Previous Page
- Next Page »