In Excel, How to add plus sign before the number in Excel

How to add plus sign before the number in Excel

Excel is a great management tool that makes it easier to work with documents and large data files. Despite this, there are a few features in excel that may irritate you sometimes. One of these is adding a plus sign before a number. Microsoft Excel displays the negative numbers with a minus sign while the … Read more

In Excel, How to AUTOFIT text to rows/columns

How to AUTOFIT text to rows/columns

Any excel user already knows the application has a certain column width and row height by default. Also, when you try entering any data that exceeds the provided size, it spills out of the cell. Under such circumstances, you can adjust the rows and columns to fit the text within the cell. You can achieve … Read more

In Excel, How to sum only positive or Negative numbers – Formula

How to sum only positive or Negative numbers – Formula

When working with Excel datasheets, you may often need to conditional add the data. You may need to sum only the positive numbers or sum only the negative numbers in Excel. It can easily be done using the built-in formulas within Excel. Below, we guide you on how to do this. Let's look at the … Read more

Excel How to Find Missing Numbers in a Sequence

Complete guide on Excel How to Find Missing Numbers in a Sequence

Sometimes we have a long list of sequence numbers to mark items or commodities, like having check numbers in bank statements. Most people scroll through the whole list to locate missing numbers. It is tiresome and consumes a lot of time. Using excel 2007, 2010, and 2013, it has tricks to get the missing number … Read more

In Excel, How to copy the conditional formatting to another cell

How to copy the conditional formatting to another cell

Microsoft Excel is a powerful tool in any organization. The application offers users many features and inbuilt tools that make working with large data sheets easier. It has formatting features that make important highlighting data in your document easier and more accessible to clients. One of these features is conditional formatting. Conditional formatting is useful … Read more

How to Fix the Arrow Keys Issue in Excel – Moving Pages Instead of Cells

How to Fix the Arrow Keys Issue in Exce

Sometimes, the arrow keys in Excel can misbehave and fail to function as you want. For instance, you expect the arrow keys to go to the cell you have hit up, but the cursors fail to move completely. On most occasions, the worksheet page will always scroll while the cursor, on the other hand, looks … Read more