How to delete an Excel sheet

Excel workbooks can contain a large number of different worksheets. Combining all your worksheets in one workbook makes it easy to navigate between them, making data referencing easy and fast.…

Comments Off on How to delete an Excel sheet

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 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 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

How to link information to another worksheet

Let's say you have data in one worksheet and you want to link the same data to another spreadsheet to use it; it's easy. Sometimes you can copy and paste,…

Comments Off on How to link information to another worksheet

How to add a ghost cell in Excel

A ghost cell is a cell that appears empty but contains some data. Creating Ghost cells in excel is possible, and users can use this feature to hide any data…

Comments Off on How to add a ghost cell in Excel

How to change excel from read only

Having done all required in your excel file and content to have everything on board, excel must provide an excellent feature called the read-only. The read-only helps marks the excel…

Comments Off on How to change excel from read only

How to recover permanently deleted Excel files

At times a Microsoft excel user may permanently delete their excel file; after all, accidents happen from time to time. It may happen accidentally or unknowingly. Losing important Excel data,…

Comments Off on How to recover permanently deleted Excel files

How to recover an unsaved Excel file

Any Microsoft Office Suite user experiences déjàvu when they realize they failed to save their work. Unfortunately, it is easy to lose or forget to save your file unexpectedly. It…

Comments Off on How to recover an unsaved Excel file

How to make a spreadsheet searchable in Excel

Microsoft Excel is a good tool when creating reports, forecasts, and budgets. Most companies excel reports tend to be large hence becoming hard for one to locate certain things. To…

Comments Off on How to make a spreadsheet searchable in Excel