Mar 11, 2011  Arial Renaud teaches you how to Freeze Row's and Column's in Excel 2008 for the Mac. Lock Rows and Columns with Freeze. Excel Tips 18 - Quickly Sort Data Alphabetically. Jun 19, 2017  Open the dropdown under the ‘Row’ column and select the row you want to sort data in. Open the Order dropdown and select how you want to sort the data in the selected row. You can sort the data by values, cell color, font color, and cell icon. Click Ok to sort the data. This will not change the default sorting criteria in Excel.

Related Articles

• 1 Automatically Sort a List Alphabetically in Microsoft Excel
• 2 Make Sortable Headings in Excel
• 3 Show Rows in OpenOffice Calc
• 4 Can't See Columns in Excel

It's often useful to freeze header rows in place in Microsoft Excel to remember what type of data is in various columns as you scroll or search through a lengthy spreadsheet. You can also make sure these headers are omitted and left in place if you use Excel's sort functions or order the rows in your spreadsheet using an Excel alphabetize formula.

Hello!Sysmac Studio is Omron’s newly launched software. Mitsubishi plc software for mac. Especially, this software is a general design software for PLC programming, HMI connecting and parameter setting for inverter, servo, and vision. This is a package of integrated design features with a beautiful interface and easy to use.

Tip

• Use Excel's 'Freeze Panes' functionality to lock rows or columns in place. Use Excel sort features to organize data in alphabetical or numerical order.

How to Have Excel Freeze Row and Column Data

It's often useful to freeze header rows or columns in Excel while navigating through a spreadsheet. Otherwise, you may need to repeatedly scroll to the top or left of the sheet to remember what's in what row or column.

To do this, use Excel's Freeze Panes function. If you want to freeze just one row, one column or both, click the View tab, then Freeze Panes. Click either Freeze First Column or Freeze First Row to freeze the appropriate section of your data. If you want to freeze both a row and a column, use both options.

If you want to freeze more than just one row or one column, click the cell in the spreadsheet that's just to the right of the last column you want to freeze and just below the last row you want to freeze. Then, click the View tab and Freeze Panes. Click Freeze Panes again within the Freeze Panes menu section.

Have Excel Sort Data

Excel can sort data in a spreadsheet in alphabetical or numerical order.

Often, you'll just want to sort all of the data in a spreadsheet except for the header by the values in a certain column. To do this, use your mouse to click on and select a cell in the column you want to sort by. Then, click the Data tab. Click the AZ button to sort the data in alphabetical order, or in numerical order from smaller numbers to larger ones. Or click the ZA button to sort in the opposite order, so larger numbers and words later in the alphabet come first. Generally Excel will detect if there are headers present and leave those rows frozen.

If you only want to sort a portion of the spreadsheet, select the relevant section, including any headers. Then click the Sort button in the Data tab. Use the drop-downs to select the column or columns to sort by and check the box 'My data has headers' if that applies. Use the Order drop-down menu to choose which order to sort the data in, whether largest to smallest or smallest to largest. Click OK when you are done.

You can also use the Sort button for greater customization when you're sorting an entire spreadsheet or if Excel is not detecting your header row for some reason.

If data are grouped together by row, you generally will want to sort the entire spreadsheet, or at least each column in a set of rows, so that data remains grouped together rather than having some columns sorted and some not.

About the Author

Steven Melendez is an independent journalist with a background in technology and business. He has written for a variety of business publications including Fast Company, the Wall Street Journal, Innovation Leader and Business BVI. He was awarded the Knight Foundation scholarship to Northwestern University's Medill School of Journalism.

Choose Citation Style

Data that is being manually entered, or even data that you are copying from another location, is rarely sorted in the manner in which you need. This can make it difficult to read the spreadsheet or find that one piece of data that you need. Fortunately you can sort your data in Excel for Mac 2011, allowing you to organize data alphabetically, numerically or even by cell or font color.

How to Sort Data in Excel for Mac 2011

Sorting data in Excel for Mac is a very efficient and helpful tool. I find that it is among the tools I use most often in the program. Whether you need to group similar data, or you want to be able to look at a list of products by their item number, effectively sorted data can be a real time-saver. So continue reading below to learn how to sort in Excel for Mac 2011.

Step 1: Open your spreadsheet in Excel for Mac 2011.

Step 2: Use your mouse to highlight the data that you want to sort. Note that you can also click a column heading to select the entire column.

Step 3: Click the Data tab at the top of the window.

Step 4: Click the Sort drop-down menu in the Sort & Filter section of the ribbon, then click the manner in which you want to sort your data.

Note that the Color on Top, Font on Top and Icon on Top options will sort your data based upon the value that is in the topmost selected cell. For example, one of my screenshots above shows two cells with yellow backgrounds. If I were to sort with the Color On Top option, the selected data would be sorted so that the yellow cells were on top.

If you need to install Office for Mac on another computer, or if you also have a PC that needs Microsoft Office, you should consider getting a Microsoft Office subscription. It allows for installation on up to 5 computers (any combination of Macs and PCs), and includes all of the programs included in the Microsoft Office suite.

If you have to print a lot of your Excel spreadsheets, it is important to know how to print with gridlines. This makes it easier for people to tell which cell of data belongs to which row or column.

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.