How to make a small number in Excel

How to make a small number in Excel

If you are an avid user of Microsoft Office, then you have an idea of small numbers. Most users sometimes wonder why a particular feature may be in one Microsoft Office application and missing in another one. In this case, the small number is one of them. When working with Ms. Word, it is easier

How to lock cells in Excel – Complete Guide

How to lock cells in Excel

Other than the read-only, which prevents editing, typing, commands, and proofing marks accidentally, another protective feature that excel has is the locking of cells. This feature in the excel spreadsheet prevents the change of any data or formulas hosted in these cells that are locked. The user who locked cells can unlock them if there

How to turn data into a line graph in excel

How to turn data into a line graph in excel

When you're working on data on excel, you may wish to convert it into a chart. Line chart/graph is one of the common and most frequent methods of representing data on the excel platform. It helps to show the trend of a commodity or thing over time, and therefore, it can be used in drawing

How to graph two lines in Excel

How to graph two lines in Excel

Drawing a graph that comprises two lines in excel is possible. One of the advantages of using excel as your spreadsheet is that you can display two unique data sets. It provides a basis for comparing two things in that they can be plotted on the same plane. This excel tool may be beneficial in

How to Extract Date From a Text String in Excel

How to extract date from a text string

You might find yourself working with spreadsheets that have jumbled up data. For example, a single cell holds up all of your information instead of distributing it among different cells or adding columns. You might also come across data from another system where Excel does not easily recognize the dates. It can be hard when

How to search for a phrase in Excel

How to search for a phrase in Excel

When working on an excel workbook, you may need to search for a particular phrase within the sheet. Going through the excel document word to word looking for that phrase may be tiresome and overwhelming. Thankfully, Excel allows its users to search for any word or phrase within the workbook easily. Through this feature, users

How to Remove Characters in Excel Cells

How to Remove Characters in Excel Cells

Formulas are key in getting things done in excel. One can apply formulas to manipulate texts, work with dates and time, count and sum with criteria, create dynamic ranges, and dynamically rank values. Explained below are formulas one can apply to remove characters in excel cells. 1. The Array Formula Assuming we want to eliminate

How to enable scroll for worksheet tabs

How to enable scroll for worksheet tabs

Worksheet tabs are found in Excel. Excel is a spreadsheet program under Microsoft's Office suite. It is a program used in many industries to perform everyday office tasks. Despite its easy and simple interface, some people find it difficult to access the scroll tab in their worksheets. Apart from this, imagine you are working with

How to modify the data for a chart in excel

How to modify the data for a chart in excel

Excel charts are simple and easy to construct. Since they are automatically drawn, they are less prone to errors that may occur during hand drawing. They are more presentable because they are neat and more visible as compared to hand-drawn charts. After your chart appears on the excel screen, you may need to edit or