Home Office

Office

How to round numbers in Excel with ROUND, ROUNDUP, ROUNDDOWN functions

If you don't want to display decimal values in Excel, you can simplify your numeric data with the ROUND functions. Excel provides three functions:...

How to Add and Delete rows and columns in Excel quickly

Even if you are a careful planner, you will probably decide to change your Excel spreadsheet's layout. Maybe you want data in another column...

How to display the formula EXCEL 2013/2016/2010

Many users have encountered such a problem. When working with tables, it may be necessary to view cells containing formulas to calculate data. While...

How to make slides run automatically in Powerpoint 2007, 2010, 2013

Before the slide plays automatically, you need to set the Powerpoint that you want to run automatically. Autorun PowerPoint presentations have controls in the...

How to fix the links that don’t open in Outlook 2016 and earlier versions

Many users experience the problem when trying to open links (hyperlinks) from within Outlook email. Most affected users reported that this particular issue occurred...

How to use Sparklines in Excel (Insert chart into Excel spreadsheet)

Excel Sparklines was introduced in the version of Excel 2010. It is a small line chart that can be easily embedded with text and...

How to use the SUMIF and SUMIFS functions in Excel

As the name suggests, the SUMIF and SUMIFS formulas combine the SUM and IF functions. In plain English, this implies that these functions can...

Delete blank lines in Word 2016, 2013, 2010,

If you copy and paste a large portion of text in a Microsoft Office Word business document, all blank lines are also pasted into...

Lock Excel cells with formula to prevent editing

When you create an Excel spreadsheet, sometimes you need to use a calculated formula, and you don't want others to change, edit, or delete...

Insert Diagonal Line Into Table In Word

A diagonal lineĀ is used to divide the table's header cell and name the row or column. It can make the data in the table...

How to Delete horizontal lines in Word

In MS Word, if you type three consecutive dashes and press the Enter key, a horizontal line is inserted in its place. This horizontal...

How to Add Page Numbers to Word 2010, 2013, 2016 – Office 365

You can number the index pages with Roman numerals (eg "i", "ii.", "Iii"), and the main document has Arabic numerals (eg "1", "2" "3")....

Most Read

How to enable the virtual keyboard (On-Screen Keyboard) in Windows 10 fast

Instructions on how to open an On-Screen Keyboard in Windows 10 with six ways available when you want to enable On-Screen Keyboard (as shown...

4 Ways to Open Computer Settings (Settings) in Windows 10

To open Windows 10 Settings (see figure below), there are three methods for your options.4 ways to open Settings in Windows 10: Method 1: Open...

How to upgrade to Windows 10 from Windows 8.1

Windows 10 has officially launched in 190 countries; you need to see a message to upgrade. If not, you can always download the Windows...

Fix missing option "Pin to Start Menu" in Windows

All of you already know about the " Pin to Start Menu " option in Windows, which allows us to pin a menu program...