Method 1 – Using the Filter Feature to Make a To-Do List in Excel STEPS: Click any header cell. Here, I clicked cell C4. Select Home ➤ Editing ➤ Sort & Filter ➤ Filter. Click the drop-down icon beside the Status header cell. Check the boxes On Going and Pending. Press OK...
If you want to add some more information like Discounts, you can add it below the list of prices. Read More: How to Make a To Do List in Excel Step 2 – Creating a Dropdown to Make a Price List in Excel Select the cells of the column Product Code where you want to have the dro...
Now that your Excel sheet is set up, it’s time to add the items to your checklist. Here’s how to do it: Input checklist items: In the first column, list the tasks you want to include in your checklist. Simply click on a cell or use the cell selection button and start typing....
1– How to Freeze Top Row in Excel (Sticky Header) This freeze row example is perhaps the most common because people like to lock the top row that contains headers, such as in the example below. Some people also call this a “floating header” because it always floats to the top as ...
Then let’s learn how to create a graph in Excel. ⭐️ Step 1: fill the Excel sheet with data Start by populating your Excel spreadsheet with the data you need. You may import this data from different software, insert it manually, or copy and paste it. ...
How to Add New Words to Your Spell Check List If Excel keeps bringing up specialized names as misspelled in the spell check, you can prevent it from marking them in the future by adding them to your custom dictionary. There are two ways to do this. First, if Excel brings up a misspell...
How to Create a Checklist in Excel The first step in creating a checklist is coming up with a list of items or activity that needs to be confirmed. Here’s what you should do on the Excel spreadsheet: To open Excel, click on the search button next to the Start menu. Type “Excel”...
One way of doing this would be to select the element in the chart and press the Delete key on the keyboard. However, I prefer to click the Chart Elements button to the right of the chart. A list of chart elements is displayed. Uncheck the Gridlines box. Then position the mouse over...
4. List down the variable (interest rate in this case) that is to be changed. 5. Create a link by referring to the targeted output for each interest rate in the corresponding column. We want Excel to give us the repayments for different interest rates. So, we have created a link to...
How to Create a Spreadsheet in Excel The world’s most robust pure spreadsheet application, Excel, comes as part of both Microsoft Office and Office 365. There are two main differences between the two offerings: First, Microsoft Office is an on-premise application whereas Office 365 is a cloud...