Register now or log in to join your professional community.
Tip You can also right-click the selected rows and then click Insert on the shortcut menu.
Tip You can also right-click the selected cells and then click Insert on the shortcut menu.
To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can either lock specific rows or columns in one area by freezing panes, or create multiple worksheet areas that can scroll separately from each other by splitting panes.
For information on SCROLL LOCK, see Turn off Scroll Lock. For information on how to include row and column headings on every printed page of a worksheet, see Print row and column headings on every printed page. For information on worksheet protection, see Protect worksheet or workbook elements.
In Excel
open the spreadsheet ,highlight / select column or row, Right click , Insert , Column right or column Row (Row below, Row Above), using left click
Another alternative borders around the data in the after printing
Select the data, Right click, Format Cells, Select border from the dialog box, choose the linestyle of your choice and line color, Click ok from the dailogbox