标签：Excel 2016
-
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 Paste Data Skipping Blanks in Microsoft Excel
Copy and paste is a basic operation in Microsoft Excel that should be familiar to everyone. But what if you need to copy a column of data with blanks to another column? If you copy it directly, the data in the target column would be overwritten by the blanks. You can also, of course, copy […]
-
How to Change the Default Save Location in Microsoft Excel
When you done with a workbook and save it, Excel will save it to My Documents folder automatically. But sometimes you need to save the workbook to another folder which is more consistent with the use of your habits. In this case, you need to select the correct location in the Save As dialog box, […]
-
How to Change the Color of Tabs in Microsoft Excel
The color of inactive sheet tab is gray, and active or selected sheet tab is white by default in Excel. If you have a lot of sheets to deal with, it might be hard to find a specific one quickly. In this case, you could change the color of tabs to differentiate sheets. So how can […]
-
How to Search Data in Microsoft Excel
This might occur to you some time when you use specific data incorrectly while working with Excel. What’s worse, the data reappears in the file irregularly, which means you will spend a lot of time searching and modifying. Here I’ d like to share the tip of how to search data in Excel. Here’s the […]
-
5 Practical Excel Functions to Improve Your Working Efficiency
Microsoft Excel is a widely used office software which you must have tried or at least heard in life. It’s convenient, powerful and also complicated for some newbies since there seems to be too much to learn. They may end up doing repetitive work manually without knowing how to use Excel formulas to complete their […]
-
How to Capitalize the First Letter in Microsoft Excel
When working with Excel, sometimes the data may not be very consistent when it comes to upper and lower case letters. But do you know how to capitalize the first letter? The method is also simple. Enter all data and select the first row of which you want to capitalize. Next, find Formulas tab, click […]
-
How to Insert an Excel into Another Excel File
If you’re doing a work that involves a huge amount of data, a single excel sheet can hardly meet your need. Try inserting an Excel file into another. It may enrich the information and work as a reference or an addition. First of all, click any cell in the sheet you are editing. Choose Insert […]
-
2 Tips to Alternate Colors for Rows and Columns in Excel
You must have seen some Excel spreadsheets with alternating colors in rows or columns. It can make the data more vibrant and easy to distinguish. Here I’ll introduce 2 commonly used methods to make a table like this. How to Shade Every Other Row in Excel with Conditional Formatting 1. First, select the range of […]
