SORTING

Sorting & Landscape If you want to quickly sort your data on your worksheets Excel provides an easy way to do this. Simply follow the steps listed below. Now you can either select “Sort A to Z” which arranges the date in alphabetical order from A to Z or arranges numbers from lowest to highest. The next choice is “Sort Z to A” which does the opposite. The last choice is “Custom Sort” where you can customize how you want your data arranged. The next thing I wanted to address was an issue I had when I printed out my worksheets. The problem was that my worksheet would get cut off and I could not reduce the size because then the font would be too small to read. The solution to this problem is simple. I hope this helps out those who have come across the same issues. Andres Estrella Info273
 * First have your worksheet ready and input all the data if you haven’t already done so. This can also be used on existing worksheets.
 * Second highlight the data you want sorted. You can do this by clicking before the first cell and then holding shift and clicking at the end of the last cell in the data. You can also do this by clicking on the first cell and simply highlighting the date by dragging your mouse over the data desired.
 * Third go to the ribbon and locate the group “editing” in the home tab. There you should see “sort & filter” by clicking the dialogue box you get several options.
 * First go to your worksheet and click the Page Layout tab on the ribbon.
 * Second click “orientation” in the “Page Setup” group. By clicking “orientation” you should see two options; Portrait and Landscape.
 * Finally by clicking on “Landscape” your page will now print on a wider scale and if you have a wide worksheet now more data can fit on a printed page.