标签:Excel
-
How to View and Delete the Recent Documents History in Office Apps
Microsoft Office programs, including Word, Excel, PowerPoint, etc. enable you to view the recent documents you’ve viewed or edited. You can conveniently click any of them to read or revise. But if there’s someone else using your computer and open an Office file, he or she can see your history as well. To better protect […]
-
How to Prevent Entering Duplicate Data in Microsoft Excel
When processing data with Excel, sometimes duplicate data might lead to incorrect results or even serious consequences. We have already learned how to delete or merge the duplicate cells before, but it is actually possible to be prevented from the very beginning. This little trick demands Excel to auto alert you every time when entering […]
-
How to Shrink the Text in Excel Cells to Fit the Column Width
When the text is too long to be fully displayed in an Excel cell, you can use AutoFit feature to enlarge the cell to fit the contents, but it could result in too much blank space in the rest of the row and does not meet the requirements for files in a specific format. Here […]
-
How to Repeat a Print Title on Each Page in Microsoft Excel
If there’s too much data in an Excel spreadsheet, it will inevitably be divided into several pages when printing. And it might be difficult to figure out the corresponding meaning or description of each value. The best way to avoid this kind of trouble is to repeat a print title on each page. 1. First, […]
-
How to Converted Decimals into Fractions in Microsoft Excel
When you are processing data in Microsoft Excel, the results of calculations or the numbers you need to enter won’t always be integers. So, if you’ve got a batch of decimals in the worksheet, how can you convert them into fractions or vice versa? There’s 2 commonly used methods: 1. Percent Style First, select all […]
-
How to Insert Alternate Blank Rows in Excel Spreadsheet
It’s not rare to insert a blank row between 2 existing rows as a new header while making specific spreadsheets like salary sheets. Instead of right-clicking one cell and choose to insert a new row manually, you can actually batch create new rows alternatively using AutoFill and Go To feature of Excel. Open the worksheet […]
-
How to Add a Number to All Cells in Excel
While editing a spreadsheet in Microsoft Excel, you may encounter a situation which requires you to add a number to all cells in a column or a table. Doing the calculation manually and filling the cells one by one is apparently not the best idea. In fact, you can use Paste Special to achieve this […]
-
How to Use Conditional Formatting to Shade the Specified Data in Excel
The so-called Conditional Formatting, is a practical feature with which Excel can set the format of the corresponding data. One example is that when you want to highlight some specified data in a spreadsheet, you can use Conditional Formatting to shade them automatically avoiding a lot of manual operations. First, select the range of cells […]
-
How to Print a Part of a Spreadsheet in Microsoft Excel
Printing out a spreadsheet in Excel may not be a hard thing for you, but there’re also some tips can make you do the job better. For example, if you just want to print a part of the table in the worksheet, and it can hardly fill the width of a A4 paper, you’d better […]
-
How to Add Frames to Pictures in Microsoft Office
To make some basic adjustments to pictures that you want to insert into Office programs, you don’t need to find any third party picture editing tools, MS Office can help you do most of the things. And the steps are all the same in Microsoft Word, Excel, and PowerPoint. For example, if you want to […]