When you are working with a large spreadsheet in Microsoft Excel, it's easy to find yourself scrolling down or across and losing track of where you are. This lesson explains how to freeze rows and columns (officially known as 'Freeze Panes') in Excel 2010 for Windows and Excel 2011 for Mac. Why you might need to freeze rows or columns in your spreadsheet • Imagine you have a spreadsheet that contains sales data for January. We welcome your comments and questions about this lesson. We don't welcome spam. Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. Sorting data in Excel for Mac is a very efficient and helpful tool. 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. Remote access for the mac. Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through. We know that bots don't read messages like this, but there are people out there who manually post spam. I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. So don't waste your time, or ours. Hi LR I know your pain. I have an Excel spreadsheet that does this to me as well. ![]() Not sure if it's a Mac thing, but it's an old Excel for Windows spreadsheet that I transferred to the Mac. Oddly, I don't have that problem if I create a new table in the Mac version. Three ways to do what you want: • Enable Autofilter for the table, and then use the Sort option within the Autofilter dropdown on the column you want to sort. • Do an Custom Sort and specify that ' My list has headers'. • Convert the data to an Excel Table. Click inside the data (make sure Autofilter is off), click the Tables ribbon option, then click the New table button (the first button on the Tables ribbon). This will convert it to a Table and sorting should respect the headers. I hope that helps! If you are working on a large spreadsheet, it can be useful to “freeze” certain rows or columns so that they stay on screen while you scroll through the rest of the sheet. As you’re scrolling through large sheets in Excel, you might want to keep some rows or columns—like headers, for example—in view. Excel lets you freeze things in one of three ways: • You can freeze the top row. • You can freeze the leftmost column. • You can freeze a pane that contains multiple rows or multiple columns—or even freeze a group of columns and a group of rows at the same time. ![]() So, let’s take a look at how to perform these actions. Freeze the Top Row Here’s the first spreadsheet we’ll be messing with. It’s the Inventory List template that comes with Excel, in case you want to play along. The top row in our example sheet is a header that might be nice to keep in view as you scroll down. Switch to the “View” tab, click the “Freeze Panes” dropdown menu, and then click “Freeze Top Row.” Now, when you scroll down the sheet, that top row stays in view. To reverse that, you just have to unfreeze the panes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |