Follow US:

Practice English Speaking&Listening with: How to Always Enter Data at The Top Row in Excel

(0)
Difficulty: 0

Hello everyone welcome to excel 10 tutorial. In this advanced Excel tutorial

I'm going to show you how you can always enter data at the top row in Microsoft Excel.

Lots of people have asked me to do this and here we go. In this tutorial

we'll always enter our data in Row 2 Ok? let's get started.

Excel 10 Tutorial [Music]

Take a look at here. We have a data entry

from name, email, profession, age and number, and we want to enter the value here in

row two and whenever we press enter in cell E2 the data should be moving

downwards okay? And we'll get another blank row here.

In row two okay? so let me show you how you can do it. First

click on sheet tab, actually right click here. Click on View code and write the

code. I have already written the code subscribe to the channel and sign up the

form if you want to get this code. Now in this code take a look at here if target

cells column 5. A B C D E and that is five okay and then if target cells row

equal to two we have selected row two because we have our heading or we have

our title in row 1 okay? This is why we have selected row two if range E you can

see our last entry point and range E2 again our last entry point and here

we'll insert a new row okay and then select range A2 our starting point now

let me show you how it works okay close the vbe and start entering your data

name Kazi email profession age number. Lets say this is my number and whenever I press

enter you can see we have just added a new row in row two and we can start

entering data again and you can take a look at here cell A2 is already selected

so we can start typing right from here okay let's see it again

the name email profession age number and press enter you can see we just move

that data downloads and we created an empty row just above it and then we just

selected our data entry starting point hope you understand what I am trying to

do so this is how you can always enter data at the top row in Microsoft Excel so

this is what I wanted to show you thank you thanks for watching see you in the

next tutorial and if you can, please support the channel on patreon.com

which is patreon.com/excel10tutorial thank you very much see you in

the next tutorial

The Description of How to Always Enter Data at The Top Row in Excel