标签：Excel
-
How to Encrypt Your Excel Workbook with Password
An Excel File may contain some important data and information. To prevent peeking, you can encrypt the Excel workbook with a password to protect the data in it. Just follow these steps: 1. Open the file you want to encrypt. Click File on the top-left corner of Excel, tap Info on the left sidebar and […]
-
How to Insert a Picture as the Background of Excel
Working on the same sheet all day long and dealing with tons of data can be very exhausting. You may consider bringing some new colors to refresh the tired eyes. Changing the background seems like a good idea. 1. Switch to Page Layout tab and click Background in Page Setup section. 2. Then a window […]
-
How to Find the Maximum or Minimum Value in Excel
To find out the Maximum and Minimum value in a long list of data in Excel, one effective way is sorting data at first and then find the one you want in the beginning or in the end. But if you don’t want any change to the order of the data, there’s another simple method. […]
-
How to Clear the Format of a Table in Microsoft Excel
Sometimes you may not be satisfied with the current format of an Excel sheet and want to reconstruct it from the beginning. Clearing the format at once is the best idea at this point comparing to cancel each operation you’ve done. So how to do it exactly? 1. Drag your mouse to select the whole […]
-
How to Enable Autosave in MS Excel to Protect Your Data
An Excel sheet containing many complicated data can take much of your time to deal with. If there’s any emergency happens in the process of editing it like power outage, switch trip or system halted, your effort may lead to no end. Therefore, we better enable the autosave feature in Excel. 1. Click File, and […]
-
How to Screen Out the Specific Data in Excel
In a large, complex Excel sheet, you can find the data meets your criteria quickly through the powerful function called Filter, while other data that doesn’t meet your need is automatically hidden by Excel. How to screen out the data that equals/larger than/smaller a specified value Using the Filter function, you can screen out all […]
-
How to Create an Inverted Histogram in Microsoft Excel
We have shared the method to make a histogram in Excel in previous post, but sometimes you might need to personalize it for special display purpose. Just follow these steps and let’s see how to create an inverted histogram in Microsoft Excel. 1. You got an original histogram in Excel worksheet, and here I take […]
-
How to Input the Same Content in Different Excel Cells or Sheets
While editing a table in Excel, it’s hard to avoid a kind of situation which requires you to input the same content in different cells or even different sheets. In this instance, using shortcut keys or shortcuts could greatly improve your efficiency. 1. Select all the cells you want to input the same content in, […]
-
How to Check Correctness of Words in Microsoft Excel
Hate to do error checking? Too many words to check? Is there a method to check correctness of words in a quick way? Here’s a simple guide for you to built a perfect worksheet in Microsoft Excel without any mistake. Below is a sample of worksheet in Excel, and there are spelling mistakes in every […]
-
How to Insert Pictures to a Microsoft Excel File
Besides texts and numbers, we can also insert multi-media files, like images to make the worksheet more vivid and informative. In this post I’ll share a simple tip to add pictures to Excel file, here are the steps: 1. Open a worksheet, click any place at the page you want to insert a picture. Then […]
