How to unhide rows in Excel

At times, one can hide rows in excel when working on large documents or when hiding information that you do not need at the moment. Like you can quickly hide…

Comments Off on How to unhide rows in Excel

How to flip Excel data

When we talk about flipping, we mean turning something upside down. Flipping data in Excel may seem like an inconsequential one-click process, which is not the case as there is…

Comments Off on How to flip Excel data

How to remove protected view in Excel

Microsoft is working tirelessly to improve services offered to the user by introducing new usability and other security features. These features are vital in protecting and manipulating the document to…

Comments Off on How to remove protected view in Excel

How to create an Excel invoice

Gone are the days of traditional paper invoices. Today businesses can create their invoices in Microsoft Excel for billing their clients for services they offer them. One can either use…

Comments Off on How to create an Excel invoice

How to create a search box in Excel

The search box feature is a function on excel that is used to search anything on the workbook. This feature plays a huge role in the excel world as the…

Comments Off on How to create a search box in Excel

How to copy a row based on a cell value in Excel

It is possible to copy a row based on a cell value while working with Microsoft Excel spreadsheets. Doing this saves you time that you would have otherwise spent scrolling…

Comments Off on How to copy a row based on a cell value in Excel

How to copy an entire row in Excel to another sheet

In excel, you can move or copy entire rows to the destined sheets. (From the source sheet). You can copy entire rows automatically with automatic workflow.   ​Steps on how…

Comments Off on How to copy an entire row in Excel to another sheet

How to change the date format in excel

Dates are one of the most important components that should be included in any document. Microsoft Excel ensures this is achievable and through various formats. However, in the excel platform,…

Comments Off on How to change the date format in excel

How to prevent Excel from rounding off numbers

Microsoft has designed excel in a way that will be efficient and easy to use for its users. However, some of the features of Excel can be counterproductive and thus…

Comments Off on How to prevent Excel from rounding off numbers

How to cross reference data in Excel

Cell reference refers to a unique address. This allows you to reference this cell elsewhere in excel. Cross-referencing is done in the same worksheet, in different worksheets in the same…

Comments Off on How to cross reference data in Excel