Microsoft Excel

ยปTag: Microsoft Excel

How To Create Barcode In Excel Without Third Party Software

A barcode is a series of lines with varying width that hold any type of information. Nowadays, barcode has been widely used to track from individual items to large stocks of thousands or even millions of items. [...]

By |2017-08-16T14:22:10+08:00August 16th, 2017|Categories: Office|Tags: , |0 Comments

Some Files Can Contain Viruses or Harm Your Computer on SharePoint & OneDrive with Office

When opening, creating or saving an Office document, spreadsheet or presentation on SharePoint Document Library or Microsoft OneDrive (can be part of Office 365 service) with Microsoft Office applications such as Word, Excel or PowerPoint , the [...]

Suppress & Hide Formula Cell Value Error in Excel

When using many formulas in the workbook of Microsoft Excel, the spreadsheet may display error for formulas that do not return proper values or results. For example, the cell displays #N/A for value not available error, #DIV/0! [...]

By |2017-01-20T00:57:40+08:00January 20th, 2017|Categories: Office|Tags: |0 Comments

Sum the Total of Same Cell on All Worksheets in Excel

In Microsoft Excel spreadsheet software, there may be a need to sum the total of a cell in all individual worksheets to display in a master sheet. For example, you have 12 worksheets that contain sales figure [...]

By |2016-12-10T21:41:07+08:00December 10th, 2016|Categories: Office|Tags: , |0 Comments

Delete a Defined Name & Named Range in Excel

Microsoft Excel is the powerful and advanced spreadsheet application which comes as part of Microsoft Office. EXcel allows users to define name for individual cell, cell range, function, constant or table in order to be used in [...]

By |2016-12-09T08:38:16+08:00December 9th, 2016|Categories: Office|Tags: , |0 Comments

How to Disable Recent Documents / Workbooks / Presentations History in Office Excel, Word and PowerPoint

Expanded Recent Documents, Recent Workbooks and Recent Presentations history list in Microsoft Word, Microsoft Excel and Microsoft PowerPoint of Office 2007, Office 2010, Office 2013, Office 2016 is useful as a quick shortcut to open recently used [...]

Clear and Delete Recent Documents / Workbooks / Presentations List in Office 2007 / 2010 / 2013 / 2016 (Word, Excel, PowerPoint)

Beginning from Microsoft Office 2007, Word, Excel and PowerPoint uses new Office Fluent Ribbon user interface with a big right pane section of the Office or "File" menu been devoted to "Recent Documents", "Recent Workbooks" or "Recent [...]

Insert and Fill Random Filler Text and Lorem Ipsum Into Office Word, Execel and PowerPoint

You can consider this an Easter egg of Office 2007, Office 2013, Office 2016 and later versions of Office productivity suite, or some hidden functionality in Word, Excel, and PowerPoint that let you impress your peers how [...]

Remove Excel Workbook or Worksheet Lost Password for Free

It's possible to protect Microsoft Office Excel worksheets and workbooks from unauthorized changes with password. But, what if you forget or misplace the password? If you can't remember or recover the password, the Excel data might become [...]

By |2016-12-09T08:43:24+08:00December 9th, 2016|Categories: Office|Tags: , |61 Comments