What are the shortcuts to insert Rows and Columns in Excel sheet?

Start networking and exchanging professional insights

Next Question:
How to Insert pivot Table in an Excel Sheet?
Posted by:
Zafar Iqbal
23-September-2013

Microsoft Excel

Question added by Mohammed Sufiyan , Administration Coordinator , Offset Construction L.LC
Date Posted: 2016/12/25

Upvote (0) Views (17) Followers (4) Answers (3) Report Question

Write an Answer
Register now or log in to answer.

3 Answers

by Firas Shahadi , Training And Development Director , Muhayal Assir National Hospital

Very useful and practical question

Methods:

use Ctrl++ then choose inter entire row.
select number of entire rows using Ctrl+Space then expand the selection as you need then Ctrl++ that will add the same number of highlighted rows.
the same with Columns.

thank you for your question.

Upvote (2)

Downvote Reply () Report

by Shoaib Ahmed , Administration Manager , Jobeco Group

We insert rows and columns in excel by pressing CTRL+ (+) key. On the other side we delete columns and rows by pressing CTRL + (-) keys. Please note that after pressing CTRL only Numeric side keys of (+) and (-) will work.

Upvote (0)

Downvote Reply () Report