You can also sort it numerically, alphabetically, and in many other ways.īefore sorting the data, you must first decide if you want to sort the entire spreadsheet or just a particular column. For instance, you can sort your list of products by its suppliers. Sorting your data helps you to reorganize your spreadsheet quickly. You can use this video as your guide in freezing your row or column: Select the Freeze Pane dropdown and choose “Freeze Panes.” If you prefer to freeze columns, you must select the cell to the right of the column that you want to freeze. Select the row below the row or rows that you want to keep visible. Aside from allowing you to compare different columns or rows in a long spreadsheet, the Freezing Panes command also keeps the essential details in view. You must take note that under the Freezing Panes command, you can choose the “Freeze First Column” or “Freeze Top Row” if you want to keep the leftmost column/row visible when you scroll. Helpful Tools in Data ManipulationĮxcel’s freezing panes allows you to lock specific rows so you can still see them even when you are scrolling. Continue reading and check out the following tips. Whether you are a business owner, freelancer, or an employee, these tips can make your life easier if you take time to learn it. In this article, you will learn some beneficial tips in manipulating data in your spreadsheet. If you are one of those people who wish to enhance their skills in Excel, then you are in the right place. Learning techniques in Excel data manipulation can save time and lessen your stress at work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |