That way they won’t be confused about which column contains what data, thereby preventing them from needlessly going back to the first page of the spreadsheet and matching up columns. To simplify the experience for your spreadsheet readers, consider setting your page options to display the top row, with all of your column labels, at the top of every spreadsheet page. There aren’t really any foreseeable problems with the situation when dealing with a single page spreadsheet, but multiple page spreadsheets can be tricky when they’re printed on paper, specifically if the spreadsheet has a lot of columns. While it would be nice to only work with Microsoft Excel 2010 on a computer, it’s probable that the spreadsheets you create in that program will have to be printed out for someone. Click the row number you wish to repeat.Click inside the Rows to repeat at top field.Use these steps to display the top row on every page in Excel 2010. The only difference is that this time you’ll have to select the “Freeze First Column” command on the dropdown list at the top.Repeating the top row on every page when you print in Excel is a great way to make the data easier to read. If you wish to freeze the first column instead, the process is pretty much the same. Once a row has been frozen, Excel automatically inserts a thin gray line below it. From the options listed, select “Freeze Top Row.” This will freeze the first row, no matter what row you happen to have currently selected.Click on the “View” tab at the top and select the “Freeze Panes” command.Alternately, click on any cell along the row and then press “Shift” and the spacebar. To do so, you need to select the row number on the extreme left. Open the Excel worksheet and select the row you wish to freeze.This is usually the top row in your workbook. How to Freeze a Single Row on Excelįirst, let’s see how you can freeze a single row of data. It works pretty much like using pins or staples to hold large bundles of paper in an orderly, organized manner. This helps you to remember exactly what kind of data a given row or column contains.
As the name suggests, freezing holds in place rows or columns of data as you scroll through your worksheet.
0 kommentar(er)
