• How to Insert a Picture as the Background of Excel

    Date:2020-4-5 Author:Cordelia

    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

    Date:2020-4-4 Author:Cordelia

    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

    Date:2020-4-3 Author:Cordelia

    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

    Date:2020-3-29 Author:Cordelia

    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

    Date:2020-3-27 Author:Cordelia

    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

    Date:2020-3-22 Author:Olivia

    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

    Date:2020-3-21 Author:Cordelia

    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

    Date:2020-3-1 Author:Olivia

    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

    Date:2020-2-29 Author:Cordelia

    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 […]

  • How to Replace Specific Content in Excel Sheets More Precisely

    Date:2020-2-22 Author:Cordelia

    Imagine that you have a grade table and need to replace all the “0” scores in it with “Fail”, how can you do it without replacing the “0” in other values like 60, 70? Is there a way to replace the specific content in Excel Spreadsheet more precisely? It’s a tricky situation cause normally the […]