It should have the position right under the required lines (to the right of the required columns). However, the cell must be not placed in the fixed area. Make a cell at the intersection of the fixed rows and columns active. You have a task – to freeze the selected area, which contains two columns and two rows.
How to freeze the row and column in Excel
To freeze several columns, select the cell at the page bottom (to the right from the fixed column). Now, when the document is scrolled to the right horizontally, the needed column will be fixed.Pin the first column in the menu you will see. Select any cell of the chosen table so that Excel understands with what data it will work.For his comfort, the user must freeze the first column, containing the lines’ names in horizontal scrolling. It is not concentrated in columns, but located in rows. Freezing columns in Excelįor instance, the information in the table has a horizontal direction. There you must always (!) activate the cell under the freeze row. In earlier versions the “Lock areas” tool is located in the “Window” menu on the main page. Note: This method works for 20 Excel versions. Thus, you can fix two, three, four and more rows. When you perform horizontal and vertical scrolling, the cap and the top row of the table remain fixed. This action will help Excel to “understand”, which area should be fixed Select any cell under the line, which we will fix.Doing it is possible and easy, when you follow these steps: For instance, another row or even a couple of rows must be fixed when scrolling the document. Let us suppose, a user needs to fix not only the cap. Use the Keyboard to Change Row Height and Column Width in Excel 2007 (helpdeskgeek.Locking several rows in Excel while scrolling.How to add background in Microsoft Excel 2010 ().Maybe composing in Google docs or the like would be a better idea? Related Articles I’ve discovered (having lost this article once) that WordPress doesn’t seem to autosave all the data in a blog post (not my main text, anyhow-though my zemanta assisted keywords and meta-stuff remained).
This experience with not being able to freeze panes in Microsoft Excel 2008 for the Mac left me with this thought: in other words: one practical reason I started this blog was to remember/record ways of helping keep track of vital things I’d learned in an easy-to-find place, while sharing them with other people. Having to research this tip helped me remember why I was blogging, and lifted me out of a doldrums of existential questioning about the life of this blog itself, at least for the moment. Use “Normal” view, not “Page Layout” and Freeze Panes will work fine.
If you find yourself asking “How do I freeze panes in Excel 2008 for the Mac?” and can’t freeze panes because the option is gray / greyed-out, ghosted, or whatever you call it, here’s your answer: (The above forum thread has the answer at the bottom-as the last post.) This answer was found on the following help forum thread: “ Excel Freeze Panes ghosted – Why?” which taught me an invaluable lesson about forum diving:įorum Help Tip #1: Scrolling to the bottom of a help forum may save you some time, though I may have learned more by reading the whole thing. I like the “ Page Layout” view because it gives you the feeling of holding ordinary paper, and gives you the view of what your printed Excel sheets will look like, but because freezing panes does not affect printing, it cannot thus affect how “Page Layout” view will look. The reason would be that you’re in the Page View mode, rather than the Normal View mode-which can be selected from the “View Menu.” You might have a problem using this option, if you’re working in Mac’s Excel 2008. (This is from a list of Excel tutorials-which did seem to pose some problems for a few people accessing it.) One thing that you may have learned to do (in older Excel versions) is keep data relevant by maintaining the visibility of row-header (left column) and column-header (top-row) title information by using the Excel option freeze panes from the window menu. Okay-so if you’re using the spiffy new Excel 2008 for Mac-you may have had the chance to learn some new things over and against the older versions. I’m sure the tip in this article for Excel 2008 for the Mac will apply to other versions as well. I love Excel 2008 and its other versions, though I always am aware of ways that things can be improved. We all love the ability to organize data, in spreadsheets.