标签：Excel 2016
-
How to Set the Default Font and Size in Excel
You may want to set the default font and size once for all, because it can help to make your workbooks more readable when they are printed. If you are one of those users, who desire to change the default font and size, and select one that better suits your needs, then this post will […]
-
How to Create a Horizontal Bullet List in Excel
Excel comes with a variety of formatting and layout tools to enable you to get work file looking their best and to put across ideas effectively. In the case of bulleted lists, the icon in the SmartArt section lets you define the bullet style and created nested lists. Here I’d like to give a simple […]
-
How to Set Decimal Places in Microsoft Excel
Numbers are displayed with no decimals by default in Excel, but some data need to be set decimal places as the work requirements. So how can we achieve it? The method is simple to follow: 1. Select the data which you want to set decimal places. 2. Go to Home tab, find Number group and […]
-
How to Convert Decimal Number to Binary Number in Excel
Have you ever been bothered by how to convert decimal number to binary number? Fortunately, Microsoft Excel allows to complete the conversion in a simple but effective method. Here is how you can do it: 1. Enter all data of Decimal Number, and select the first row of Binary Number. 2. Go to Formulas tab […]
-
How to Add or Remove Cell Borders in Excel
To add or remove cell borders in Excel, the quickest way is using shortcuts in your keyboad. Try following steps: Add Cell Borders in Excel 1. Select the cell or the range of cells you want to add borders. 2. Then press [Ctrl]+ [Shift] +[&] in your keyboard. 3. Now you can see the borders […]
-
How to Fully Display Long Numbers Over 11 Characters in Excel
Have you ever input long numbers in Excel and only to find the digits in the middle have been abbreviated? It’s actually because of scientific notation, which automatically abbreviates the number over 11 digits in length. So how could we fully display long numbers in Excel? One solution for this situation is converting the property […]
-
How to Insert Page Numbers to Excel Files When Printing
Excel is a powerful tool in which you can process a huge amount of data. But if the file you are editing is so large that you must drag the mouse for a while to view all the content, you may want to add page numbers to the Excel file while printing it out to […]
-
How to Customize the Page Margins in Microsoft Excel
Page margins decide the location and size of the Excel sheet in a printed paper. Just like in MS word, you can also customize the page margins in Excel to make it meet your needs, and thereby print a better document. 1. First, click File in the upper left corner. 2. Next, click Print in […]
-
How to Reduce the File Size of Images in Microsoft Excel
A worksheet will become slow and heavy if there are too many images in the Excel file. We usually collaborate by sending files via email and a large one that weighs 50 MB can be hard to share with your colleagues. There are a few methods to reduce the file size of a worksheet, here […]
-
How to Print Excel Documents in Black and White
Some documents are not suitable for color printing, you may want to set the printer to black and white. So how can we achieve it? Here’s a simple guide. 1. First, click File in the upper left corner. 2. Then, click Print in the left-hand list box. 3. Next, click Page Setup at the right […]
