Planning Prevails

In this function, we will learn how to repeat rows at the top of each page when the pages are printed without adding a header. For this story, I would like to have the title,  The Wizard of Oz ,  at the top of each page when it prints without me having to type it at the top of each page. Click on  File . Then click  Page Setup . Once you click on Page Setup a dialog box will appear. At the top of the box, there will a tab Sheet . Click on Sheet . Second option down is Print Titles . Click in the address bar for Rows to Repeat at top: Once you click that box, click on the 1st row of the page which contains the title. Click OK . The title will show at the top of each page when printed. If you would like to check to make sure you did it correctly, click Print . Use the arrows at the top of the preview to move to the next page. If done correctly, it will show on all pages here.

Using filters in Excel can make looking for multiple items that are in the same column easier to find when not in order. Here is a list of bills in chronological order. We are going to use filters to find all bills paid through Entergy. Highlight Row 1  for the columns that you want filtered. Click Sort & Filter , then click Filter . There are now drop down boxes at the top of each column. Click on the arrow for Item . Click Select All  to deselect all items. Click on Entergy . Then click anywhere on the sheet to close out the box. Now we have all items that have been paid to Entergy. To reset the selection and have it unfiltered. Click back on the arrow and click Select All . 

Let's go through the steps of sorting columns in Excel. You typed in a list of names and realized you forgot to alphabetize them.  Here we have a list of names, cities, and states that are not alphabetized. We are going to sort by last name. Highlight all columns you have on your spreadsheet. In this case, we are using A, B, C, D, E. It is important to highlight all columns unless there are columns you do not wish to have sorted with that item.  If you do not highlight all columns and you sort, it will only sort that column and will not move all other information associated with that person, city, or state. Since we want the numbers to stay in order of 1-20, we can leave out column A.  In the toolbar, we are going to click on Sort & Filter . Then click on Custom Sort. This box will pop up. Click   Sort by . Click Last Name . Click OK . You have successfully alphabetized by last name!

Are you trying to figure out how to set up addition  formulas in Excel? Maybe you are trying to set up a user-friendly budget or trying to keep track of an event coming up.  These super easy formulas will help you accomplish just that. First, you can type in =SUM to begin this formula  or you can click the  fx  next to the address bar. Next, we begin by either typing in the cells we would like to add together. Make sure when you are finished adding all cells together, you add the closed parenthesis at the end. If you do not do this, you will receive an error. For this particular formula, it will look like this once completed. =SUM(A2:B2) Let's say you are wanting to only add particular cells together, not wanting to include some. You can do that this way: I manually typed in =SUM( then clicked on the cells I wanted to add making sure to put a +  between each cell. If you were wanting to subtract the cells, you could put a -  between each cell. In...