#Freeze rows microsoft excel for mac 2011 how to#
How to Freeze the First Column and the Top Row First, select Cell B2 Next, click the Layout tab and navigate to the Window group Click Freeze Panes ribbon (17) How to freeze multiple rows in Excel Microsoft Excel allows freezing only rows at the top of the.
#Freeze rows microsoft excel for mac 2011 mac#
You can also configure your spreadsheet so that the top row prints on every page. How to Freeze a Row in Excel Mac SoftwareKeep. Click on the Freeze Panes button and click on the Freeze Panes option in. Click here to check out a great, affordable external hard drive with a ton of storage space. Then select the Layout tab from the toolbar at the top of the screen. External hard drives are great for this, as you can connect and disconnect them as needed. If you create a lot of important spreadsheets, it’s a good idea to back them up in case your computer’s hard drive crashes, or in case your computer is stolen. If you want to change this setting, return to the location in step 3, then click the Unfreeze option.
You will note that this row remains stationery as you scroll down your spreadsheet. To freeze just one row, click the View menu, and find the Freeze Panes button (if youre using Excel 2011 for Mac, click the Layout menu to find the Freeze Panes button) When you click the Freeze Panes button, you can choose Freeze Top Row from the expanded Freeze Panes options. Step 3: Click the icon highlighted below, then select the Freeze Top Row option. Step 2: Click the green Layout tab at the top of the window. Step 1: Open your spreadsheet in Excel 2011.
You can freeze other sets of data in Excel 2011 if you so desire, but this article is going to focus on just freezing the top row. The reason for specifically freezing the top row in Excel is because most spreadsheets will use that row to label the type of information that is in that column. Keep Column Headings Visible While You Scroll
Fortunately you can freeze the top row in Excel 2011 so that it remains visible while you scroll down, allowing you to easily identify information. This presents an unfortunate problem, as you can find yourself scrolling back up to see what column a data cell belongs to. They also tend to have many rows on data, usually enough that you will need to scroll down to see everything. Spreadsheets with a lot of data, especially spreadsheets that deal with sales or reporting data, can have a lot of similar columns. In Excel 2011 for Mac, you can hide entire worksheets or just some columns or rows.
0 kommentar(er)
