5/25/2019 0 Comments Excel 2011 For Mac + Freeze PanesTo Freeze Panes: Split the window into panes, then select Window Freeze Panes from the menu. To Save Workspace Settings: Select File Save Workspace from the menu. To Print a Specific Area: Select the cell range you want to print and select File Print Area Set Print Area from the menu. If your data set is large and it is difficult to see which values correspond to what heading, you can “lock” the first column or the top row in place while you scroll. To do this, go to the View Ribbon, click on the Freeze Panes icon in the Window Group, and choose either Freeze Top Row or Freeze First Column (you would have to do this one at a time if you wanted to freeze them both). Once you freeze the panes, you need to unfreeze them to either adjust them or add another pane. To remove the pane(s), go back to the Freeze Panes icon in the Window Group, and and you will now see the option Unfreeze Pane. If you click the Split icon (View Ribbon > Window Group), it will add a horizontal and vertical split in your document that you can adjust, and then freeze. You can also drag the panes into position: 1. ![]() At the top of the vertical scroll bar, there is a thick bar. Move your cursor over this bar and it changes to two parallel lines with an arrow. Click and drag to divide the window vertically into panes. Adjust the split so that the first row (or two) is the only row in the top pane. To set a horizontal pane, use the similar thick bar at the lower right corner of the scroll bar and drag it to the left. Andy emulator mac download. Once you have the column and row headings in place, you can scroll left to right and top to bottom and they will remain in place. This can be very useful to manipulate your data – see the section for more information. 760How do I freeze/fix column or row headings in Excel? Excel 2013 and Excel 2010 When you work with a large Excel worksheet, it's often difficult to remember exactly what kind of data, columns or rows contain once you begin scrolling around the sheet.
0 Comments
Leave a Reply. |