Categories：Excel Tips
-
How to Change the Theme Color of Microsoft Office
For many office workers, processing data and editing documents with Microsoft Office tools is not a temporary task but daily routine. No matter what are we working with, Word, Excel, PPT or Outlook, the interface layout and color schemes are all similar to some degree. Looking at them for a long time can be very […]
-
How to Hide and Restore Gridlines in Microsoft Excel
When working with excel, sometimes you may want to hide the gridlines before printing the sheet, or the sheet you received have no gridlines which should be restored. Here I’d like to give a simple guide of these two cases. First, click File in the upper left corner. Next, click Options in the bottom left […]
-
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 Copy Excel Tables of Charts as Pictures
People who often works with Excel may have the requirement to display tables or charts to others on different devices. Using screenshots seems like a good idea but the captured pictures are usually not that clear. I can’t stop wondering, is there any way to copy tables or charts in Excel as pictures directly. In […]
-
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 […]
-
How to Place Text on Top of a Picture in Microsoft Word
As we all know, Microsoft Word is a powerful text editing tool. But we can also design simple pictures with it. In this post, I’d like to share a tip about inserting text on top of a picture in Word. First, insert a picture to the document. I’ve introduced the method before: Click 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 […]
-
How to Generate the Sequence Numbers automatically in Excel 2016
For a worksheet with sequence numbers, inserting a row into it means re-numbering the sequence column. Not only inconvenient to operate, but it takes a lot of workload to modify them. So how can we achieve it? Here’s a simple guide. First, enter all contents you want to generate the sequence numbers. Then, enter the […]
-
How to Subtract in Excel 2016
In the previous post, you know how to calculate the summation in excel, and what about subtraction? Surely we can use the formula for it, and let’s check it out. Enter all numbers you want to subtract, here we calculate the value of column A data subtracting column B data and place the difference in […]
-
How to Set and Clear the Print Area in Excel 2016
Sometimes you may not want to print the entire form, is there any method to define the specific print area of your need? Here I’ d like to share the tip of setting and clearing the print area in Excel. First, select all texts you want to set as the print area. Then, find Page […]
