Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can I make column And row in microsoft excel?

user-image
Question added by Md. Abdul Barik , Government Project, Bangladesh , a2i, PM Office, Bangladesh
Date Posted: 2013/10/26
Mohammed Yaseen MBA  PMP®
by Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

Insert rows on a worksheet
  1. To select rows, do one of the following:
  • To insert a single row, select the row or a cell in the row above which you want to insert the new row. For example, to insert a new row above row5, click a cell in row5.
  • To insert multiple rows, select the rows above which you want to insert rows. Select the same number of rows as you want to insert. For example, to insert three new rows, you need to select three rows.
  • To insert nonadjacent rows, hold down CTRL while you select nonadjacent rows.
  1. On the Insert menu, click Rows.

Tip    You can also right-click the selected rows and then click Insert on the shortcut menu.

Tips

  • To quickly repeat the action of inserting a row, click the location where you want to insert the row, and then press CTRL+Y.
  • If there is formatting, you can use Insert Options to choose how to set the formatting of the inserted rows.
Insert columns on a worksheet
  1. To select columns, do one of the following:
  • To insert a single column, select the column or a cell in the column immediately to the right of where you want to insert the new column. For example, to insert a new column to the left of column B, click a cell in column B.
  • To insert multiple columns, select the columns immediately to the right of where you want to insert columns. Select the same number of columns as you want to insert. For example, to insert three new columns, you need to select three columns.
  • To insert nonadjacent columns, hold down CTRL while you select nonadjacent columns.
  1. On the Insert menu, click Columns.

Tip    You can also right-click the selected cells and then click Insert on the shortcut menu.

Sajid Hussain shah
by Sajid Hussain shah , Business Manager , AlFalah Business Group (Electronics & Home Appliances)

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.

Sulaiman Ssempijja
by Sulaiman Ssempijja , MANAGER , RODMAN IT SOLUTIONS

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   

More Questions Like This